Create Vertical List
I have formula fields that give me a vertical list of numbers which is this: "<span style=\"font-size:11px; text-decoration:underline; width:1400px\">" & "<b>" & (List ("<br/>", ToText(([Mini...
Forum Discussion
you cannot use null to test a text field.
Yo nee this syntax
If(Trim([Formula show fields with data (Windows Quantity)]) = ""
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yo nee this syntax
If(Trim([Formula show fields with data (Windows Quantity)]) = ""
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I've been working on this but havent got it to collapse the blank lines as of yet. both of these formulas still dont pick out the blank lines and collapse them. I have tried these formulas:
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
If(Trim([Formula show fields with data (Windows Quantity)])<>"", ToText([Formula show fields with data (Windows Quantity)])),
If(Trim([Formula show fields with data (Vents Quantity)])<>"", ToText([Formula show fields with data (Vents Quantity)])),
If(Trim([Formula show fields with data (Walkdoor Quantity)])<>"", ToText([Formula show fields with data (Walkdoor Quantity)]))));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
And:
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
If(Trim([Formula show fields with data (Windows Quantity)])="",ToText ([Formula show fields with data (Vents Quantity)]), ToText([Formula show fields with data (Windows Quantity)])),
If(Trim([Formula show fields with data (Vents Quantity)])="", ToText([Formula show fields with data (Walkdoor Quantity)]), ToText([Formula show fields with data (Vents Quantity)])),
If(Trim([Formula show fields with data (Walkdoor Quantity)])="", ToText([Formula show fields with data (Shutters Quantity)]), ToText([Formula show fields with data (Walkdoor Quantity)]))));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
------------------------------
Mike Klausing
------------------------------
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
If(Trim([Formula show fields with data (Windows Quantity)])<>"", ToText([Formula show fields with data (Windows Quantity)])),
If(Trim([Formula show fields with data (Vents Quantity)])<>"", ToText([Formula show fields with data (Vents Quantity)])),
If(Trim([Formula show fields with data (Walkdoor Quantity)])<>"", ToText([Formula show fields with data (Walkdoor Quantity)]))));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
And:
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
If(Trim([Formula show fields with data (Windows Quantity)])="",ToText ([Formula show fields with data (Vents Quantity)]), ToText([Formula show fields with data (Windows Quantity)])),
If(Trim([Formula show fields with data (Vents Quantity)])="", ToText([Formula show fields with data (Walkdoor Quantity)]), ToText([Formula show fields with data (Vents Quantity)])),
If(Trim([Formula show fields with data (Walkdoor Quantity)])="", ToText([Formula show fields with data (Shutters Quantity)]), ToText([Formula show fields with data (Walkdoor Quantity)]))));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
------------------------------
Mike Klausing
------------------------------
