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.
The diagram below shows the form filled with only one broken Room Item.
The diagram below shows the form with the text area question visible once a second broken Room Item is added.
0 Comments
Add your comment