Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable automation to add event in Google Calender parsing date and time incorrectly

Topic Labels: Automations
887 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tomas_Herrera
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
Tomas_Herrera
4 - Data Explorer
4 - Data Explorer

**This is the Data being returned from the Airtable Fields
Screen Shot 2022-03-18 at 1.10.13 PM

This is what is being pushed to Google Calendar
Screen Shot 2022-03-18 at 1.08.42 PM

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