Forum Discussion

JemmaDicks's avatar
JemmaDicks
Qrew Trainee
3 years ago

Using HMTL to modify text fields

Hi there

I'm trying to get creative with some text fields. But, my HTML syntax is not right, because it's not working. It's applying the first item in my span style tag but ignoring the rest. This is what I am putting in the text item properties.
The text displayed is the word "Quoted":

<span style="background-color:#563D82;
font-size=20px;
font-color=WHITE">
<B>
Quoted
</B>
</span>

HELP!!!!

------------------------------
Jemma
Data Analyst & Visualisation
United Kingdom
------------------------------
Formulas and functions

2 Replies

Sort By
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    3 years ago
    Hi Jemma,

    Is this your formula pulled directly out of your rich text formula field? If so there is some syntax that helps you get your formatting for a rich text formula to work in Quickbase. You want to wrap your style tags in quotation marks and then you need to connect your text together for the formula using Ampersands(&). Then you want to make sure you escape any extra quotation marks that appear in your styling so for example you could set your formula out like this:

    "<span style=\"color:#FBFBFB;background-color:#563D82;font-size=20px\">" & "Quoted" & "</span>"

    This identifies the various parts of your formula as what is for the Quickbase formula to read and what should be read by the user, etc.

    ------------------------------
    Evan Martinez
    ------------------------------
    • JemmaDicks's avatar
      JemmaDicks
      Qrew Trainee
      3 years ago
      Perfect, thanks Evan Martinez

      ------------------------------
      Jemma
      Data Analyst & Visualisation
      United Kingdom
      ------------------------------