Skip to main content
Question

Colorized List Formula

  • March 7, 2017
  • 0 replies
  • 90 views
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.
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • March 7, 2017
      I believe you need to 'style' each individual item WITHIN the list function.

      however, I'm sure you will have to style things differently in total to get that affect.
      • ChrisChris
      • Registered
      • March 7, 2017

      You will need to embed your html into the list code:

      List ("\n","<span style='color:red;font-weight:bold;'>"ToText([Field 2])&"</span>"...


      • EricMohlman
      • Quickbase Staff
      • March 8, 2017
      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>
      Terms & ConditionsAccessibility statement