As you enter information in your formula, real-time error checking quickly fixes or flags formatting and syntax errors and checks formula argument types.
If Quickbase detects an error, a warning icon will appear. Click the icon to view specific error messages.
Automatic error checking
After you save your formula, the software checks formula syntax, ensures fields and references are valid, and evaluates the formula to make sure no other errors exist.
Formula syntax check
Quickbase checks the formula syntax, such as parentheses placement.
When the cursor is to the right of an opening or closing parenthesis, a gray frame highlights the matching parenthesis, if there is one.
Formula validation
Formula validation occurs once the formula's syntax is correct. Quickbase makes sure that
- Field references refer to fields in the app
- Formula data types and field references match those required by functions and operators
Formula evaluation
After a formula is validated, Quickbase processes the formula and produces the result.
Some errors don't show up until evaluation. For example, if a formula refers to a deleted field the result of the evaluation is null.
Formulas are evaluated many times to ensure they work. For example, formulas are evaluated when displaying a record that contains formulas or sorting a table on a formula field.