Setting range limits on numeric field entries
Hello everyone, I am new to quickbase app development. I have a data entry form for users to fill out that contains numeric fields for Days Hours and Weeks. I would like a way to limit the entry f...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe easiest solution is to go to the Advanced Properties for the table and enable the checkbox for data validation which they call Custom data Rules.
Build custom data rules for this table:
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Build custom data rules for this table:
Learn more about using custom data rules here
Turn custom data rules on?
So the idea is to make a formula which calculates an error message and if the formula calculates to null, then the record will save else it will abort and throw up the error message.
for Example
List("\n",
IF([Hours >23, "Sorry, Hours too high")
IF([Days >6, "Sorry, Days too high")
This will block the save at the raw database level so regardless of how the data is input, forms, grid edit, API, Imports .. the rule will apply.
So the idea is to make a formula which calculates an error message and if the formula calculates to null, then the record will save else it will abort and throw up the error message.
for Example
List("\n",
IF([Hours >23, "Sorry, Hours too high")
IF([Days >6, "Sorry, Days too high")
This will block the save at the raw database level so regardless of how the data is input, forms, grid edit, API, Imports .. the rule will apply.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------