General

Re: Auto number rows

Selarim — Thu, 04 Mar 2010 17:01:12 GMT

Matt Faus:
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!

Matt, I tried to do that and it didn't work...Actually, it works until the first postback (Submit button, or when I choose an user in a contact selector)...Before the postback, the numbers are "1, 2, 3, 4, 5, 6"...After the postback, it's "1, 1, 2, 3, 4, 5"...All the numbers (but the first) change...

Any idea?

Thank you..

Re: Auto number rows

patilbh — Mon, 15 Feb 2010 19:09:40 GMT

Hi matt,

The problem can be resolved with the same formula, only thing we need to do is check the checkbox to recalculate, here it works good.

Re: Auto number rows

Albert — Fri, 04 Apr 2008 09:05:05 GMT

Hi,

To reproduce follow the steps below:

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

Albert

Re: Auto number rows

PJagger — Mon, 17 Mar 2008 04:05:04 GMT

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

Re: Auto number rows

PJagger — Mon, 17 Mar 2008 00:33:14 GMT

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.

Re: Auto number rows

nikopol — Fri, 01 Jun 2007 13:27:03 GMT

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.

Re: Auto number rows

Matt Faus — Fri, 17 Mar 2006 03:05:12 GMT

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!

Re: Auto number rows

Carlos — Fri, 17 Mar 2006 00:03:04 GMT

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,

Re: Auto number rows

Matt Faus — Thu, 16 Mar 2006 23:52:05 GMT

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.

Auto number rows

Carlos — Thu, 16 Mar 2006 23:21:07 GMT

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?