- GSNYPENNAsked on April 25, 2017 at 05:52 PM
I am creating a marketing request form.
I would like our internal staff to choose a date and then have the due date automagically return a date 6 weeks out (on a Monday - Friday.) Is there a way to do that using the calculator tool? I am guessing there is, but I could definitely use some assistance if you can show me how to code that up!
- JotForm SupportMike_GAnswered on April 25, 2017 at 09:32 PM
Thank you for explaining your concern in detail.
Yes, it is possible to automatically show a due date in one Date Field if the other Date Field is filled.
What you will be needing are two Date Picker fields.
Then, define the condition shown in the image below in your form.
The condition above means that if the "Choose a Date" field is filled, its value plus 42 (6 weeks) is going to be in the "Due Date" field.
To prevent your staff from selecting weekends from "Choose a Date" field, you can disable "Saturday" and "Sunday" from the date field's properties under limits tab.
Note: You can also disable Past dates.
I hope this helps. If you have any further questions or concerns, please feel free to contact us again anytime.