Skip to main content Skip to complementary content

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.

Data to output field

inputs showing field mapped value and formula option

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

Formula selection pane

The formula options window showing all functions

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 {$} 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: {$}}
  • Example of a formula applied to a placeholder with parameters: {formula-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: {$}, 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.

Formula in data to output field

adding a formula with formula parsing

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

Raw formula in data to output field

adding a formula with formula parsing

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!