Forum Discussion
MarkShnier__You
Qrew Legend
2 years agoTry this
Make a new formula numeric field called [Record ID# mirror] with a formula of
[Record ID#]
That will give us a hook we can use in a form rule to determine if the record has been saved yet.
Then make a formula like this.
When the record is saved
Conditions:
all of:
[Record ID# mirror] is (blank)
[Due date] is "the current date"
ACTION:
Abort the save with message.
Sorry, but you cannot inflict a date of Today as the Due Date for your co-workers. They need more time than that :)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
BrianneJacobsen
2 years agoQrew Trainee
That did it. Thank You!
------------------------------
Brianne Jacobsen
------------------------------