Feature Request: Time Slot Reservation Widget | Need a real date picker to avoid double booking!

  • Profile Image
    opmovers
    Asked on April 11, 2017 at 06:50 AM

    Common scenario:

    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. It seems that JotForm has no reliable method to prevent this. the widgets suggested so far are useless, unless one constantly updates them manually with new job bookings, But this would be utterly redundant and a huge waste of server time.

    Logical Solution:

    Date validations should be dynamically compared to previous form submissions in a database to avoid double booking. Kind of like an enum column in a spreadsheet that keeps growing as forms are submitted.

    Correct me if i'm wrong but currently there are no date picker, reservation, appointment maker or scheduling widgets that fully prevent double booking between multiple unique form submissions.

    Please share if someone found a solution that works.

  • Profile Image
    Rose
    Answered on April 11, 2017 at 09:06 AM

    First of all, we are sorry for this inconvenience. 

    Your thread was duplicated and my colleague has already answer your question in this thread.

    However, I would like to give you some extra information about your concern. I checked tickets for this issue and found a ticket opened already. It was replicated only if there is one slot left and users submit the forms at the same time. In other words, lets say two people open your form when there is 1 slot left for a date. First user selects the slot and submit the form. The form will not be refreshed automatically on second user browser after first user submission. So, the second user can also make a reservation for that slot. 

    If you provide us the form Id were you have this problem, we will make a further investigation and open another ticket if it is necessary.

  • Profile Image
    Op
    Answered on April 11, 2017 at 11:29 AM

    All my forms have that problem I manage to duplicate the problem by simply selecting the same date and time on two consecutive form submissions to the same form. It's happening because there seems to be no option for the date picker to query the forms spreadsheet or database to limit calender selections to future and not appearing in said forms database. Just pick any of the forms in my account. You'll see.

  • Profile Image
    david
    Answered on April 11, 2017 at 01:43 PM

    The Date Reservation widget is made specifically to allow for one select per day:

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

    Here is a quick test form to show how it works:

    https://form.jotformpro.com/71004980552957

    As soon as a submission is received, the selected date becomes disabled in the calendar.

    Other solutions that only allow for limiting quantity, as you previously stated, require updating the form manually to include new options. 

  • Profile Image
    opmovers
    Answered on April 13, 2017 at 09:19 AM

    That widget is a step in the right direction. Just need to expand it's capabilities to allow for time slots.

    Perhaps when a user clicks on a day, a dialogue pops up with available time slots. Unavailable time slots are greyed out and once there are no more available, then the day on the calendar is greyed out.

    Hoping the powers that be are reading :)

    Cheers

     

  • Profile Image
    seth
    Answered on April 13, 2017 at 11:03 AM

    Hello,

    I am forwarding your request to our developers team. They will work on that feature. We will notify you via this thread, however, we can't give you an ETA.

    Thank yo very much for sharing your thoughts and requesting this kind of useful feature.

    Regards.