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...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------