Due Date cannot be today
Good Morning,
Is there a way to restrict a date field?
So there is a table for Task Z. Dept. A creates new tasks, however, once created the second step in the process is done by Dept. B and ther...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry 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
------------------------------
That did it. Thank You!
------------------------------
Brianne Jacobsen
------------------------------