The first thing to check is your Google Calendar settings, to make sure that it is set to display calendar events in your current time zone.
If that’s set properly, then go back into your date field in Airtable and customize it. At the bottom of the time format section, there is a toggle for GMT time. You will want to turn this off to make sure that the event time automatically adjusts to your local time zone.
Also note that Google Calendar only refreshes subscribed calendars every 24-48 hours. So to see the change take place in Google Calendar, you will need to unsubscribe from the calendar and then resubscribe to it again.
If you’re on a Mac, you can use a 3rd-party calendar client like BusyCal which refreshes your subscribed calendars on demand, or as quickly as every 5 minutes.
Yup I did everything you mentioned when setting up the calendar but it didn’t work. I also erased and entered the date and time fields on Airtable again, and then deleted and added the calendar in Google but it still didn’t work. Any idea why this is so and how I can fix it?
Hi Lauren sorry I missed your message! It automatically fixed itself at first but later on got messed up because of daylight savings. Support gave me some workarounds but I’ve been too busy to test it out.
Here’s the primary suggestion:
In the meantime, you can add a formula field that uses a DATEADD to manually adjust your datetime to become the GMT equivalent (EST +4; PST +7) and use that for the ical link instead. (I realize it’s an inelegant solution, but hopefully it does the trick while we figure this out.