Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Automations
223 1
Showing results for 
Search instead for 
Did you mean: 

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

**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