Add a reservation widget that will also show available slot and prevent form submissions if the date and time are already selected by other users

  • Profile Image
    cidol
    Asked on March 26, 2019 at 09:11 PM

    Hello. We would like to you use your restaurant reservation form, utilizing the date/hour picker. However there doesn't appear to be a way to set the a limit so any given date/hour can only be selected, say, 5 times and then greyed out (no longer an option for the form user to select).

    I see many requests for this functionality, but the answers offered (date_reservation, multiselect_grid, appointment_slots) do not address the issue at hand.

    Imagine you're a user going to a site to pick a date/time for your meal reservation, you're going to want to quickly select a day from a month view and any hour, conceivably in a 24 hour span. Layouts in the aforementioned widgets don't allow for that.

    Is this something you're working on, or for which you have a new solution I wasn't able to find in a search?

    I appreciate your help.

  • Profile Image
    jherwin
    Answered on March 26, 2019 at 11:39 PM

    The workaround for this is to make the date and time unique question. This will prevent the form to be submitted if the same date and time is chosen.

    Guide: How to set Form Limits Based on a Unique Question

    Please see my demo form here: https://form.jotform.com/90849022621959.

    I've also added a google calendar to show the available slot or taken slot in your calendar. This is just to show you that the submission is coming through and the same date and time is not allowed.

    Please try to submit the form twice with the same date and time and see what will happen. Give it a try and let us know if that meets your requirements.

    I am also sending this thread as a feature request to our backend team for evaluation. We cannot guarantee that the feature will be implemented or cannot provide any time frame for implementation at the moment. However, once we have any information in this regard, you'll be posted here.

  • Profile Image
    cidol
    Answered on March 27, 2019 at 01:02 AM

    Thank you for your quick response. Unfortunately this won't work as a handful of people could be accommodated at a given date/time. If we made the date/time a unique identifier, we could only accept one reservation for that date/time as opposed to enough to fill the restaurant.

    I look forward to seeing whether your developers take up the reins on this one.

    I will need to look for a solution with another provider in the meantime, which may mean transferring all my forms to someone else and closing this account.

  • Profile Image
    jherwin
    Answered on March 27, 2019 at 02:18 AM

    Your request has been passed to our backend team for evaluation. We will update you here and on your email when this feature is implemented.

    Thank you :)

  • Profile Image
    cidol
    Answered on April 13, 2019 at 05:12 PM

    Hello. I'm checking back to see if this request, that a number of submissions for 1 date/time can render that date/time unavailable. We want to use this form for a large promotion but cannot effectively unless this piece is in place.


    Did the backend team have a chance to evaluate the request? Is it approved and the development process underway, and if so, is there an estimated time for implementation?

    We appreciate your help!

  • Profile Image
    jherwin
    Answered on April 13, 2019 at 10:57 PM

    The thread has already been forwarded to our backend team as a feature request. However, the feature is currently under low priority and likely to take time to implement. If there is any news in this regard, we'll let you know here.