How do I pass a date from JotForm to Google Calendar correctly?

  • MyPartySupplies
    Asked on August 12, 2016 at 5:23 AM

    Hi

    I created a JotForm which requires a booking date and time field. I'm trying to use Zapier to pass that data as a detailed calendar entry to Google Calendar.

    I have set the time zone in Google Calendar, JotForm and Zapier to the same time zones (Africa, GMT+2) but the entry always appears with the dates in reverse order - it transposes the Month with the Day.

    For example: If I select today (12-08-2016 in the format DD-MM-YYYY) the entry appeas on December 8th 2016. In other words it has put the month ahead of the date.

    Any guidance would be appreciated in fixing this!

    Thanks

  • Chriistian Jotform Support
    Replied on August 12, 2016 at 7:01 AM

    It appears that this is a duplicate thread. However, I see that this has further details on your exact concern. Please disregard my response on the other thread.

    I believe the date format needs to be the same on Jotform so it can be passed correctly on Google Calendar. Can you try changing the format on jotform to MM-DD-YYYY so that the date can be passed correctly?

    How do I pass a date from JotForm to Google Calendar correctly? Image 1 Screenshot 20

    If the issue persists, please let us know.
    Regards.

  • Support_Management Jotform Support
    Replied on August 12, 2016 at 11:15 AM

    Thanks for the additional input. I'm currently fiddling around Jotform > Zapier > Google Calendar workflow and will update you once I find something, thanks in advance for your patience.

  • Support_Management Jotform Support
    Replied on August 12, 2016 at 11:52 AM

    All right, I managed to get it to work and wasn't able to replicate the problem you mentioned (where the dates and months are interchanged, regardless of what date format, timezone or time format you set on your form and account settings)

    Here's how I filled out my cloned form:

    How do I pass a date from JotForm to Google Calendar correctly? Image 1 Screenshot 50

    Here's how I received the trigger in Zapier:

    How do I pass a date from JotForm to Google Calendar correctly? Image 2 Screenshot 61

    How do I pass a date from JotForm to Google Calendar correctly? Image 3 Screenshot 72

    And here's how it was logged in my calendar:

    How do I pass a date from JotForm to Google Calendar correctly? Image 4 Screenshot 83

    As you can see on all screenshots, the date is consistent to be Aug 16, 2016 and the MM and DD were not interchanged.

    My setup for this test were as follows:

    Jotform

    1. Timezone: Singapore (GMT+08:00)

    2. Time Format: EU-Asia - DMY

    3. Date Field format: ddmmyyy

    Zapier

    1. Create Detailed Event (Google Calendar)

    2. Fields Date was selected as the Start and End dates (Google Calendar)

    I would recommend you try setting up your Zap again and ensure you haven't missed anything. Also, if you there are any unique steps that you're doing that will help us replicate the problem, please let us know so we can give it a try.

    Otherwise, from how I see it, the workflow from Jotform to Zapier to Google Calendar works just fine.

  • Support_Management Jotform Support
    Replied on August 12, 2016 at 1:43 PM

    Thanks for that bit of info, I managed to replicate it now and the issue appears to happen when the date is less than or equal to 12. Since it's the effectively Saturday now on my end, 13th, I selected Sept 12 instead. And there it was, the dd and mm were interchanged:

    How do I pass a date from JotForm to Google Calendar correctly? Image 1 Screenshot 40

    I checked how it was pushed to Google Calendar and confirmed an event was added for Dec 9 too.

    However, the issue seems to start with Zapier. I checked the DATA OUT from Zapier's Task History and JotForm pushed the correct date in the correct format (ddmmyyyy)

    fields__Date: 12/09/2016 2:00 PM

    For some reason, Zapier interchanges the dates and I'm afraid that's something beyond our control.

    I managed to find a similar thread here https://www.jotform.com/answers/197595 Although this isn't the same as the issue you're having now, he's doing the same integration as you (Jotform > Zapier > gCal) and using the Quick Add Event trigger for Google Calendar worked as a workaround for him (e.g. Add a quick event and pull the date as a field)

    How do I pass a date from JotForm to Google Calendar correctly? Image 2 Screenshot 51

    I ran another test for Add Quick Event trigger this time and it worked perfectly. The dates were not interchanged:

    How do I pass a date from JotForm to Google Calendar correctly? Image 3 Screenshot 62

    To sum it up, if you really prefer to use the Detailed Event trigger, please try contacting Zapier. Or, refer to this help page on wrong dates/times https://zapier.com/help/google-calendar/#my-events-aren39t-showing-up-on-the-right-date-or-time

    If you're okay with the Quick Add Event trigger on the other hand, give it a try and let us know how it goes.

  • Ben
    Replied on August 12, 2016 at 4:04 PM

    In my colleagues name, you are welcome.

    In regards to the thread link, please do - it should speed up the process for them to see what happens.

    To do so, you can give them this link: https://www.jotform.com/answers/904707