Google Calendar Intergration: Add a lookup feature to prevent overbook once a date is booked out

  • WayneHoyle
    Asked on January 10, 2020 at 3:37 PM

    Is there any way we can do a Busy free Lookup with the Google Calendar Integration?

    Or.

    Is there a system where we can look up dates for holiday let rentals?

    we have two properties, and would like to give people the option of being able to lookup the calendar associated with each property.

    We make out calendars:-

    Busy - when booked out and Private

    Free - with a price in the subject field and Public.

    once someone books - we would like to auto populate the calendar - as I do now, but people can double book because the integration won't look at the free or busy times.


    Has any one done this? or are there any recommendations ? 

  • Elton Support Team Lead
    Replied on January 10, 2020 at 6:59 PM

    Unfortunately, our Google Calendar Integration doesn't have a lookup feature where it could check if there's an existing book on the specified date. This seems to be very complex but I have escalated this to our developers as a feature request so it would hopefully be reviewed and considered in the future if it's possible. 

    As a workaround, you may want to use Date Reservation Widget for now to prevent double bookings https://www.jotform.com/widgets/date-reservation. Since widgets can't be used in Google Calendar Integration, you may copy the value from the widget to the Date Picker field through update condition.

    Example condition:

    Google Calendar Intergration: Add a lookup feature to prevent overbook once a date is booked out Image 1 Screenshot 30

    Make sure the date format of the Date Reservation Widget matches the date format of your Date Picker field.

    Google Calendar Intergration: Add a lookup feature to prevent overbook once a date is booked out Image 2 Screenshot 41

    If you need further assistance with this, let us know.