Question

Date Condition on a Form

Forms

Updated August 15, 2024

asked on August 15, 2024 • Show version history

I have a form that has a required field called "Event Date." I would like to set a condition to where if the event date is more than 21 days away from the start date of the form being submitted, it rejects the form. I have the flow in place for it, I am just not sure on how to write the condition. Thanks for any suggestions.

flow.png (43.7 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on August 15, 2024

I second what Craig said. If you can prevent a process from completing for erroneous reasons, that would be better. So instead of sending them an email that it's too soon to complete, put that message in the form and essentially prevent them from going forward and submitting.

You can calculate the timer in a single line field using =IF(DATEDIF(CurrentDate,EventDate,"d")>20,"Yes","No"). Create a hidden currentdate field that automatically pulls whatever today's date is. Then use a show hide rule that if Morethan21days is Yes, you hide the rest of the form and display a message.

If you need to send the email or do an additional step and the form should still be submitted, you can use the same Morethan21days field as your conditional expression in the gateway.

2 0

replied on August 15, 2024 • Show version history

I will give this a shot! Thank you so much.

0 0

Replies

replied on August 15, 2024

I would put the condition on the Event Date field itself, and if it is outside the 21 days, display a message.

3 0

You are not allowed to follow up in this post.

Question

Question

Date Condition on a Form

Answer

Replies

Sign in to reply to this post.