Forum Discussion

FreddieSabbs's avatar
FreddieSabbs
Qrew Trainee
5 years ago

Using HTML in Formula - Rich Text Fields

At EMPOWER2019 in Miami, Senior UX Designer Lisa Sawyer shared some awesome tips in her session Quick DIY solutions for beautiful & user friendly apps. 

Do yourself a favor and carve out an hour to check out this highly informative session.

If you only have a few minutes to spare, check out this quick video highlighting my favorite tip: using HTML in Rich Text Formula Fields

This is a great technique to quickly add some color and style app by highlighting key data points or KPI’s for your end users.

Here is the code snippet that is used in the video:

"<div style=\"color:#74489D;font-size:350%;font-weight:bold;\"align=\"center\">"& ADD YOUR FIELD &"</div>"&
 "<div style=\"color:#gray;font-size:150%;font-weight:bold;\"align=\"center\">PLACEHOLDER TEXT</div>"



To learn more about which HTML Tags are allowed by Quick Base, click here



------------------------------
Freddie Sabbs
fsabbs@quickbase.com
------------------------------
Formulas and functions

3 Replies

Sort By
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    5 years ago
    This is really great. Thanks Freddie for sharing.

    ------------------------------
    Babi Panjikar
    ------------------------------
  • AdamKirchhoff's avatar
    AdamKirchhoff
    Qrew Member
    3 years ago
    Another method that I have been using recently is to add all your HTML in quotations by themselves.  Or to rephrase, add your HTML between quotations and end with an ampersand ("<HTML HERE>"&)  For example:

    If you were using the following:

    <p style=font-size:14pt;color:red;>
         Example Text
    </p>

    I will use in Formula Rich Text as follows:

    "<p style=font-size:14pt;color:red;>"&
         "Example Text"&
    "</p>"

    ------------------------------
    Adam Kirchhoff
    ------------------------------
    • AdamKirchhoff's avatar
      AdamKirchhoff
      Qrew Member
      3 years ago
      Or if you wish to use fields, or concatenate text with field (to clarify)

      "<p style=font-size:14pt;color:red;>"&
           "Total Due: "&[Total Due]&
      "</p>"

      ------------------------------
      Adam Kirchhoff
      ------------------------------