InfoPath Dev

How do I get the Item Number to increment when I add new rows to my table?

JK

Hi ncjks,

1. Double click on “Item Number” text field.
2. Click on “fx” button in Default Value region.
3. Click on “Insert Function” button in “Insert Formula” window
4. Select “All” Category and select “position” function in “Insert Function” window.
5. Click on O.K 3 times.

When ever you add a new row then it will automatically increment the Item Number

Position() is not working.

THis is the item number text field in the puschase order template. Everytime I add a new item, the item nuber is repeated as "1"

JK

You can use one of the two forms below. Check out the MSDN blog for more detail explanation.

count(parent::*/preceding-sibling::*) + 1 - assuming all nodes in the parent nodeset are of the same type, otherwise:

count(parent::*/preceding-sibling::<type>) + 1 where <type> is the type of the parent node



http://blogs.msdn.com/asanto/archive/2004/09/08/226663.aspx

Hi ncjks,
Check this tutorial in InfoPathDev
http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb02632966e8127


Regards,
Abhishek

I see this working on a simple form but not in the structure I coped from the purchase order template.

All I ever get is a "1"

JK