Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Srodrigues,
Use concat function:
='My Company Name' & chr(10) & concat(distinct fieldName, ' & ')
Regards,
Michael
Srodrigues,
Use concat function:
='My Company Name' & chr(10) & concat(distinct fieldName, ' & ')
Regards,
Michael