Hi! Need advice from the Community enthusiasts
Given: there is a table with formulas in columns. The table contains dates (days) and related events. The table has an offset in days: date = today + offset (it’s a weather forecast for 5 upcoming days).
Goal: the User clicks the button and the data from this table is added to the calendar. Need to collect data from several tables into one common calendar to the desired date.
Problems: 1) Getting unknown error (there is no details, so I can’t understand what exactly the problem is). 2) Adds only one event out of several.
Question: is it technically possible to add events to a calendar for upcoming days? Example: Today is May, 4. It was necessary to add May, 4 and May, 7. Only May, 4 was added.
Use case (expand)
the doc collects health statistics depending on the weather. Next, the doc receives a weather forecast and tries to predict when the user will have certain problems. Due to technical limitations, the user should look at the forecast for each problem and weather factor separately. So I would also like to have one common consolidated calendar.
I would be grateful for advice. Here’s a link: https://coda.io/d/MeteoHealth-Total-forecast_ddRAFQrmllD/_suFPg
(Go to FORECAST - > Detailed & Forecast).