I was very excited to have an interview scheduling system using Airtable Forms in the base my team uses to hire over 100 teachers per month.
After having candidates booking interviews via Airtable, the “Create G Calendar event” automation would do the last interview booking confirmation step by creating a G Cal event as soon as an interview time slot would be booked. Unfortunately, the automation misbehaves when the user is not using the same date and time format as we are (HH:MM DD/MM/YYYY). The events are not added to the day the candidate has booked.
I have tried several times and in several ways to find the core of this problem by changing, but I have failed miserably. When testing the automation internally from different devices and in different time zones, it has worked fine. However, when candidates book, the automation creates an event on the day when it is booked. Anyone experiencing a similar issue here who could shed some light? Thank you!