How to validate date to avoid double booking?

  • opmovers
    Asked on April 11, 2017 at 7:28 AM

    I'm pretty sure she means 2 different clients, 2 different form submissions, BOTH PICKED THE SAME DATE AND TIME. That is what most people would understand double booking to be. What Kiran is describing would be considered a single user double submitting (probably because they made an error the first time)

    I need a safeguard from double booking, Date validations should be dynamically compared to form submissions in a database to avoid double booking. Kindof like an enum column that keeps growing as forms are submitted

  • Kiran Support Team Lead
    Replied on April 11, 2017 at 7:49 AM

    Unfortunately, checking the date and time of a submission to avoid duplicate submission is not possible at this moment. However, if the event is having different slots, you may consider using one of the widgets that might help in restricting the double booking:

    https://widgets.jotform.com/widget/multiselect_grid

     

    https://widgets.jotform.com/widget/appointment_slots

    https://widgets.jotform.com/widget/date_reservation

    Let us know if that helps or if you are referring to something different. Thanks!