Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Formula - XHTML
We could simply add an "Allow HTML" flag to Formula - Text columns but in this case you'll need to:
1. Perform encoding of the text by hand - call HTMLEncode() function or something
2. We can't validate the result whether the formula produces valid HTML markup - one mistake and the output will be broken beyond repair.

To cope with these problems some bits of special syntax could help:

<span style=" <% If([Priority]="High", "color:red") %> ">
<% [Priority] %>
</span>

"Code points" are designated with <%...%>. The result of the code point is an encoded text.

Whatever placed outside of the code points considered XHTML code - we'll perform validation on it.

With this, you can solve field colorization task as well as many others: produce links with dynamic content, present compact value to the user and provide details via tooltips, add third party visualization components etc.
ID
319
Category
Customization
Author

Kirill Bondar  Staff 
Date Created
3/3/2010 2:50:37 AM
Date Updated
2/2/2015 7:58:21 AM
Status
Implemented
Score
310
Promoted By
Grant SimmonsbasenineFCI ADMIN
Stephen WeltyGii SystemsDave Ellis
beoAnatoliy ZachynskiyJan Paul Roetenberg
chris dagesseNathan Phillips (CW)Rick Cogley
Flavia CalhelhawalhhornAlfredo Bravo
Ben FatchenKirill Bondar  Staff Frédérik_Dussault
Philipp Matuschkamark gardinerClaus Weisenberger
Franz SimonKevin SmithMatthew Porter
Christof SulzerPhilippe Faureinquiries@westedgesolutions.com
Anthony CarterMatan BarneaFranck Assouline
Kevin Bishop
Comments
Kevin Bishop 6/13/2007 3:18:14 AM
It would be very useful to be able to change the background colour of a field, based on it's contents. i.e. if field value is less than 10, display in red.
basenine 4/23/2009 12:24:33 AM
Definitely... Even if it just changed the value, not the background
Franz Simon 7/13/2009 3:19:50 PM
Yes please, give us just a little bit of conditional formatting. If a follow up date is today or older than today, mark it red so it is spotted immediately.
walhhorn 3/2/2010 3:25:35 PM
It seems that this could be implemented using similar logic to what is found in the existing row colorization option available in tables and views.
basenine 3/2/2010 3:35:11 PM
"Definitely... Even if it just changed the value, not the background"

What I meant here was .... even if the **_colour_**of the value changed!
Kirill Bondar  Staff  3/4/2010 3:01:38 PM
Sure, this idea is fully covered by Formula - XHTML
Nathan Phillips (CW) 7/14/2010 11:25:51 AM
This is a great idea - it would be really useful!
Rick Cogley 12/8/2010 3:52:32 PM
I can think of many interesting things to do with this.
Kirill Bondar  Staff  1/24/2011 9:38:57 AM
Merged with:
135 - Field Colourization
Kirill Bondar  Staff  1/27/2011 8:12:16 AM
Nathan Phillips (CW) 1/27/2011 11:00:58 AM
Nice! I'm looking forward to using this.
Grant Simmons 1/27/2011 11:04:42 AM
Is there a way to change the background color of the cell?
Kirill Bondar  Staff  1/27/2011 11:16:00 AM
@Grant:

<div style="<% If([Condition], "background:red", "")%>"><%=[Value]%></div>

or something alike.
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 - john@example.com
Jane Summers - 098-765-4321 - jane@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: john@example.com">john@example.com</a></span>
Nathan Phillips (CW) 2/21/2011 1:40:03 PM
Sorry, the concatenation does indeed work with my XHTML column. It produces a comma-separated list. I forgot that I had this wrapped with a Formula Text column - that clearly won't work.

What I'd like is to take that comma-separated list and make into a stacked list, separated by line breaks. With all the HTML intact.
Slava Shinderov  Staff  2/2/2015 7:58:21 AM
Today, we've added new option for Text/Formula – Text columns – colorization bases on whether the value contains certain text:
http://blog.teamdesk.net/2015/02/value-colorization-for-text-columns.html
Feedback
 
Back to Search Results