Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Problem Passing Date to Google Calendar

R

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?  

Best answer by jesse

@regreenspan just wanted to follow up on this thread and close the loop! I’m glad you were able to get the formatting sorted out. Sometimes the hangups with formatting conversion happen with the “From Format” filed. You’ll want to make sure you are defining the format using these variables instead of mapping a field there: https://zapier.com/help/create/format/modify-date-formats-in-zaps#customize-date-time-options

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.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @regreenspan 

GCal can be a little fragile with accepting date/time inputs. Can you show us a screenshot of exactly how you have those mapped?

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
R
  • regreenspanBeginner
  • Author
  • Beginner
  • 1 reply
  • April 2, 2020

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.  

1 Attachments
AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@regreenspan - If you’re sure timezones are correct, one quick a dirty fix is to use the “Add/Subtrack Time” formatter step to correct for any difference.

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • Answer
  • June 10, 2020

@regreenspan just wanted to follow up on this thread and close the loop! I’m glad you were able to get the formatting sorted out. Sometimes the hangups with formatting conversion happen with the “From Format” filed. You’ll want to make sure you are defining the format using these variables instead of mapping a field there: https://zapier.com/help/create/format/modify-date-formats-in-zaps#customize-date-time-options

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.

Terms & Conditions