InfoPath Dev

I need to auto number repeating section row field, but unlike use the preceding-sibling option, I dont the numbers to adjust if a row is deleted. Example, if I create 7 repeated rows, the row number would be 1,2,3,4,5,6,7. But if I delete say row 3, the numbers should still read 1,2,4,5,6,7 rather than adjusting for the deleted 3.

Any ideas how to do this without code?

G'day Carlos,

Right below the default value formula box there is a checkbox that says "Update this value when the result of the formula is recalculated". If you uncheck this, it should work how you want it.

Hi Matt,

This does work great for insetions, but for a little issue where, once you delete a row, and then proceed to add an new row, the number generated is the same as the last number, eg: 1,2,4,5 and then add new repeating rows, which would then show 1,2,4,5,5,6,7 etc. So it seems to duplicate the last number, and in some cases, start the count from a previous number like 1,2,4,5,4,5,6,7. Any way around this?

Cheers,

Hm, yes, I do see my mistake now. I can't think of an easy way to do this with simple formulas / rules, but I know you could do it with a helper node. Make an extra node somewhere (probably in a secondary data source) and update it each time you insert a new row with the next number that should be used. The set the default value of the autonumber field in the table to this node, and turn off auto-update.

I think this should work, even though it is a few more steps. Hope you get it working!

Hello, I have a solution for you (which works for me): you have to put the following rule in the settings of your text box (in the default value):

"count(../preceding-sibling::my:table_row) + 1"  (where table_row is the name of the row of your table :)

 

Don't forget to tick the check box "Update this value..."

 Hope this helps.

 

Nicolas.
 

 

 

I am trying to use this code in the formula of a field in my repeating table, however, I am having trouble with the correct syntax to identify my:table_row. My form is in JScript and has the following structure..

my:myfields/my:itemisations/my:itemrepeatingsection/my:accountsdetails

...where "accountsdetails" is a (non-repeating) sub-group in the repeating section holding a field called "rowcount" in which I am trying to establish the incrementing number.

Further to the above, I cannot even get this to work on a brand new template with a single repeating table with 3 default fields (field1, field2, field3).  If I use the formula listed in this post, I simply get a '1' in field3 (being the increment field) for every inserted row.

Please Help

1. Create new form
2. Create new -repeating- group named repeating_group in  the root
3. Create new field in repeating_group called autonummer
4. Create some more fields in repeating_group as you like
5. Drag the repeating group with rightmouse from datasource on the form and choose repeating section with controls
6. Doubleclick autonummer field and set its value to count(../preceding-sibling::my:repeating_group) + 1
7. Make sure update value is checked (default)
8. Preview form and add some rows