InfoPath Dev

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'.

 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.

 

Thank you - that worked perfectly.