Discussions

Expand all | Collapse all

Add"$" to rich text field

  • 1.  Add"$" to rich text field

    Posted 08-03-2020 17:52
    Edited by Ermias Bean 08-03-2020 17:56
    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 ([Field 1]),
    ToText (Round(([Field 1]))))

    ------------------------------
    D
    ------------------------------


  • 2.  RE: Add"$" to rich text field

    Posted 08-03-2020 19:06
    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
    ------------------------------



  • 3.  RE: Add"$" to rich text field

    Posted 08-03-2020 19:17
    Works, thank you!

    ------------------------------
    Ermias Bean
    ------------------------------



  • 4.  RE: Add"$" to rich text field

    Posted 08-03-2020 19:44
    Also need to add commas to the numbers. And is there a way to add a running totals column?

    ------------------------------
    Ermias Bean
    ------------------------------



  • 5.  RE: Add"$" to rich text field

    Posted 08-03-2020 19:47
    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
    ------------------------------



  • 6.  RE: Add"$" to rich text field

    Posted 08-03-2020 22:02
    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
    ------------------------------