Forum Discussion

SuyashJadhav's avatar
SuyashJadhav
Qrew Member
5 years ago

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 but I unable to figure out How to do This can Anyone Please Help Me ?


------------------------------
Suyash Jadhav
------------------------------
Custom Data Rules
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    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/
    ------------------------------