Working with formulas

This section shows you how to use formulas in input fields.

The input fields for most blocks automatically show possible field mapped values from preceding blocks. You also have the option to add formulas. Formulas generically refers to all of the available functions.

When you select Add formula, you have many types of functions that can be applied. Each formula is described in this section.

Basic formula syntax

When you add a field mapped value, you are creating a placeholder for data coming from elsewhere in the automation. A formula manipulates the data of that placeholder. When you add a formula to an input field, it is applied to the result of the placeholder.

For example, the placeholder {$.inputs.name} references the name field of the inputs block. You can apply a formula to that data by adding it to the front of the placeholder. Formula parameters are placed after the placeholder.

• Example of a formula applied to a placeholder: {formula-name: {$.inputs.name}}
• Example of a formula applied to a placeholder with parameters: {formula-name: {$.inputs.name}, parameter1, parameter2}

You can use multiple formulas for a single placeholder. Each formula is wrapped by curly braces. The inner formula is applied first.

• Example of nested formulas: { outer-formula: { inner-formula: {$.inputs.name}, inner-parameters }, outer-parameters }

Adding formulas to input fields

To apply a formula, first add the formula, then select the formula type, then select the placeholder and parameters. The options are slightly different for each formula.

When you toggle formula parsing, you see the underlying JSON object.