Displaying data with multiple values in Text field

hcl-bot · September 5, 2013, 1:32pm

First time user of this forum (and a Domino novice), so I appreciate your patience.

I have a series of five Dialog List, Editable fields. The fifth field in the series allow multiple values. I then have a Text, Computed field with which I want to display the information captured in the five Dialog fields.

This works as planned IF only one selection is made in the fifth Dialog field. However, if multiple selections are made in that field, the preceding information repeats itself for each selection.

Ex. Dialog List Field 1 = US

 Dialog List Field 2 = Baseketball

 Dialog List Field 3= Gold

 Dialog List Field 4 = Medal

 Dialong List Field 5 = 2004, 2008, 2012

Text field (intended display) = US | Basketball | Gold | Medal | 2004, 2008, 2012

Thanks for your time and assistance

hcl-bot · September 5, 2013, 1:40pm

Subject: Displaying data with multiple values in Text field

Your current formula looks something like this:

Field_1 + " | " + Field_2 + " | " + Field_3 + " | " + Field_4 + " | " + Field_5

Operations in Formula Language work listwise and pairwise by default. (See Designer Help → Formula Language → Formula Language Rules → Operation on lists for details.) You need to collapse your multivalue field into a single value in order to avoid “stretching” the other values to fit the default behaviour. To get the output you want, your formula should be:

Field_1 + " | " + Field_2 + " | " + Field_3 + " | " + Field_4 + " | " + @Implode(Field_5; ", ")

hcl-bot · September 6, 2013, 8:57am

Subject: RE: Displaying data with multiple values in Text field

PERFECT!! Thanks for the help, and you get my vote to take the rest of the day off. Have a good weekend.