We have products with unit costs with 4 decimal places but want our sales reps to quote unit price to only 2 decimal places. Sometimes they forget and use more decimal places and this throws the quote out as it only shows in 2 decimal places which are rounded up.
Make a formula-text field called [Warning on too many decimals] like this
IF(Abs([price]-Round([price],0.01))>=0.001,"Too many decimals"). Put that field on the form near the price field and hide the label.
Then make a form rule that says
When the record is saved
and [warning on too many decimals is not equal to (blank)
abort the save with message "Too many decimals. Correct the decimals to two places and tab out of the field and then try saving again"
(note that like Excel, QuickBase does not see the input or the corrected input until the user tabs out of the field. That can be confusing to users as they may fix the price, and then keep trying unsuccessfully to Save. Try it and you will see what I mean.
Mnookin: "On Average We Have Two Answers To Every Question"
How dichotomous! Native v Script, Yin v Yang, Geometric v Algebraic
@Mark - My analogy so I ascribed you Yin and I claimed Yang