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

  • Profile Image
    WayneHoyle
    Asked on January 10, 2020 at 03: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 ? 

  • Profile Image
    EltonCris
    Answered on January 10, 2020 at 06: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:

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

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