Expression Editor

The expression editor uses functions to build expressions that perform a variety of calculations and operations.

The following tools have an expression editor: Action Tool, Charting Tool, Condition Tool, Dynamic Rename Tool, Error Message Tool, Filter Tool, Formula Tool, Generate Rows Tool, Message Tool, Multi-Field Tool, Multi-Row Formula Tool, Report Map Tool, Table Tool, Test Tool. Tools that use an expression editor have an additional input anchor, the Question anchor, when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor when you want question values to be used as variables in the expression. See Interface Tools.

The expression editor in the Formula Tool looks and behaves differently than the expression editor in other tools, but the functions perform the same in any tool.

Build an expression

Use any of these methods to build an expression: