Context: We have an airtable form for speakers to submit a topic, bio, date, and time for their workshop and our speakers are from all over the country.
Issue: We wanted people to be able to select their own date and time. From there we had an automation that, once we changed the status internally on the grid view to “Add to Calendar”, the automation would add the event to Google Calendar. It all worked perfectly until we had someone from another time zone use the form. We’ve tried toggling on and off the “Use GMT for all collaborators” and we tried telling people to enter the time zone as Eastern, but in both cases we haven’t been able to have this process flow as intended.
Are we missing something?
Is it possible for someone to enter a date on a form and have that form consistently give us a date/time in Eastern?
