Update Request and include date validation

I have the following sheet:
User 1 will enter the Client Name and Historical Data Load Date via a form.
This triggers an update request to User 2 to provide the FHIR Ball Catchup Set Date.
This date must be BEFORE the Historical Data Load Date.
I have the sheet set to flag the row if the FHIR date is AFTER the Data Load Date.
BUT I would like for USER 2 to not be able to even enter a date that is after the FHIR date. User 2 uses an update request form to add the date. How can I build in the logic so that USER 2 doesn't enter a good date?
Answers
-
Form logic doesn't currently allow for one cell to reference another cell and restrict values being entered. However, you can setup an Automation that notifies User 2 that the date they entered isn't valid and it can be a request an update type Automation so they can correct what they entered that wasn't valid.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!