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
    Works, thank you!

    ------------------------------
    Ermias Bean
    ------------------------------
  • 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
      ------------------------------