Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Display names in a list

Avatar

Level 2

Hello,

I have the following text mode code that displays names in a shared column on a report, but the names string together like this:

AlisonTomMaryBrad

I would like them to display as a list, like so:

Alison
Tom
Mary
Brad

Here is the code:

column.6.displayname=Combined Teams
column.6.linkedname=direct
column.6.namekey=Analytics Team
column.6.sharecol=true
column.6.textmode=true
column.6.valuefield=Analytics Team
column.6.valueformat=customDataLabelsAsString
column.7.displayname=
column.7.linkedname=direct
column.7.namekey=Cvent Team
column.7.sharecol=true
column.7.textmode=true
column.7.valuefield=Cvent Team
column.7.valueformat=customDataLabelsAsString
column.8.displayname=
column.8.linkedname=direct
column.8.namekey=CXD Team
column.8.valuefield=CXD Team
column.8.valueformat=customDataLabelsAsString

I'm assuming that I'd have to change to valueformat to a list and not display as a string. Is that correct? If so, do you know how I should change the "customDataLabelsAsString" ?

Thanks!


2 Replies

Avatar

Community Advisor

I think there are a couple of different ways you can go but my go-to solution is to comment that you actually need double the number of columns I see listed. So instead of 3 or 4 columns, you need 7, and every other column will house a line break tag: <br>, or <p>, whatever you like.

 

The extra columns will all look like this:

 

column.7.sharecol=true
column.7.textmode=true
column.7.value=<br>
column.7.valueformat=HTML

 

Avatar

Community Advisor

I often use what Skye suggested, but using lists is also handy. There you have dedicated piece of textmode to cover delimitation.
e.g.

listdelimiter=<br>