JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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 iAsked by KWTCBOISE on November 11, 2016 at 07: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?
-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.)
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.)
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.
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
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.
I hope this helps. Please feel free to contact us anytime if you have other questions regarding this.