I have a form set up for Realtors wanting to schedule a showing for a property. I am using the Date field (with time enabled) as the “Start Date and Time” and a DATEADD field that calculates a new Date and Time based on a Duration field. Everything is working correctly in the Airtable spreadsheet. However, if I attempt to automate a trigger to set up the event in Google Calendar, the Date and Time are not correct. It seems that the data is being parsed incorrectly.
Airtable automation to add event in Google Calender parsing date and time incorrectly
**This is the Data being returned from the Airtable Fields
This is what is being pushed to Google Calendar
I have tried setting the Date Format switch
“Use the same time zone (GMT) for all collaborators” off and on and get the same result
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.