Skip to main content
Question

How to do validation ?

  • December 9, 2020
  • 0 replies
  • 23 views
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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • December 9, 2020
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/
------------------------------
    Terms & ConditionsAccessibility statement