Forum Discussion

MikeKlausing's avatar
MikeKlausing
Qrew Assistant Captain
6 years ago

Insert $ symbol in front of rich text formula

I have a rich text formula that is putting 10 numbers in a vertical list with the following formula: 

"<span style=\"font-size:11px;\">" &
"<b>" &

(List
("<br />",
ToText(([Minimum Record ID# Windows - Window Subtotal])),
ToText([Minimum Record ID# 2nd windws - Window Subtotal]),
ToText([Minimum Record ID# 3rd windows - Window Subtotal]),
ToText([Minimum Record ID# 4th windows - Window Subtotal]),
ToText([Minimum Record ID# 5th windows - Window Subtotal]),
ToText([Minimum Record ID# 6th windows - Window Subtotal]),
ToText([Minimum Record ID# 7th windows - Window Subtotal]),
ToText([Minimum Record ID# 8th windows - Window Subtotal]),
ToText([Minimum Record ID# 9th windows - Window Subtotal]),
ToText([Minimum Record ID# 10th windows - Window Subtotal])))

& "</b>"
& "</span>"

Is there a way to make these numbers display a dollar sign in front of them if they are >0 or if there are values in those fields?

------------------------------
Mike Klausing
------------------------------
  • Try this

    var text VerticalList = 
    List
    ("<br />$",
    ToText(([Minimum Record ID# Windows - Window Subtotal])),
    ToText([Minimum Record ID# 2nd windws - Window Subtotal]),
    ToText([Minimum Record ID# 3rd windows - Window Subtotal]),
    ToText([Minimum Record ID# 4th windows - Window Subtotal]),
    ToText([Minimum Record ID# 5th windows - Window Subtotal]),
    ToText([Minimum Record ID# 6th windows - Window Subtotal]),
    ToText([Minimum Record ID# 7th windows - Window Subtotal]),
    ToText([Minimum Record ID# 8th windows - Window Subtotal]),
    ToText([Minimum Record ID# 9th windows - Window Subtotal]),
    ToText([Minimum Record ID# 10th windows - Window Subtotal]));


    IF($VerticalList <> "",
    "$"
    & $VerticalList

    & "</b>"
    & "</span>"



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
  • There may be some unmatched brackets. I'm just on a small iPhone.

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