Knowledge: Count specific rows in a repeater
Back
    Title*Count specific rows in a repeater
    ManualTips and Tricks
    Created27/04/2022
    Detail

    If 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>

    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages