Using HTML in Formula - Rich Text Fields

Question

At EMPOWER2019 in Miami, Senior UX Designer Lisa Sawyer shared some awesome tips in her session Quick DIY solutions for beautiful &amp; user friendly apps.&nbsp; 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:
"&lt;div style=\"color:#74489D;font-size:350%;font-weight:bold;\"align=\"center\"&gt;"&amp; ADD YOUR FIELD &amp;"&lt;/div&gt;"&amp;
&nbsp;"&lt;div style=\"color:#gray;font-size:150%;font-weight:bold;\"align=\"center\"&gt;PLACEHOLDER TEXT&lt;/div&gt;"
To learn more about which HTML Tags are allowed by Quick Base, click here
------------------------------Freddie Sabbs fsabbs@quickbase.com------------------------------

babipanjikar · Answer

This is really great. Thanks Freddie for sharing.------------------------------Babi Panjikar------------------------------

adamkirchhoff · Answer

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:


Example Text


I will use in Formula Rich Text as follows:

""&
"Example Text"&
""

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

adamkirchhoff · Answer

Or if you wish to use fields, or concatenate text with field (to clarify)

""&
"Total Due: "&[Total Due]&
""

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

Forum Discussion

Using HTML in Formula - Rich Text Fields