Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoIn 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
------------------------------
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__You5 years ago
Qrew Legend
I 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
------------------------------- HarrisonSmith5 years agoQrew TraineePerfect, thanks!
------------------------------
Harrison Smith
------------------------------