Combining text fields for Categorized Column Problem

HCL Domino Domino Forum
1

I am attempting to take the contents of three text fields add the contents of them and place in a computed field.The contents of the three individual fields are “categories” and there can be multiple categories in each field. I want to combine categories from all three fields into one field, separated by commas into the 4th computed field. Then I want to have a view with the 4th field as the first column, categorized and sorted by all individual categories

My formula (after several attempts) is simply:

field1+", “+field2+”, "+field3

Field1 contains (abbreviated) A,B

Field2 contains C,D,E

Field3 contains F,G

The result in the computed field4 is:

A,C,F

B,D,G

B,E,G

And the categorized view appears as:

A,C,F

B,D,G

B,E,G

X

Y

Z …

The result I am looking for is for Field4 to compute to:

A,B,C,D,E,F,G

and the view to appear as:

A

B

C

D

E

F

G

…

X

Y

Z

Help is greatly appreciated!

2

Subject: Combining text fields for Categorized Column Problem

You can use colon to concatante different lists into a single list.

You said Field1 contains A,B. Is it a single valued field or multi-valued? If it’s multivalued then the formula

Field1:Field2:Field3

will merge the lists.

Regards

Litty Joseph

3

Subject: RE: Combining text fields for Categorized Column Problem

Works Beautifully! Thanks!

I searched help and forums but had forgotten the word

“concatenate” was what I was actually trying to do so I am adding it and a couple other phases to this post to help others find it easier.

Concatenation, merge fields, merging fields, combining fields

adding fields together

Thanks again!