How to do validation ?
Hello I am New in quick Base and I need to figure out How to validation actually I created a form and In Form I create Numeric Value For Expense So I wanna Set Maximum value limiit is 400 for that bu...
Forum Discussion
Validation can be done at the table level using the 'Custom Data Rules' under the 'Advanced Settings' for the table. Information about this can be found here.
Basically, you'll be adding a formula that says IF Expense >400 then show this error message. It would be formatted like this:
IF([Expense Field]>400,"Maximum limit for Expenses is 400. Please make your corrections before submitting.")
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Basically, you'll be adding a formula that says IF Expense >400 then show this error message. It would be formatted like this:
IF([Expense Field]>400,"Maximum limit for Expenses is 400. Please make your corrections before submitting.")
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
