Expand my Community achievements bar.

Got questions about Workfront Governance? Join our upcoming Ask Me Anything session on February 12th!
SOLVED

Is there a way to create a line break instead of comma in "Other Groups" column in user report

Avatar

Level 2

I understand there is a way to merge columns and add line breaks, but wondering if there is a way to replace commas with a line break to separate multiple values in a column in a report. I have a user report showing the "Other Group" field in a column. There are multiple values in the field/column separated by commas. I'd like to separate by line break. Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Workfront provided a shortcut to get to the "other groups" information, and the only way to put line breaks in there, would be to rebuild the column yourself instead of using what they gave you. Sample code that would achieve similar results and add the line break, would look kind of like this:

 

displayname=Other groups
listdelimiter=<p>
listmethod=nested(userGroups).lists
type=iterate
valueexpression=CONCAT({group}.{name})
valueformat=HTML

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Workfront provided a shortcut to get to the "other groups" information, and the only way to put line breaks in there, would be to rebuild the column yourself instead of using what they gave you. Sample code that would achieve similar results and add the line break, would look kind of like this:

 

displayname=Other groups
listdelimiter=<p>
listmethod=nested(userGroups).lists
type=iterate
valueexpression=CONCAT({group}.{name})
valueformat=HTML

Avatar

Community Advisor

Expanding on Skye's correct answer, you can use any proper HTML you want in these types of columns. I usually use <h> instead of <p> since that will draw a horizontal line between each entry. It helps with readability when you have some multi-line entries.