Workflow Functions
Note
For a list of supported functions for Standard mode tools, go to the Standard mode Formula Tool documentation.
Use functions to build expressions that perform a variety of calculations and operations.
Types of Functions
These function types are available for transforming your data. The type of data determines the functions you can use. Visit Supported Data Types for more information.
Conditional
Conditional functions allow you to perform an action or calculation using an IF statement. Learn more in the Workflow Conditional Functions article.
Conversion
Conversion functions convert numbers to strings or strings to numbers. Learn more in the Workflow Conversion Functions article.
DateTime
DateTime functions allow you to perform an action or calculation on a date and time value. Learn more in the Workflow DateTime Functions article.
Finance
A finance function applies financial algorithms or mathematical calculations. Learn more in the Workflow Finance Functions article.
Math
A math function performs mathematical calculations. Learn more in the Workflow Math Functions article.
Min/Max
A minimum or maximum function finds the smallest and largest value of a set of values. Learn more in the Min/Max Functions article.
Operators
An operator is a character that represents an action. Learn more in the Workflow Operators article.
Specialized
These functions perform a variety of specialized actions and can be used with all data types. Learn more in the Workflow Specialized Functions article.
String
A string function performs operations on text data. Use a string function to cleanse data, convert data to a different format or case, compute metrics about the data, or perform other manipulations. Learn more in the Workflow String Functions article.
Test
A test function performs data comparisons. Use a test function to identify the data type of a value, or determine if a value exists. Learn more in the Workflow Test Functions article.
Expression Editor
Functions can be built within the expression editor.
Build an Expression
To build your expression, first, specify an Output Column. The Output Column will contain the results of your expression. You can overwrite an existing column or you can create a new column. Select the Output Column dropdown and choose an existing column or select Add Column and provide a name for your new column.
Once you specify an Output Column, use any of these methods to build an expression:
Enter the function directly in the expression editor.
Select the Columns and Constants button to browse through variables that can be used in the expression. Select the variable to add it to the expression editor.
Syntax Highlighting
As you edit the expression, the editor applies a color-coding scheme to its various parts to make the parts of the expression easy to distinguish. For example, functions are gold, variables are fuchsia, operators are magenta, and strings are turquoise, a blue-green.
Functions
Select Functions to browse through categories of functions. Select the function to add it to the expression editor.
Columns and Constants
Select Columns and Constants to browse data from incoming connections and global variables.
Existing Columns: Data from an incoming connection, or from a column created in a previous expression.
Connections from Questions: Values from an Interface tool connected to the Question anchor of a tool with an expression editor, when the tool is used in an app or macro. Use the Question anchor when you want question values to be used as variables in the expression.
Constants: Global variables for a workflow that make it possible to change a value in a single location and have that change apply to the rest of the workflow.
Tools with Expression Editor
These tools include an expression editor. Tools that use an expression editor have an additional Input anchor and 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.