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

Question

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.

skyehansen · Accepted Answer

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

listmethod=nested(userGroups).liststype=iteratevalueexpression=CONCAT({group}.{name})valueformat=HTML

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded