Combining dialog list results in one text field - problem

HCL Domino Domino Forum
1

I have three fields, all dialog lists, 2 of them allow multiples. I want to combine the results of the 3 selections into 1 text field. However, because of the multiples, I can get bad results, like a cross product, which I don’t want. I just want field1 results + field2 results + field3 results.

Ex.

field1: Add, Update

field2: Table

field3: 01, 02

result field goal: Add, Update Table 01, 02

result field actual: Add Table 01, Update Table 01, Add Table 02, Update Table 02 (or something like that)…

I’m currently just using formula language in computed text field. Any help is much appreciated. Thanks

2

Subject: Don’t use the plus sign

Use a semicolon instead. Then implode them into one text field instead of a list.

Temp := Field1: Field2: Field3;

@Implode(Templ;“:”)

3

Subject: RE: Don’t use the plus sign

Oh geez, that was easy. Thank you very much.