How can I integrate my form with Google Calendar so clients choose a date?

  • alexaprisco
    Asked on September 23, 2016 at 7:25 PM

    Hi there, I am a big user of JotForm and after seeing the Square integration yesterday, I immediately got to work on integrating the booking process for my photo studio rentals.  Until I saw the Square integration in Jotform, I was planning on using Square appointments solely, however, now that you do have an integration between Square and Jotform, I think it might make more sense as it would allow me to consolidate several processes into one.  With that, I would like to explain my booking process so I can lay out what I understand and what I need help with. 

    THESE ARE THE PROCESSES I WOULD LIKE TO CONSOLIDATE INTO ONE BOOKING WORKFLOW IN ONE COMPREHENSIVE JOTFORM "FORM".  

    1.     Client goes to my website and decides to book a time slot to use the studio.  

    2.     Client Inputs Their Information (Easy Peasy)

    3.     Client selects the date/ time block/ they want.  

    A.     (This was something I was having trouble with.)  

    1)     I need a tool that will use my google calendar to determine the dates I am available and not available.  

    2)     Accordingly, when someone books, I would need that new event to automatically add itself to Google Cal and in turn, be listed as "unavailable".  

    3)     I know that at least 2/3rds of this can be done through Zapier, however, the main calendar and date selection integration is something I cannot figure out.

    B.     I thought of a couple solutions for this.  

    4)     I thought I could use a standard widget that would allow me to "embed" Square's appointment tool so that the time itself could be blocked.  

    5)     I could use a completely different booking calendar that I could embed into a widget in case Square appointments conflicts.  

    6)     Due to the nature of my business, I wouldn't have time to manually adjust my availability inside of the widget in Jotform every day.  

    C.     I guess if a calendar integration is completely impossible, I could have the Square appointment booking be the first part of a two part booking process?  

    4.     Client checks off the "included" add ons they want. 

    5.     Client selects the "extra" add ons that will increase the price, i.e. light rentals, wardrobe, second studio etc.  

    A.     From my understanding, I can create new items for Square through the Jotform integration.  I need the client to be able to select the items/ upgrades they want which would increase the price of the initial time block.

    6.    

    Client will then agree to the terms and conditions via Echo-Sign Integration by signing.

    7.     Client will then submit payment.

    8.     Automatic reply triggering confirmation of date/ directions etc.

  • Kevin Support Team Lead
    Replied on September 23, 2016 at 11:38 PM

    So far we do not have an integration with Google Calendar, it is not possible to display dates from Google Calendar and allow users to choose an available date. 

    There are some apps that will help you to create an even in Google Calendar, but programming knowledge is required, here is the tool if you want to take a look: http://addtocalendar.com/ 

    We have a widget also that will help to pick dates and disable that selected date, here is the link so you can check it: https://www.jotform.com/widgets/date-reservation

    Regarding to Square Appointments tool, sincerely I'm not familiar with it, but I think it can be embedded in an iFrame, but do note that the info selected in the iFrame will not be shown in the submissions page. 

    The same that you may embed the Google Calendar, here is the iFrame widget where you can embed the calendars: https://www.jotform.com/widgets/iframe-embed

    4.     Client checks off the "included" add ons they want. 

    5.     Client selects the "extra" add ons that will increase the price, i.e. light rentals, wardrobe, second studio etc.  

    A.     From my understanding, I can create new items for Square through the Jotform integration.  I need the client to be able to select the items/ upgrades they want which would increase the price of the initial time block.

    This has been moved to another thread, please check here to find it: https://www.jotform.com/answers/940842 

    Client will then agree to the terms and conditions via Echo-Sign Integration by signing.

    It has been also moved, please check the thread here: https://www.jotform.com/answers/940843 

    8.     Automatic reply triggering confirmation of date/ directions etc.

    This will be achieved by adding an auto-responder, please check this guide in order to find the steps to set it up: Creating-a-Form-Autoresponder

    If you have any question, please let us know.