Promote Repeating table columns in infopath

By -



Promoting all the contents of a repeating table is not possible, but I found a way by using a hidden field which will have all the repeating table values concatenated and we can promote this hidden field to SharePoint.

Follow the below steps to promote the columns of repeating table , For teaching point of view I have used two columns to promote , For your point of view you can implement using the below method.

Step 1:

        Create a repeating table with two columns
  1.          Name
  2.          Number
        Also create two Multi line text box’s to store the all the repeating table values by concatenating with semicolon (;)  
  1.      Sum of Name 
  2.      Sum of Number



Step 2:

Use the below code in fx of the sum of name

eval(eval(RepeatingGp, 'concat(substring(my:Name, 1, (current() = /my:myFields/my:FieldsGp/my:RepeatingGp) * string-length(my:Name)), substring(concat(my:Name, "; "), 1, (not(current() = /my:myFields/my:FieldsGp/my:RepeatingGp)) * string-length(concat(my:Name, "; "))), ";")'), "..")

Note:

Change the xml path of fields to your requirement, they are marked in red


Step 3:

Use the below code in fx of the sum of Number

eval(eval(RepeatingGp, 'concat(substring(my:Number, 1, (current() = /my:myFields/my:FieldsGp/my:RepeatingGp) * string-length(my:Number)), substring(concat(my:Number, "; "), 1, (not(current() = /my:myFields/my:FieldsGp/my:RepeatingGp)) * string-length(concat(my:Number, "; "))), ";")'), "..")



Note:

Change the xml path of fields to your requirement, they are marked in red


Step 4:

Promote the sum of name and sum of number fields, this way the repeating table columns can be promoted


Link to download of this InfoPath I have created.

http://www.sendspace.com/file/qzo4zk

Comments

Post a Comment

Popular posts from this blog

How to copy SharePoint list workflow

By -
Image
We often face a situation where we need to copy a big workflow from list or library to another list or library. This situation can be avoided if we have created the workflow as reusable workflow. So in this article I will explain in simple steps on how to copy a list workflow to another workflow using SharePoint designer. Using this method we can copy workflow across site collections are web applications.

For this we have the following List Name Workflow Name List 1 List Workflow 1 List 2 List Workflow 2 (Copied from the worlflow1)
Step 1) We have the list 1 with list workflow 1 to be copied to list workflow 2.
Step 2) Now create a list workflow 2 , in list 2 with one condition plus once activity and save it. In our example I have used a condition and sending email to current user. This is used to create the Xoml rules for the list workflow 2

Step 3) Now in the side of navigation click All Files

Step 4) In all files click the Workflows

Step 5) Open the List workflow 1 and also repeat t…
Read more

INFOPATH FORM HIDE/DISABLE FIELDS BASED ON SHAREPOINT GROUP MEMBERSHIP

By -
Image
Hi guys in this tutorial you will get to know how to identify whether a user is part of a Share point group in InfoPath form.

NOTE:
This will work only for WINDOWS AUTHENTICATED SP sites
In this example we will use the logged in persons user name is in IT SP group. If he is in the IT SP group we will enable Submit Button and If he is not in the IT SP group we will enable Submit to IT button.
STEP 1:
Go to the SP site. Go to People and groups and create a group IT. And Add users to the group.





Added test user 1 in the SP group.


STEP 2:
Open the InfoPath 2010.

Created 3 fields Name, Emp ID, Department and 2 Buttons Submit to IT and Submit


STEP 3:
Go to the Data tab and select Data Connections





Add a Data Connection






















Read more

Generate Auto number Field in SharePoint list

By -
Image
Generate Auto number Field in SharePoint list
To create auto generated list field do the following 1.Create a column field with data type number in the targeted list. For example I am creating an auto generated column Case ID.

2.Now to make the auto generated column hidden when a new item is created in the list we have to hide it in content types.
First go to list settings-> Then in General settings go to Advanced Settings


3.In Advanced settings Click the radio button Yes , in Allow management of content types .And Click OK.


4.Now go to list settings again and a new Content types will be shown. In that click the Content type. In my case it is Item. Name may vary for you.


5.In that Content type all list columns will be shown. In that click the Case ID Column.




6.After  that click the Hidden and then click OK
7.Then open SharePoint Designer create a new workflow for the list when a new item is created
8.And add update action to the list.
9.Click Add .In set this field value select Case ID
Read more