MikeKlausing
6 years agoQrew Assistant Captain
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(([Minimum Record ID# Windows - Window Quantity])),
ToText([Minimum Record ID# 2nd windws - Window Quantity]),
ToText([Minimum Record ID# 3rd windows - Window Quantity]),
ToText([Minimum Record ID# 4th windows - Window Quantity]),
Etc...,
null))
& "</b>"
& "</span>"
I have several of these formulas that I want to create another vertical list with these results if they have returned values.
When I did this I created a similar formula:
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
ToText([Formula show fields with data (Windows Quantity)]),
If([Formula show fields with data (Vents Quantity)]=null , "", ToText([Formula show fields with data (Vents Quantity)])),
ToText([Formula show fields with data (Walkdoor Quantity)]),
ToText([Formula show fields with data (Shutters Quantity)]),
ToText([Formula show fields with data (Cupolas Quantity)]),
ToText([Formula show fields with data (walkdoor Options quantity)]),
ToText([Formula show fields with data (Insulation sq ft)])));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
My problem is I am getting gaps between my values. For example in the list above "windows quantity" and "walkdoor Quantity" have values but it puts a space in between them for where Vents quantity should be but doesnt have a value. how can I have that gap collapsed if its null? I tried to do that on the Vents quantity line but it hasnt worked yet.
------------------------------
Mike Klausing
------------------------------
"<span style=\"font-size:11px; text-decoration:underline; width:1400px\">" &
"<b>" &
(List
("<br/>",
ToText(([Minimum Record ID# Windows - Window Quantity])),
ToText([Minimum Record ID# 2nd windws - Window Quantity]),
ToText([Minimum Record ID# 3rd windows - Window Quantity]),
ToText([Minimum Record ID# 4th windows - Window Quantity]),
Etc...,
null))
& "</b>"
& "</span>"
I have several of these formulas that I want to create another vertical list with these results if they have returned values.
When I did this I created a similar formula:
"<span style=\"font-size:11px;\">" &
"<b>" &
var text VerticalList =
(List
("<br />",
ToText([Formula show fields with data (Windows Quantity)]),
If([Formula show fields with data (Vents Quantity)]=null , "", ToText([Formula show fields with data (Vents Quantity)])),
ToText([Formula show fields with data (Walkdoor Quantity)]),
ToText([Formula show fields with data (Shutters Quantity)]),
ToText([Formula show fields with data (Cupolas Quantity)]),
ToText([Formula show fields with data (walkdoor Options quantity)]),
ToText([Formula show fields with data (Insulation sq ft)])));
If($VerticalList <> "",
""
& $VerticalList)
& "</b>"
& "</span>"
My problem is I am getting gaps between my values. For example in the list above "windows quantity" and "walkdoor Quantity" have values but it puts a space in between them for where Vents quantity should be but doesnt have a value. how can I have that gap collapsed if its null? I tried to do that on the Vents quantity line but it hasnt worked yet.
------------------------------
Mike Klausing
------------------------------