Is there a way to have a field automatically calculate a date if give the start date and how many calendar days por business days need to be figured i

  • KWTCBOISE
    Asked on November 11, 2016 at 7:42 PM

    Is there a way to have a field automatically calculate a date if give the start date and how many calendar days por business days need to be figured in?

     

    For example:

    -Contract start date is 11/14/16

    -We have 3 business days from contract date to complete a task.

    How do I set up a field that will automatically calculate the correct date of 11/17/16.  (Doesn't include the start date of the contract.)

  • Mike_G JotForm Support
    Replied on November 11, 2016 at 7:45 PM

    Yes, it would be possible to get the Complete Date (three days after) base on the current date or today's date.

    Below is a sample form. (I didn't hide any of the fields just to show how it works.)

    https://form.jotform.com/63157374614963

    In the form above, you'll see that there is a field called "Start date(Current Date)". That field has a default value in it which is the current date.

    1478907048t1 1 Screenshot 10

    There is also another date field which is the "Complete Task Date ( 3 days after Start Date)" it doesn't have a default date. It is where the output will show.

    Then, there's the "Form Calculation" widget, where we set the calculation. 

    Start date(Current Date) + 3

    1478907510t1 2 Screenshot 21

    The Calculation field will add 3 days to the Date field (in numeric format).

    Then, we will create a condition using conditional logic (Update / Calculate field) that will pass the value of the Calculation field to the "Complete Task Date ( 3 days after Start Date)" where it will automatically be converted again to date format showing the correct date.

    1478908564t1 3 Screenshot 32

    I hope this helps. Please feel free to contact us anytime if you have other questions regarding this.

    Thank you.