Friday, December 17, 2010

Auto Increment Row Number in Repeating Table

When we insert a new row or item in the repeating table, the field i.e "TaskNo" in our case should get auto-generated.



Select the control, right click and select the "Text Box Properties".
Set the "Default Value" of the field, click on the "fx" button.
Type "count(../preceding-sibling::my:Repeating_Table_Name)+1" in thr formula window,
where Repeating_Table_Name is the name of the repeating table group i.e "AddTask" is the example shown".
Make sure "Refresh value when formula is recalculated" check box is selected.





No comments:

Post a Comment