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.