Discussions

Expand all | Collapse all

Formula Rich Text Field - Text Formatting

  • 1.  Formula Rich Text Field - Text Formatting

    Posted 09-17-2020 09:42
    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
    ------------------------------


  • 2.  RE: Formula Rich Text Field - Text Formatting

    Posted 09-17-2020 10:05
    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
    ------------------------------