Hi,
I am in the process of making a calendar that contains tasks generated via a form. I manage to write variables such as Title (TEXT), Description (TEXT), Start (DATETIME) and End (DATETIME) in a table, and generate a calendar UX view for this table ‘task list’.
Now I want to mirror this calendar to my google calendar. I manage to import the Google calendar as a table. Now a need a bot to update Google calendar when data changes in the table ‘task list’ occur. I guess I understand how this needs to be done, and I read many treads. but still, I don’t manage to add a new event to google calendar. I assume it deals with problems in the DATETIME format. So I tried several solutions to generate at ‘start’ and ‘end’ format in the ‘task list’ table which could be picked up by google calendar:
*DATETIME from direct DATETIME input for the ‘task list’ form.
*DATETIME computed summing a date and time: datetime([start]) + “010:00:00”
*DATETIME computed using the ‘now()’ formula
*TEXT in the following format “DDMMYYYY HH:MM:SS”, “DD/MM/YYYY HH:MM:SS”, “DDMMYYYY HHMMSS”, “YYYYMMDDTHHMMSSZ”
*…
None of these options did result in a new google calendar event. I feel like I am out of options. However, this is likely a very simple problem with an obvious solution. i actually feel stupid:).
hoping for some help,
Jeroen
