Salesforce Docs Portal

Guidelines for Accessing Formula Element Data in Repeatable Blocks (Managed Package)

For the managed package runtime, when you use a Formula element within a repeatable block, review guidelines and examples for accessing data within or outside the same repeatable block.

Managed Package app icon This information is for Omnistudio for Managed Packages. For Omnistudio on standard runtime, see Omnistudio Help.

Guidelines

Within a repeatable block containing a Formula element, access the data in another element by referencing the element in the Formula element’s Expression property. Use these guidelines:

Location of Data How to Access the Data
Different element inside the same repeatable block

In the Expression property of the Formula element, enter BlockName|n:ElementName.

When the Omniscript runs, it accesses only the elements in the current block.
Different repeatable block In the Expression property of the Formula element, enter BlockName|1:ElementName (where the number after BlockName| is the block’s count in the Omniscript).
Example 1: Formula Element That Accesses Data Within the Same Block
Example 1: Formula Element That Accesses Data Within the Same Block In this example, a Formula element references data from another element within the same repeatable Block element. The unlabeled block is repeatable (1).
Omniscript design for summer camp enrollment form, with an unlabeled block element (1) containing Name, Birthday, and Age fields
In the properties for the unlabeled block, Enable Repeat is selected. (Edit Block elements are automatically repeatable.)
Properties panel for block named blockUnlabeled, with Enable Repeat option selected
Properties for the Name element.
Properties panel for the Name element in the summer camp enrollment form
Properties for the Birthday element.
Properties panel for the Birthday element in the summer camp enrollment form
Properties for the Age (Formula) element include the formula AGE(%blockUnlabeled|n:childBirthday%).
Properties panel for the Age element in the summer camp enrollment form, with a formula in the Expression property
Preview shows the repeating Formula element calculation as each child’s age.
Preview of the summer camp enrollment form with two entries, with Name, Birthday, and Age fields for each child
Example 2: Formula Element That Accesses Data in a Different Block
Example 2: Formula Element That Accesses Data in a Different Block

In this example, the Formula element Total references the data from the Age element, which is in a different repeatable block.

Omniscript design for summer camp enrollment form, with Name, Birthday, and Age plus a Formula element labeled Children Under 5. An arrow points from Children Under 5 to the Age element.
The properties for the block and elements within Child Information are the same as in Example 1.

In the properties for the Formula element Total, the formula COUNTIF(%childAge%, <5) references the Age element in the previous block.

Properties panel of the Formula element Total, with the formula in the Expression property
Preview shows the total entries that meet the criterion in the formula, by using data from the Age element.
Preview of the summer camp enrollment form with entries for two children and the total number of children under 5