Merging data for a SharePoint list

[You Big Dummy]

I created a repeating table with one field in it. I set the field as a column
in SharePoint and set it to merge. I insert 2 repeating tables and enter
values. I submit the form to the library but the column does not show up with
any merged data. I was told that this could be done with merge. What am I
doing wrong here?

 

[Kalyan Reddy]

Hi,

You should be entering the values in the same repeating table by inserting
fields and not in other repeating tables. The merge function acts only on the
fields and repeating table on which it is inserted and will not merge values
from other repeating tables.

 

[You Big Dummy]

So if I put in 1 repeating table. Put 2 fields in that 1 repeating table then
make 1 of thoses fields a SharePoint column. When I preview the form and
click insert I will have 4 fields now and not 2. So if I put values in those
4 fields they should all merge correct or not?

 

[Kalyan Reddy]

Hi Agan

When you have Merge on only one field of the Repeating table, It merges only
values from that Column and will not merge from the second column. So out of
the 4 fields you will get values only from the two fields only.
One work around for it will be you can promote both the fields with merge
functions on both the fields and can show the values in two different columns
on the sharepoint, or using code you can get the values from both fields into
the third field and promote this field to sharepoint.