Knowledge: Count specific rows in a repeater
Back
Knowledge
Title*Count specific rows in a repeater
ManualTips and Tricks
Created27/04/2022
DetailIf you have rows in a repeater with specifc values, enter the following in the OnSave Formula:
cast(XmlField1 as xml).value('count(!Xpath!)', 'varchar(50)')
and the following in the Add a repeater xpath field:
//RepeaterData/Repeat/*[@DatabaseValue="TextField2" and @Value="Rate2"]
Thiis assumes your repeater looks like this:
<Repeat UserID="1014">
<Data LabelText="Record Day or Hour" DatabaseValue="TextField2" Name="Record Day or Hour" Value="Rate2" />
</Repeat>
Additional Manual Locations