Controls

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Doreen — Tue, 20 Aug 2013 20:37:02 GMT

Thank you! This works. I swear I tryed that formula before - I must've navigated to the field instead of typing its XPath value manually. Navigating to insert the field changes it to a . (dot) or .. (dot dot) and throws error. It seems counter to the way a formula is supposed to insert a field. I thank you very much.

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

ErnestoM — Tue, 20 Aug 2013 19:19:46 GMT

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

ErnestoM — Tue, 20 Aug 2013 19:19:06 GMT

Hi Doreen,

For rowVeh, instead of
100 + count(../preceding-sibling::*) - 1 + 1
I think you want
100 + count(../preceding-sibling::my:VehicleRows) + 1

For rowProperty, instead of
300 + count(../preceding-sibling::*) - 1 + 1
I think you want
300 + count(../preceding-sibling::my:PropertyRows) + 1

For rowEq, instead of
200 + count(../preceding-sibling::*) + 1
I think you want
200 + count(../preceding-sibling::my:EquipmentRows) + 1

I'm attaching screenshots. Hope this helps.

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Patrick Halstead — Tue, 20 Aug 2013 07:24:38 GMT

Yes, of course, please email our support (at) Qdabra (dawt) com alias. :)

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Doreen — Mon, 19 Aug 2013 22:30:45 GMT

Is it ok if I email it to you? I don't want to make the form public.

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

ErnestoM — Mon, 19 Aug 2013 21:32:31 GMT

Hi Doreen,

Working out the correct syntax for preceding sibling is tricky sometimes.

If you can attach your form, I'll take a look.

Thanks.

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Doreen — Mon, 19 Aug 2013 19:10:19 GMT

Thank you. I am unable to make anything but the asterisk (*) stick in the formula - whether it be typed in fx field with "Edit XPath" clicked or not, or if typed in the default value textbox (before clicking fx). hmmm

When I cilck Insert Field or Group, it inserts a dot (.) and spits out error."Node-test expected."
When I type in the name Example: "my:rowVeh", it spits out error "../preceding-sibling::my:rowVeh" does not point to a valid location path of a field or group."

In my uploaded example I have 3 repeating tables where row numbering starts with 100, 200 or 300 depending on the section. Note how first and last section start numbering with 2 (102, 302) instead of 1, like section 2 correctly shows (201). Each default value is typed in the same.

As a work-around I have changed the formula for section 1 and 3 to be "count(../preceding-sibling::*) - 1 + 1" and this causes numbering to start with #1.

Re: Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Patrick Halstead — Sun, 18 Aug 2013 23:34:38 GMT

Hi Doreen,

Don't use the asterisk character. Use the name of the group. For example: "count(../preceding-sibling::my:group2) +1".

Note: position() doesn't work in the browser.

Counting rows in repeating table is starting with #2 instead of 1 and sometimes...

Doreen — Thu, 15 Aug 2013 19:10:46 GMT

I have an integer field in my row called rowNumber. Default value(fx) is "count(preceding-sibling::*) + 1"

when I enter the formula as noted above, row 1 and thereafter are numbered "9"

when I change the formula to "count(../preceding-sibling::*) + 1" (and when it lets me - sometimes InfoPath balks and doesn't accept this forumula) the numbering starts with 2 and continues, skipping #1

What is the trick to numbering rows? I know about postion() but can't use that because my objective is to select a row by button click to indicate which row to copy to another textbox.