Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
6 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 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
    ------------------------------