I am using a Zap that creates a Google Calendar appointment from data originating in a Formsite form. Formsite has a date control, but no time control. I have created a time control using a list box. The date control outputs the date as “04/01/2020”. The time control outputs the time as “4:00pm”. I have another field that concatenates both controls to create a field with date in the format “04/01/20204:00pm”. The Zap works fine, when creating a detailed Google calendar appointment, except that Zapier creates a Calendar date with the wrong date and time. I have tried passing the fields singly and together. I have tried to use the Zapier Formatter application to convert the dates. Nothing seems to work. Can anyone Guide me step by step through getting the date and time in the proper format so that the correct date and time shows up on the Google calendar?
Hi
GCal can be a little fragile with accepting date/time inputs. Can you show us a screenshot of exactly how you have those mapped?
I was finally successful in creating the Start and End dates and times for the Google Event. However, when I run the Zap, the event is scheduled one hour later. I used two transformers, one to convert the date into a date format. The second adds 15 minutes to the original date. These dates are used to schedule a 15 minute appointment. I think the time zones are set correctly. Perhaps the format I am using for the conversion is not compatible with Google calendar. Attached are screenshots. Thanks for the help.
If that doesn’t work, you might check the timezones of your calendar, the app you’re connected to, and the timezone within the settings of your Zapier account to make sure they match. If they do, then we’d suggest Andrew’s fix of using the “Add/Subtrack Time” Formatter utility to correct for any difference.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.