Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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>