What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to validate date to avoid double booking?

    Asked by opmovers on April 11, 2017 at 07: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

  • Profile Image
    JotForm Support

    Answered by Kiran on April 11, 2017 at 07: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!