General

Re: Concatenate field from repeating section

sabroes — Wed, 03 Oct 2012 15:48:35 GMT

Thank you - that worked perfectly.

Re: Concatenate field from repeating section

Gennady Vanin (Геннадий Ванин, Новосибирск) — Wed, 03 Oct 2012 05:32:15 GMT

There are infinite amount of ways how to screw things and usually one (or quite a few) how to make it correctly.

Probably you should have checked the original article on double evaluation:

Email Submit "To" line (loops in formulas)

Enclosed please find Infopath XSN template (file) in attachment to this post:

Concatenate field from repeating section (double eval expression trick).xsn

for your case. I have inserted defaults to facilitate testing which you might want to delete

Note that formula is:

eval(eval(group2; 'concat(my:DepartmentCode, " , ")'); "..")
and upon Edit XPath expression (advanced) checkbox checked, it would appear as:
xdMath:Eval(xdMath:Eval(../my:group1/my:group2, 'concat(my:DepartmentCode, " , ")'), "..")

and, while group2 is chosen through "Insert field or group..." button ("Insert Formula" (fx) dialog box), the my:DepartmentCode is typed/entered through keyboard.

Concatenate field from repeating section

sabroes — Tue, 02 Oct 2012 21:56:14 GMT

Hi, I have been trying to concatenate the output of a field from a repeating section (not a repeating table - but a repeating section) to a single text field outside the table. The structure of the fields in question is such: myFields > group1 >> group2(repeating section) >>> DepartmentCode So, within the repeating section - group2 - there is a field - Department Code - that I want to concatenate the output of.) I've been searching out other formulas and have tried numerous ones but none are working, however might it have something to do with the fact that its a repeating section and not a repeating table? I've tried the formula in this posting: http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/4d65ac67-e020-4150-8613-ba0909d4f0bf but receive the error message of: Type mismatch. Error occurred during a call to property or method 'Eval'.