Loading
Feature degradation | Gmail Email delivery failureRead More
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Guidelines for Accessing Formula Element Data in Repeatable Blocks

            You are here:

            1. Salesforce Help
            2. Docs
            3. Omnistudio

            Guidelines for Accessing Formula Element Data in Repeatable Blocks

            When you use a Formula element within a repeatable block, review guidelines and examples for accessing data within or outside the same repeatable block.

            Guidelines

            When using Formula elements inside multi-level repeat blocks, if the Formula elements are not placed in the top-level block, it appears as null or false. This can cause issues when trying to use them on the page. In the Omniscript preview, you can verify this behavior by inspecting the formula elements in the JSON. These elements are either absent, or return null or false, regardless of the intended formula logic.

            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

            See Also

             
            Loading
            Salesforce Help | Article