Expand my Community achievements bar.

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>