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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
It worked perfectly - thanks.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies