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
MarkShnier__You
Qrew Legend
Qrew LegendIn fact Custom Data rules are perfect for your situation as they do work for Grid Edit or any other method like Importing from excel or API calls, and of course regular forms entry.
The formula would be
IF(Round([Hours],0.1) < [Hours],"Hours can only be entered in whole numbers or tenths of an hour")
It's possible that there could be some weird rounding errors so this might be safer.
IF(Round([Hours],0.1) < Round([Hours],0.0001), "Hours can only be entered in whole numbers or tenths of an hour")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The formula would be
IF(Round([Hours],0.1) < [Hours],"Hours can only be entered in whole numbers or tenths of an hour")
It's possible that there could be some weird rounding errors so this might be safer.
IF(Round([Hours],0.1) < Round([Hours],0.0001), "Hours can only be entered in whole numbers or tenths of an hour")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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__YouI 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
------------------------------- Perfect, thanks!
------------------------------
Harrison Smith
------------------------------