Forum Discussion
HarrisonSmith
5 years agoQrew Trainee
Hi, it appears neither of those formulas are working. The record is saving as usual when I try to enter a number with 2+ decimal places, and no warning message appears either.
------------------------------
Harrison Smith
------------------------------
------------------------------
Harrison Smith
------------------------------
MarkShnier__You
Qrew Legend
5 years agoI had a typo, try this
IF(Round([Hours],0.1) <> Round([Hours],0.0001), "Hours can only be entered in whole numbers or tenths of an hour")
also, did you check the checkbox to enable Custom Data Rules. The checkbox is above the formula box field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(Round([Hours],0.1) <> Round([Hours],0.0001), "Hours can only be entered in whole numbers or tenths of an hour")
also, did you check the checkbox to enable Custom Data Rules. The checkbox is above the formula box field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- HarrisonSmith5 years agoQrew TraineePerfect, thanks!
------------------------------
Harrison Smith
------------------------------