Concatenate multiple person fields in one

Discussion created by JanV on Apr 11, 2017
Latest reply on May 8, 2017 by Matthias_Walter


I'm trying to concatenate 3 persons fields into one field.

Every solution that I tried failed:

[[PAD]] + [[RPAD]] + [[ServiceDirector]]

[[PAD]] ; [[RPAD]] ; [[ServiceDirector]]

[[PAD]] + ";" + [[RPAD]] + ";" + [[ServiceDirector]]

[[PAD]] & [[RPAD]] & [[ServiceDirector]]


I've added these possibilities in the 'Calculated' expression builder. The field that has this calculation is enabled for multiple persons.

Is this possible to do?


Some background info: The reason why I want to do this is because not all fields are filled in in every situation. I just want a field that concatenates all 'Owners' no matter which situation that the user has picked. The above fields (PAD, RPAD & ServiceDirector) will be placed on not visible.


Thanks for the reply.