Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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, ' & '),'')