I want to pre-populate a date based on current date calculation and selection of another field

  • Profile Image
    Asked on August 05, 2020 at 07:16 PM

    Page 2 of survey:

    Customer selection - Select Tier 1, Tier 1 requires 6 weeks to execute (30 business days).

    Opt 1:

     If the customer then selects live date based on current date is less than 6 weeks (30 business days) can the system flag this as not enough days? 

    Opt 2:

    Can the form pre-populate to 6 weeks (30 business days)

  • Profile Image
    Answered on August 05, 2020 at 09:53 PM

    Both options (1&2) are possible. But I suggest you used the Basic Date Picker field instead of the Date Picker widget for this as the widget does not work with Calculations.

    1596678341zzz 2020-08-06 09.21.02.png


    Assign values to the "Select Tier" field.

    1596678385zzz 2020-08-06 09.37.33.png

    You also need to add Short Text fields on the form to be used as placeholder for the calculated values.

    1596678448zzz 2020-08-06 09.38.19.png


    then use Insert/Calculate conditions for the needed dates (number of days) calculations.

    1596678882zzz 2020-08-06 09.47.43.png


    You can test my demo form https://www.jotform.com/202177672939971




    You can also clone my demo form using its URL https://www.jotform.com/202177672939971   so you can review in your Form Builder.

    How to Clone an Existing Form from a URL


    I hope this help. Let us know if you need further assistance.