Forum Discussion

Del's avatar
Del
Qrew Cadet
5 years ago

Add"$" to rich text field

I am looking to add a "$" to a rich text field as I am actually color coding a numeric field. I have the formula below If( [Field 1] > 1, "<span style='background-color: #ffb3b3'>" & Round ([Fi...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try this

If( [Field 1] > 1,
"<span style='background-color: #ffb3b3'>" & "$" & ToText(Round ([Field 1])),
"$" & ToText (Round(([Field 1]))))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Del's avatar
Del
Qrew Cadet
5 years ago
Also need to add commas to the numbers. And is there a way to add a running totals column?

------------------------------
Ermias Bean
------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    5 years ago
    Ernias,

    Can you give an example of the underlying data and how that would be used in a running total?

    Don

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    try this

    var text RawText = 

    "$" &
    ToFormattedText(Round([Field 1]),"comma_dot",3);

    If( [Field 1] > 1,
    "<span style='background-color: #ffb3b3'>" & $RawText,
    $RawText)



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