Nathan Phillips (CW) 2/21/2011 1:28:19 PM
Is there any way to make this work in a concatenated Summary column?
If the Concatenate function used a <br /> tag as the separator, that would be perfect.
Here's what I'm trying to do:
I have a database of visits to hospitals. I'd like to create a stacked list of people who have visited the hospital, with contact info on each item. Like this:
John Smith - 123-456-7890 - firstname.lastname@example.org
Jane Summers - 098-765-4321 - email@example.com
Where the email address is a mailto link.
I've created the Formula XHTML column on the user table which constructs the above string with a mailto link around the email address. But when I then concatenate that Formula XHTML column, the HTML is displayed as text. Like this:
<span>John Smith</span><span> - 123-456-7890</span><span><a href="mailto: firstname.lastname@example.org">email@example.com</a></span>