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.