cooper collier 4/20/2023 7:33:16 PM
It would be nice to be able to do it on the level you are asking so I agree.
In the meantime. I have been able to do it using xhtml column and inline css
I do this with the background color all the time. Here is an example.
<div style=" <%If([# Civil Engineering]<1,"background-color:mistyrose","background-color:green")%> ">
I will try to explain below.
The way to keep the syntax clear and not mess up the code punctuation you should writing your xhtml like this.
First type <div style=" ">
yes leave all those spaces in now
Next put in the escape tags like this. We call them escape tags, because what you put between them is no longer xhtml code, it is now teamdesk formula code.
<div style=" <% %> ">
Then in the middle add the Teamdesk formula code that will write the CSS tag as text.
<div style=" <% If([# Civil Engineering]<1,"background-color:mistyrose","background-color:green") %> ">
This says, if my column is greater than 1 write background-color:mistyrose otherwise background-color:green
When I first started messing with inline CSS and formula, I found it less confusing to leave all the spaces in and to put the entire tag into the formula like above . Once you get used to it, you can make it shorter by only adding the changeable tag value to the formula section and removing spaces.
<div style="background-color:<%If([# Civil Engineering]<1,"mistyrose","lightgreen")%>">
NOTE: The teamdesk formula error checker does not work well for this. You will not hurt anything by doing the above, but if your xHTML column does not display as you think it should, you will need to carefully check every comma and quote very carefully.