Skip to main content
Question

Formula Rich Text Field - Text Formatting

  • September 17, 2020
  • 0 replies
  • 215 views

Forum|alt.badge.img+7
Hello,

I am trying to format text in a Rich Text Field where I am also using an imaged linked from a URL. The field is working properly, but I can't figure out how to get the text formatted the way I'd like it.

Here is what I see based on the formula below:

What I'd prefer to see, is the image followed by "- Good Deal" in Bold, Green Text and also possible a little larger font.

I've played around with some html to try to get this working, but I always end up with the "- Good Deal" on a separate line or something else broken. ☺

Thanks in advance for your help!

Here is my formula:

If([Negotiated Purchase Price of Land] <= [Max Lot Price], "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"/>" & " - Good Deal",

If([Negotiated Purchase Price of Land] <= ([Max Lot Price] * 1.25), "<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"/>" & " - Within 25% - Needs Further Review",

If([Negotiated Purchase Price of Land] > [Max Lot Price], "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"/>" & " - Bad Deal"
)))

------------------------------
Josh Collins
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
try this syntax

"<img src=http://images.quickbase.com/si/16/222-point_green.png>"
& "<b><font size=3><font color=green>"

& " - Good Deal"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------