General

Re: Count Question on Repeating Choice Group inside a Repeating Section with Controls

jack eagly — Mon, 21 Sep 2015 21:44:20 GMT

Thank you, this solution has saved me many times. However, now I'm trying to use it in a repeating section that has 17 stacked repeating sections created from referencing the first one. Now when I run the form my first count shows 18 rows do to the 17 other referenced repeating sections because it references SubParaSS1.

count(current()/../preceding-sibling::my:SubParaSS1) + 1

Please tell me I don't have to create 17 seperate repeating sections.

Thanks!

Jack

Re: Count Question on Repeating Choice Group inside a Repeating Section with Controls

Bre Huston — Wed, 10 Jun 2015 16:50:45 GMT

Hi Jack,

That is a common feature we implement in our forms. If you need to store the count I would use a formula as a default value, otherwise you can use a calculated value with a default. Here's an example formula:

count(current()/../preceding-sibling::my:group2) + 1

I have also attached a simple example form for reference.

With the use of current() in your formula, just be careful that the function is not deleted I you change your data source. InfoPath has a tendency to take that part out of the formula if your data source changes so you'll sure need to add it back.

Hope that helps!
Bre

Count Question on Repeating Choice Group inside a Repeating Section with Controls

jack eagly — Wed, 03 Jun 2015 19:27:52 GMT

I'm trying to add a repeating choice group under a repeating section with controls to my form. I need to add the number to the left of the choice as added. I tried inserting a function that reads

concat("(", count(..), ")") where .. is the repeating section with controls group. The formula is accepted but when I run the form and add a choice both choices read 1.

Any help is appreciated.

Thanks!