InfoPath Dev

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.

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.

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. 

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.

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

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.

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.