Skip to main content
Question

Create Vertical List

  • December 9, 2019
  • 0 replies
  • 50 views

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

AdamKeever1
Forum|alt.badge.img+2
  • Quickbase Alumni
  • December 9, 2019
You may try to tie that condition in with another. For example if vents = null return windows, else return windows and vents. This would remove vents when vents is blank.

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

var text VerticalList =
(List
("<br />",
If([Formula show fields with data (Vents Quantity)]=null , ToText([Formula show fields with data (Windows Quantity)]), (ToText([Formula show fields with data (Windows Quantity)]), 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>"

------------------------------
Adam Keever
------------------------------