Forum Discussion
You can use form rules or validation rules, either or. I'd suggest just making a checkbox field that checks your date field against today and if the gap is less than 14 days check it off, then make a form rule or setup you validation rule when the box is checked and display a popup message/abort the save.
------------------------------
Chayce Duncan
------------------------------
Thanks Chayce, one question. I don't recall seeing the option to popup a message and abort the save. Is that something that shows on Checkbox fields?
Brian
------------------------------
Brian Dunk
------------------------------
- ChayceDuncan12 months agoQrew Captain
This answer is slightly different if you're on new forms or legacy - but in the 'Actions' part of the form rule there are two things:
- Prevent Save - so this wouldn't pop up with the message until you hit save but the action for prevent save will have a text input for your commentary
- Display Message and you can pick the type (modal, notification, field) that will fire immediately when your condition is met. So if you trigger the rule on the checkbox changing to true meaning their entry is now wrong it'll pop up the message.
------------------------------
Chayce Duncan
------------------------------- BrianDunk12 months agoQrew Cadet
Looks like I am on a legacy form. Is there an option to do this there?
------------------------------
Brian Dunk
------------------------------- MarkShnier__You12 months agoQrew Legend
On Legacy forms, the option is under
"When the record is saved",
There is an option to Abort the Save (with a message).
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------