GraniteHomes
5 years agoQrew Cadet
Custom Data Rule - Restrict Weekends
Hello,
Does anyone know if a custom data rule can stop a user from selecting a date that is on a Weekend?
Thanks
------------------------------
GH GH
------------------------------
Does anyone know if a custom data rule can stop a user from selecting a date that is on a Weekend?
Thanks
------------------------------
GH GH
------------------------------
- Sure
You can make this rule
IF(
DayOfWeek([my date field])=6
or
DayOfWeek([my date field])=0,
"Please select a week day date, weekends not permitted")
Then you will need to enable Custom Data Rules on the table under Advanced Properties.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------