Skip to main content
Question

Can you use ""List"" for numeric fields

  • March 1, 2017
  • 0 replies
  • 107 views

Forum|alt.badge.img+7
Can you help me with using "List" with numeric fields
This topic has been closed for replies.

  • Quickbase Alumni
  • March 1, 2017
Yes, you can. You'll find the select from list option when you go into the properties for the numeric field.

  • Quickbase Alumni
  • March 1, 2017
Chris is correct, but you need to keep in mind that "List" is used to with Text fields, so you will need to convert your number to text within the list function.

For Example:
List(" - ", ToText([Numeric Field 1]), ToText([Numeric Field 2]), etc )

If you need to convert that back to a number, just a "ToNumber()" before.

TONumber( List(" - ", ToText([Numeric Field 1]), ToText([Numeric Field 2]), etc ) )




  • Quickbase Alumni
  • March 1, 2017
Sorry, I did not realize you were talking about the List function.

Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • March 1, 2017
Thanks, But I need to create an If Statement because I am seeing "0" if the number is blank.  And if I add the following I get an error missing brackets or etc

var text Num1 = If (not IsNull([Number1]), [Number1], "");
var text Num2 = If (not IsNull([Number2]), [Number2], "");


List(",", $Num1,$Num2)

Forum|alt.badge.img+7
  • Author
  • Quickbase Alumni
  • March 1, 2017
Thanks that is perfect