How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced?

  • LCaraccilo
    Asked on September 16, 2015 at 12:31 PM

    The problem we are running into is that people are submitting requests and we need more than 6 hours notice. Is there a way we can put a restriction or condition on the Start Time where it wont allow someone to select the time that is less than 6 hours from that moment? Thank you!

  • Elton Support Team Lead
    Replied on September 16, 2015 at 3:03 PM

    I think there's a workaround for this. Let me check and get back to you with updates.

    Thanks!

  • Elton Support Team Lead
    Replied on September 17, 2015 at 5:06 AM

    I am truly sorry for the delay. Unfortunately, I have tried any possible solution I could but none seems working base on your requirement. I will try to check with my colleagues if they have any workaround. I could not promise you anything but we will surely update you if we found any. If you also know JS programming, you should be able to achieve this using your form source code http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form.

    Thanks!

  • Elton Support Team Lead
    Replied on September 17, 2015 at 5:58 AM

    Finally, I found a workaround using conditions but it requires 24 hour time format. Please clone this form so you can figure out the setup. http://form.jotformpro.com/form/52578199817978?

    Here's how to clone a form: https://www.jotform.com/help/28-Cloning-a-Form-from-a-Web-Page

    If you'd like to try this workaround, here's a step by step instructions on how I set this up.

    1. First, I added one time field with current time enabled.

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 1 Screenshot 50

    2. I added 3 form calculation widgets, each with formula that retrieves the values from its associated time field. Here's screenshot on which fields they are connected to. So when you open the calculation wizard on each of the widgets, you will see the formula. I have also hide these fields (right click > hide field) so they will not appear on the live form.

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 2 Screenshot 61

    3. I then added a show/hide condition that hides the submit button and show an error message when the start time selected by the user is not 6 hrs in advance. You'll find it when you check the existing condition on the cloned form.

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 3 Screenshot 72

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 4 Screenshot 83

    I understand that this is a little complex but once you understand the condition, it would be pretty easy to implement them. 

    If you need clarifications with any of the steps above, please let us know. We'd be happy to help. Thanks!

  • Mike_G JotForm Support
    Replied on September 17, 2015 at 2:21 PM

    @grade4pagasa

    If this is what you mean,

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 1 Screenshot 30

    I have cloned Elton's form and added this condition,

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 2 Screenshot 41

    I hope this helps. If you have any further question, please feel free to ask. Thank you.

  • Mike_G JotForm Support
    Replied on September 17, 2015 at 2:45 PM

    @grade4pagasa

    By the way, I have moved your request to a new thread. Please click this link to go to that thread. 

    Thank you.

  • BJoanna
    Replied on September 18, 2015 at 5:08 AM

    I have cloned EltonCris form and added condition from Mike and it seems that and submit button is visible if default date is set to 19:00 hours and start date to 20:00 hours. 

    I have made new demo form with two DateTime fields and I turned ON Time option. Then I set calculation to calculate difference between dates. 

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 1 Screenshot 30

    I have also set condition to hide submit button if calculation is less that 0.25.

    How can I set up the form so it wont allow submission unless the start date is 6 hours in advanced? Image 2 Screenshot 41

    Here is my demo form: http://form.jotformpro.com/form/52601866175963? 

    Feel free to clone it.

    Hope this will help. Let us know if you need further assistance.

  • abajan Jotform Support
    Replied on September 18, 2015 at 7:40 AM

    @BJoanna

    Brilliantly simple solution to what I thought would have required lots of conditions!

    Cheers :)