Can I use a field in an html tag?
I tried this formula in a text formula field, but the background color does not change when I use the text field called Calendar Color in the html tag. I don't get any syntax errors, but the backgroun...
Forum Discussion
You were really close - you just needed to put quotes and "&" before and after [Calendar Color], so that the value in the [Calendar Color] field gets filled in. If [Calendar Color] is inside the quotes, then the string "[Calendar Color]" gets displayed, which is not a valid background-color.
Here's the updated formula:
"<div style=\"color:white;background-color:" & [Calendar Color] & ";\"> " &[Calendar Color]& "<div>
Here's the updated formula:
"<div style=\"color:white;background-color:" & [Calendar Color] & ";\"> " &[Calendar Color]& "<div>
Awesome!! One step further....how can you add regular TEXT and a FIELD to this code? My example:
IF ([Jury Duty Count Helper] = 0 and [JRY Form] > 0, "<div style=\"color:#D5152E;font-weight:bold; background-color:" & [Jury Duty Doc Outstanding Duration] & ";\"> " &[Jury Duty Doc Outstanding Duration]& "<div>")
The text i would want to add would be be "Jury Duty Doc Outstanding for" prior to the field [Jury Duty Doc Outstanding Duration].
Thanks!
IF ([Jury Duty Count Helper] = 0 and [JRY Form] > 0, "<div style=\"color:#D5152E;font-weight:bold; background-color:" & [Jury Duty Doc Outstanding Duration] & ";\"> " &[Jury Duty Doc Outstanding Duration]& "<div>")
The text i would want to add would be be "Jury Duty Doc Outstanding for" prior to the field [Jury Duty Doc Outstanding Duration].
Thanks!