Interfacing with Google calendar and JotForm Cards

  • FCMG1996
    Asked on April 25, 2019 at 6:36 PM

    Good evening, I really need your help before I lose all the hair on the top of my head as I keep pulling out clumps in frustration since I cannot get my JotForm cards to play nice with the Google calendar widget.

    Originally your support folks figured out a way to do sanity checks on the date and time fields for the start and ending periods.

    My URL is

    https://form.jotform.com/91147097319159
    I went to settings integration and then selected Google calendar integration form showed up and on Authenticated just fine. I selected my calendar FCMG events. I found a field to populate title by using the event name. But then I noticed that all my other fields were grayed out and could not select anything for start time or end time. But I noticed that there was not an option for start date and time. Please advise what I need to do to get the Google calendar integration to work. If you want to make a copy of the existing form to play with please do so.
    We are really behind our timeline to rollout this project, so anything you can do to expedite would be greatly appreciated.
    Thanks Daniel Gladstone

    https://form.jotform.com/91147097319159https://form.jotform.com/91147097319159



  • jherwin
    Replied on April 25, 2019 at 9:43 PM

    Google calendar only recognizes normal date picker. I made a demo form on how you can integrate your form to google calendar. I used two form calculation widget to get the date from your start and end date. After that, I transferred the data from the calculation widget to the newly added date pickers.

    Demo form: https://form.jotform.com/91148062838966

    You can clone the form for a closer look.

    Guide: How-to-Clone-an-Existing-Form-from-a-URL
    1556243012googlecalendar Screenshot 10

  • FCMG1996
    Replied on April 26, 2019 at 1:43 PM
    Thanks for the information. So is there a way with using the normal date picker to build in error check routines to make sure that either the start date & time is earlier than
    The end date and time and then show some time of error message and prevent them from going further until the correct the issue.
    Thanks
    Daniel Gladstone
    Email: dgeehot@gmail.com
    Phone: 501-269-3030
    ...
  • FCMG1996
    Replied on April 26, 2019 at 5:22 PM

    Please ignore my earlier response at 1:43 PM. I think you got the issue licked and when added integration it worked perfectly. The only issue that I encountered was the posting

    In the description states "jotform_untitled_markdownthis is a **test event** to see if google calendar integration is working

    not sure where that is coming from and what we can do to avoid this in the future

    thanks

    Daniel Gladstone
    Email: dgeehot@gmail.com
    Phone: 501-269-3030


  • Jed_C
    Replied on April 26, 2019 at 8:22 PM

    I tried cloning the demo form of my colleague and integrated it with my Google Calendar, but I'm not able to replicate the issue. I didn't see the "jotform_untitled_markdown" in the description.

    1556324537jf event Screenshot 10

    Can you please send us a screenshot https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum or let us know the steps on how you replicate this? 

    Looking forward for your response.