SharinPix Form Formula: Referencing Repeated Section Fields

Overview

The Repeated Section question can be used to add any number of pre-defined sections when filling out a form. Each added section can contain its own set values which can be referenced inside formula fields.

This article covers the following:

Getting Started

Referencing Repeated Section Fields

To reference a nested question from a repeated section in a formula field, use:

<RepeatedQuestionApiName>.<NestedQuestionApiName>

The above expression returns a list of all <NestedQuestionApiName> values.

Example:

Consider a repeated section with API name RoomItems with a nested question having API name Status

In a formula field, you can reference the nested Status field as shown below:

Because Status is inside the RoomItems repeated section, RoomItems.Status returns a list of values – one value for each added Room Item

RoomItems.Status will return ['Dirty', 'Clean', 'Broken'] for the Room Items below:

Demo: Displaying Comments Field Based on Broken Item Count

This example demonstrates referencing a repeated section field in a formula field within a Room Inspection example. If two or more items are broken, an additional required question will be visible to provide more information on the damage and follow-up actions required.

The diagram below shows a text area question configured with a visibility formula. This question is configured to be visible when two or more Room Items have Status "Broken"

The formula uses the COUNTMATCHES function to count the number of times the value "Broken" is found in the list returned by RoomItems.Status.