Expression Builder

While designing tasks, you will use the Expression Builder to manipulate data using mathematical, logical and other functions. In Studio 7, the Expression Builder has been updated to improve usability and to support additional functions.

Select a Function

For each expression, select a Function from the drop-down menu. The functions are organized into categories: mathematical, string manipulation, logical, premium, JSON data related and other.

Note

If you start to type the function name in the Function field then the list of functions will be filtered based on the keys you type.

For a list of supported functions refer to the Studio 6 Reference Guide.

Input Values

Dependent on the function selected, the Expression Builder will present further options.

Variables can be passed as input arguments.

  1. Type two open curly brackets {{.

  2. you will be able to select a variable from all the variables in your account.

Sub Expressions

Sub expressions can be used to build complex expressions. Use an earlier expression or sub expression as an input argument as per the illustration.

To evaluate a sub expression, press the > icon next to the expression. If your expression includes variables, you will be prompted to enter a temporary value for each variable.

Copy and Paste

You can copy and paste sub expressions between nodes.

  1. Complete the sub expression.

  2. Click the Expression Builder copy button.

  3. Click the Expression Builder remove all button to see the Expression Builder paste button.

  4. Click the paste button to paste the copied sub expression to the new node.