How to construct a title using selection fields.

Fri, 20 Jul 2012 00:11:43 GMT

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

Re: How to construct a title using selection fields.

Anonymous — Fri, 20 Jul 2012 00:16:01 GMT

Srodrigues,

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

Regards,
Michael