set conditions on date field to calculate delivery date

  • Profile Image
    killmeal
    Asked 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

  • Profile Image
    Kiran
    Answered 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
    killmeal
    Answered 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
    Kiran
    Answered 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
    2maxsing
    Answered 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
    ashwin_d
    Answered 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
    ashwin_d
    Answered 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
    2maxsing
    Answered 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
    killmeal
    Answered 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
    2maxsing
    Answered 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
    ashwin_d
    Answered 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!