How to have only selected fields in a text Title

[#1]

Thought of posting this in a new thread. Micheal had answered this one on how to construt titles with all fields.As shown below.

Use concat function:

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

The above expression in a text object gives all available fields. How do we get only the green (selected fields only) to be concatenated. 

Thanks,

Rodrigues

[Anonymous · Accepted solution]

Sorry, didn't cover that 🙂

It is even simpler:

... & replace(GetFieldSelections(fieldName), ', ', ' & ')

Need replace() to remove "natural separator (comma and space) with the desired "&"

Regards,

Michael

[#3]

This one works too.. I got an e-mail from Kiran, Wanted to post the alternative.

Thanks Michael & Kiran.

='My Company Name' & chr(10) & if(getSelectedCount(fieldName)>0,concat(distinct fieldName, ' & '),'')