Copy page

Calculations & expressions

Calculated fields evaluate JavaScript expressions stored in calculate. Field values are available as $field_name variables.

Quick example

Code
ROUND($price * $qty, 2)

Builtins by category

Logical

• IF
• AND
• OR
• COUNT
• COUNTA
• COUNTBLANK
• ARRAY

Math

• ABS
• CEILING
• COS
• SIN
• ROUND

String

• UPPER

Choice

• CHOICEVALUE
• CHOICELABEL
• CHOICEVALUES
• CHOICELABELS
• HASOTHER
• OTHER

Schema

• FORM
• DATANAMES

Control

• SETRESULT
• EVAL