I have a custom field list called "Managers" that lists calculated data as:
Bob, Mary, Sue
I want to display this data as:
Bob
Mary
Sue
I tried this via a simple HTML substitution, but that doesn't work:
displayname=Managers
textmode=true
valueexpression=REPLACE({DE:Managers},", ","<br>")
valueformat=HTML
The "<br>" displays as text instead of being seen as code:
Bob<br>Mary<br>Sue
Any ideas/tips?
Solved! Go to Solution.
Views
Replies
Total Likes
Hi Kevin,
For me, this was more a case of "if you can't say anything nice, don't say anything at all", but since you asked twice:
"Nope"
With the exception of hyperlinks, As Designed, Workfront lists strip out all of the html special characters that would otherwise allow such "new line" breaks (e.g. <br>, <p>, <div>, \r\l, etc.)...or at least, all of those I've tried multiple times, over time.
Regards,
Doug
Views
Replies
Total Likes
erm... is this a multi-select dropdown list? (sorry, didn't understand the sentence about listing calculated data, at all...)
Views
Replies
Total Likes
No, just data in a custom field. The calculated field is just set up to output the names with comma+space between them as a string.
Views
Replies
Total Likes
It's unusual for y'all to be so quiet, so maybe I need to re-word my question:
I have a custom field that has a string of data separated by commas…
Joe, Sarah, Peter, Jane
But in reports, I have a request to display the data one per line, using the comma as a delimiter, to make it easier to read:
Joe
Sarah
Peter
Jane
Is there a way to use calculations/manipulations/tricks to make this happen?
Views
Replies
Total Likes
Hi Kevin,
For me, this was more a case of "if you can't say anything nice, don't say anything at all", but since you asked twice:
"Nope"
With the exception of hyperlinks, As Designed, Workfront lists strip out all of the html special characters that would otherwise allow such "new line" breaks (e.g. <br>, <p>, <div>, \r\l, etc.)...or at least, all of those I've tried multiple times, over time.
Regards,
Doug
Views
Replies
Total Likes
Bummer…but thanks!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies