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

    set conditions on date field to calculate delivery date

    Asked by killmeal on August 25, 2015 at 06:30 AM

    Hi Sir,

    I want to know how to set about the date.

    In my form, I add a "datetime", and set "Limit Dates" in properties.

    At "Start & End date" part

    I fill the start day is "today+3"

    It is because I want to control the delivery in 3 working days,

    however, When the customer order on Friday ,Saturday or Sunday, if my rules still is "today+3",  I can not control the delivery.

    Can I set a condition about as below,

    when the customer order on Friday ,Saturday or Sunday,

    the select date will auto jump to "Wednesday"?

     

    Thank you very much!

    Squall

    Page URL:
    http://form.jotform.me/form/42851606872460

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Kiran on August 25, 2015 at 08:12 AM

    The limits set on the date can be used when you want to select a date on that particular field. Since you want to calculate the dates based on today, I think calculating using a separate date field would help. Please check the following demo JotForm to see if that works for you.

    http://form.jotformpro.com/form/52363740537961?

    Here is what I did in the JotForm :

    1. Add two date fields one for getting today's date and delivery date.

    2. Today's date is automatically fetched and this field may be hidden to display on the form. I've not hidden this field to show how the calculation works.

    3. Add the required conditions to calculate the delivery date based on today's day by using Conditions Wizard. Conditions wizard is accessible by clicking on Conditions icon on the menu bar.

     

    4. Finish the wizard and save your JotForm.

    You may clone this JotForm to your account to see how it works. Let us know if you need any further assistance. We will be happy to help.

  • Profile Image

    Answered by killmeal on August 26, 2015 at 12:02 AM

    Hi, Thank you for your answer, I am happy for that!

    I have an other question about the date.

    If a customer order as my form on today (26 AUG 2015),

    then the form will be automatic to jump to 29 AUG 2015.

    However, the customer can check 27 & 28 AUG 2015,

    How can I disable these days in the calender?

    Thank you very much!

    My form: http://form.jotform.me/form/52368104429455

  • Profile Image
    JotForm Support

    Answered by Kiran on August 26, 2015 at 01:26 AM

    Since the delivery date is automatically calculated, I believe it can be a read only field so that the customer cannot change the field dates.

    Let us know if that doesn't help. We will be happy to take a look again.

    Thank you!

  • Profile Image

    Answered by 2maxsing on August 26, 2015 at 03:07 AM

    Hi Sir, If I want they can change the date?

    Do you have anyway to disable these days in the calender?

    Thank you

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 26, 2015 at 06:32 AM

    Hello 2maxsing,

    I am not sure if I have understood your question correctly. Which date you want to change? There are several conditions added and the Delivery date is calculated automatically based on today's date. Please check the screenshot below:

     

    I would suggest you to please explain your requirement a bit more in detail and we will surely help you.

    We will wait for your response.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 26, 2015 at 08:52 PM

    Hello 2maxsing,

    Well in that case you can disable the date field itself. Since the delivery date is calculated automatically, you can keep it disabled. Please check the screenshot below on how to disable the date field:

     

    Thank you!

  • Profile Image

    Answered by 2maxsing on August 26, 2015 at 09:32 PM

    Hi, Thank you very much!

    I mean is if a customer order as my form on today (21 AUG 2015),

    then the form will be automatic to jump to 26 AUG 2015.

    However, the customer still can check on the box of 24 & 285 AUG 2015,

    How can I disable these days in the calender?

    Thank you very much!

    My form: http://form.jotform.me/form/52368104429455

     

  • Profile Image

    Answered by killmeal on August 27, 2015 at 04:44 AM

    Sorry, If I want to let the customers to choose the delivery date (only after the delivery date is calculated automatically)?

  • Profile Image

    Answered by 2maxsing on August 27, 2015 at 07:44 PM

    Yes, you are right,

    I want delivery date to be automatically calculateda, and wish that all dates prior to the calculated date are disabled, but future dates are allowed - so that a person can select a delivery date that is after the one calculated. Thank you very much!

    If only today+2, will it be solved the problem?

    thanks again!

    P.S. I have done the form in Chinese as below:
    http://form.jotform.me/form/42851606872460

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 27, 2015 at 10:50 PM

    Hello 2maxsing,

    That seems to be tricky requirement. The delivery date is calculated based on the today's date but there seems to be other conditions as well where the delivery is calculated based on the day of the week.

    Unfortunately the date limit feature cannot disable dates conditionally. If you add today+2, it will only allow dates form two days after today to be selected but you have conditions where if today is Friday, the delivery date is calculated today + 5.

    Thank you!