Prevent hundredths value from numeric field
Hello, I have a field (Hours), that should have entries that are whole numbers, or decimals in tenths of an hour (2.3). A lot of the time, users enter hundredths (2.25) instead. I don't want to au...
Forum Discussion
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
Qrew LegendI 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
------------------------------
- Perfect, thanks!
------------------------------
Harrison Smith
------------------------------