How to construct a title using selection fields.

[#1]

I am trying to construct a Title based on the selections. So In the Text field expression builder I have ='My Company Name' & chr(10) & fieldName

This works fine as long as I have only one selection for fieldName. Here is the example result.

  My Company Name

     Selected Field #1

If I have more than one selection for fieldName the expression fails and returns empty. I would expect

            My Company Name

Selected Field #1 & Selected Field #2

Any Ideas ?

Thanks in advance.

Srodrigues

[Anonymous · Accepted solution]

Srodrigues,

Use concat function:
='My Company Name' & chr(10) & concat(distinct fieldName, ' & ')

Regards,
Michael