Operators are special symbols like + and * that act on one or two values to return a new value. Quickbase evaluates operators in a specific order, called operator precedence.
Operator precedence
Quickbase evaluates certain operators before it acts on others.
For example,
* has higher precedence than +.
The expression 3+4*2 evaluates as:
4*2 = 8
8+3 = 11
Types of operators
Unary operators
Act on a single value. See list of unary operators.
Evaluate right to left when there are multiple of the same precedence next to each other
Binary operators
Act on two values. See list of binary operators
Evaluate left to right when there are multiple of the same precedence next to each other
Operator precedence table
The following table lists operators from highest precedence to lowest precedence:
Precedence Level | Operator | Evaluation Order in Expressions |
|---|---|---|
1 (highest) | unary +, unary -, not | Right to left |
2 | ^ | Left to right |
3 | *, / | Left to right |
4 | binary +, binary -, & | Left to right |
5 | <, >, <=, >= | Left to right |
6 | =, <>, != | Left to right |
7 | and | Left to right |
8 (lowest) | or | Left to right |
Manually control operator precedence
Enclose portions of your formula in parentheses to manually control operator precedence.
Quickbase evaluates operators within parentheses first
Then uses the resulting calculation when it moves on to the rest of the formula