Re: Combining values from repeating section (with a multiselection list box) into one string

Patrick Halstead — Sun, 21 Apr 2013 16:27:43 GMT

Repeating fields are not a best practice because they are hard to map to separate database rows and can cause form logic to fail when accessing fields after the repeating one.

I recommend creating a group called Roles with another repeating group underneath it called Role and a field called Name inside of that.

Then, you can use a double eval technique to get your string. Something like this:

substring(eval(eval(Role, 'concat(my:Name, " | ")'), ".."), 1, string-length(eval(eval(Role, 'concat(my:Name, " | ")'), "..")) - 2)

It's a wee bit tricky. We do cover this as part of our training class and I'd be happy to send you the training lab that walks you through the technique but first you have to fix your data source.

Combining values from repeating section (with a multiselection list box) into one string

soebje — Sat, 20 Apr 2013 06:42:06 GMT

I have a form with af multiselection list box control inside a repeating section with the following structure.

I would like to have the values from the repeating section parsed to at singlefield text field (for later parsing i a database)

My fields structure looks like this

Companies is my repeating section
Name is a text field
Description is a text field
Roles is a repeating text field. Used in the form with af Multiselection list box

So form can have multiple companies
Each company has a name, description and multiple roles

A need a rule that extracts the values of the companies repeating section and parse them into the field 'CompanyInfo' like this:
CompanyAName#CompanyADescription#CompanyARole1Value|CompanyARole2Value;CompanyBName#CompanyBDescription#CompanyBRole1Value|CompanyBRole2Value,CompanyBRole3Value

So repeating section are devided by semicolons. Fields within repeating section is devided by #. And values inside Roles is devided by |

I have tried with different eval/concat combinations but can't quite get it working.

So please help with this one and let me now if additional information is required

Best regards

Søren, DK

InfoPath 2010

Re: Combining values from repeating section (with a multiselection list box) into one string

Combining values from repeating section (with a multiselection list box) into one string