Need available dates displayed to be at least 7 days after Request date

Becky Wilson

I have a form. User enters request date. I want dates that display in the due date column that they can select to be a minimum of 7 days after the due date.

Emilio Wright

@Becky Wilson I don't believe that Forms have that type of logic yet. If you have an idea of what the Due Date might be, once they submit their form you could use a helper column to add more days to the Due Date they entered. I usually do this on my forms.

Becky Wilson

Emilio Wright. Thanks for your response. hoping there is a solution.

Genevieve P.

Hi @Becky Wilson

Emilio is correct, there currently isn't a way of restricting dates in a Date field in a form. What I would personally do in this instance is have the second field be a dropdown selection of numbers... for example:

"How many days from today is this due?"

With set numbers, such as 7, 10, 14, etc. Then in your sheet you can use a simple formula to add those days to the Request date to find the Due date:

=[Request Date]@row + Days@row

See: Use Formulas to Perform Calculations With Dates

An alternative will be to keep the form as-is but add helper text above the second date saying that the minimum due date is 1 week out, noting that form submissions with earlier due dates will immediately be rejected. Then you could use a formula in the sheet to check the number of days between dates and automatically check a flag if the due date is too soon, triggering an Update Request workflow to the original form submitter to choose a different date.

Let me know if this makes sense or if you'd like to see screen picture examples of either scenario!

Cheers,

Genevieve

Becky Wilson

Thanks Genevieve. We've already got helper text. Not necessarily being followed. I like the idea of just providing a drop down list of # of days.