Forum Discussion

Qrew Captain

5 years ago

Restrict data entry in numeric field to be less than a certain value

Without using a Multi-Choice text field, is there any way to limit the values entered by user to be whole numbers between 0-11. We have users who are entering total inches into a field that is meant f...

Custom Data Rules

MarkShnier__You

Qrew Legend

This should be easy with Data Validation.

Go to the Advanced Properties of the Table and enable Data Validation. It's bullet proof as it limits data entry errors regardless of if the data entry is by form or grid edit or import or API

Make a formula which calculates to the error message words or blank. Blank means no error, but if there are words, then the save will fail and the words will display.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

MarkShnier__You

Qrew Legend

5 years ago

Austin was using better terminology.
Advanced Settings
custom data rules.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------