Skip to main content
Question

Insert $ symbol in front of rich text formula

  • October 9, 2019
  • 0 replies
  • 54 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 9, 2019
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 9, 2019
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
------------------------------