Skip to main content

Repeating table incremental row number or Auto number in Info Path

Dear All, 

If you are looking the auto number in your info path repeating table here is the small and best solution 

Summarized Solution 
Put the following code under you repeating text field default value
count(../preceding-sibling::my:RemoteSiteRow) + 1

Change the my:RemoteSiteRow With your Repeating Table Group Name like in my case my:OrderDetails


Complete Solution

original post 
http://nickhurstblog.com/2011/08/26/infopath-2010-repeating-table-incremental-row-number/

This post will show you how to create an auto generated row number for your repeating table in InfoPath. Having a numbered column in your repeating table helps separate the user entries:


First create a repeating table with an extra column for the Row Number. I would recommend re-naming both the repeating table and row so it’s not group1 and group2. In this example I’ve named them RemoteSiteRepTable and RemoteSiteRepRow. The row name is especially important as you will be using it in your formula. I also renamed the first field to RowNum:

Right click your RowNum field and choose Textbox Properties. Change the Data type to Whole Number (integer). Click on the function (fx) button to open the Insert Formula window and paste the following formula (renaming RemoteSiteRow to your row name) into the value field:
count(../preceding-sibling::my:RemoteSiteRow) + 1


Hit the Verify Formula button which will resolve the formula to:
count(preceding-sibling::RemoteSiteRow) + 1

Click the OK button to return to the Text Box Properties screen and make sure the Refresh value when formula is recalculated checkbox is selected and hit the OK button:

Regards 
Rashid Imran Bilgrami 
CEO - Best visualization 

Comments

Popular posts from this blog

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  

Enabling Barcode In SharePoint 2013

Enable Barcode in SharePoint 2013 Wednesday, June 12, 2013 ​To manage records and documents consistently and use record management application to handle physical records users need barcodes. We can identify the physical records corresponding to the digital objects using barcodes. To enable barcodes in SharePoint 2013, go to Central Administration -> Security -> Configure Information Policy Configuration. Select barcodes from the list. Check barcode is enabled or not by checking the availability. Check "Resources" for the barcodes(letters or numbers). In the Document library settings select "Information Management Policy settings" (Document Library settings -> Information management policy settings) Check "Enable Barcodes" check box and save the settings. Modify your view and enable bar code Upload any document. We can see the bar code for the properties of the uploaded file. Bar code was generated automati...