{"id":80,"date":"2011-01-27T07:52:20","date_gmt":"2011-01-27T13:52:20","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2011\/01\/formulaxhtml\/"},"modified":"2011-01-27T07:52:20","modified_gmt":"2011-01-27T13:52:20","slug":"formulaxhtml","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/formulaxhtml\/","title":{"rendered":"Formula – XHTML"},"content":{"rendered":"

There are small number of scenarios that go way beyond rich capabilities provided by TeamDesk<\/a>. One is conditional formatting of column's values.<\/p>\n

Formula \u2013 XHTML is introduced to provide the way to decorate the value with tags and styles. It is a mixture of limited (X)HTML markup and TeamDesk formula language.<\/p>\n

Using Formula \u2013 XHTML you can write HTML markup as is, decorating TeamDesk formula pieces (code points<\/em>) with <%\u2026%> marks; those of you who dealt with ASP should be familiar with the syntax. Each formula piece is evaluated, the result of evaluation is properly encoded and inserted in the markup.<\/p>\n

Code points can appear inside attribute values and\/or in tag contents, no dynamic tag generation is allowed. We designed it this way to ensure the formula result is a well formed HTML and won't affect the rest of page's content.<\/p>\n

Here are typical usage examples for the formula:<\/p>\n

1. Decorate contacts name as a e-mail link:<\/p>\n

<a href="<\/font><%<\/font> Nz(<\/font><\/font><\/font>"mailto:" & [E-Mail])<\/font> %><\/font>"><\/font><%<\/font> <\/font><\/font>[Name]<\/font> %><\/font><\/a><\/font><\/p>\n

Behind the scenes Formula \u2013 XHTML creates text formula: a concatenation of markup code and formula results enclosed in HTML encoding function, such as the code below produced from the example:<\/p>\n

"<a href=\\""<\/font> & Encode(<\/font>Nz("mailto:" & [E-Mail])<\/font>) &<\/font> "\\">"<\/font> & Encode(<\/font>[Name]<\/font>) &<\/font> "<\/a>"<\/font><\/p>\n

2. Color the value red if it is less than 100:<\/p>\n

<span style="<\/font><%<\/font> If([Value] < 100, "color:red", "") <\/font>%><\/font>">
<\/font><%=<\/font> <\/font>[Value] <\/font>%>
<\/font><\/span><\/font><\/p>\n

Be aware of the way concatenation handles NULL values \u2013 if one of the parts is NULL whole result is also NULL \u2013 first example produce no markup at all when the value of [Name] is blank. While it is useful in some scenarios, enclosing each and every field you want to display in a sort of NULL checks is a cumbersome task. To handle this case we created a shorthand for code points containing a sole reference to a column, a <%=<\/font> <\/font>[Column]<\/font> <\/font>%><\/font>. It creates Nz() wrapper so that NULL values produce empty strings that can be safely concatenated; numbers, dates, times and timestamps are converted to text via locale-aware Format()<\/a> function, other types converted via ToText(). In second example, <%=<\/font> <\/font>[Value] <\/font>%><\/font> produces Encode(Nz(Format(<\/font><\/font> <\/font><\/font><\/font>[Value] )))<\/font>.<\/font><\/p>\n

<\/p>\n

The usage of HTML and Formula \u2013 XHTML is somewhat limited due to technical reasons.<\/p>\n

1. Markup will be displayed as text in:<\/p>\n