Colorized List Formula

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I currently have a text formula that creates a list that looks like this:
List("\n",ToText( [Field 1])&" "&"Width",
ToText([Field 2])&" "&"Length",
ToText([Field 3])&" "&"Depth")

I want this list to be colorized so i created a formula like so:
"<span style=\"color:red;font-weight:bold;\">"&  [Colored List]&"</span>"

But when It displays it doesn't display as a list, it simply displays everything in one line.

What am i doing wrong? Thank you.
Photo of The Cobra

The Cobra

  • 84 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Eric Mohlman

Eric Mohlman, Employee

  • 500 Points 500 badge 2x thumb
Official Response
The \n is a newline character, which works for regular formulas. Once you check the "allow some HTML" you now need to use the HTML new line character. I just tested in a dummy app to confirm this works:
"<span style=\"color:red;font-weight:bold;\">" & List("<br />",[Field1] & " Width",[Field2] & " Length",[Field3] & " Depth") & "</span>"
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
You are brilliant! The only modifications I needed to make were to add a closing parenthesis at the end of each line, and then I had to add the prefix 'ToText' for my numbers fields. As always, thank you so much!!!
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
One more question... On the Pass/Fail field (3rd one up from the bottom), I would like the text to appear in red if it’s ‘fail’, and green if it’s ‘pass’. Any suggestions?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,278 Points 50k badge 2x thumb
No problem, just replace your one line with these two lines.  One of them will be null so it will not appear.

IF([Pass/Fail] = "Pass"
"Final Determination: " &"<span style=\"color:green;font-weight:bold;\">"&[Pass/Fail] & "</span>"),

IF([Pass/Fail] = "Fail"
"Final Determination: " &"<span style=\"color:red;font-weight:bold;\">"&[Pass/Fail] & "</span>"),
Photo of Eric Mohlman

Eric Mohlman, Employee

  • 500 Points 500 badge 2x thumb
It can also be simplified like this: "Final Determination: <span style=\"color:" & Case([Pass/Fail],"Pass","green","Fail","red") & ";font-weight:bold;\">" & [Pass/Fail] & "</span>"
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Thank you both. It worked, Coach, but thank you for the additional option, Eric!