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

  • MAD_DTA
    Asked on August 5, 2020 at 7: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)


  • jonathan
    Replied on August 5, 2020 at 9: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 Screenshot 20

     

    Assign values to the "Select Tier" field.

    1596678385zzz 2020 08 06 09 Screenshot 31

    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 Screenshot 42

     

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

    1596678882zzz 2020 08 06 09 Screenshot 53

     

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

    I want to pre populate a date based on current date calculation and selection of another field Image 1 Screenshot 64

     

    ---

     

    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.