Skip to main content
Question

help with getting a multi select field to allow multiple selects

  • July 4, 2017
  • 0 replies
  • 29 views

  • Quickbase Alumni
just starting and cannot get the multi select field to allow selection of multiple fields. is this field only to display a drop down list but not able to select multiple fields? 
This topic has been closed for replies.

A regular multiple choice  field offers the user a list of choices and the user may choose one.

A multi select field offer a list of choices and the user can select up to 20 choices.  It does not offer other fields as choices.

Hello, 

I could sound strange, just curious to know this...is there a way we can count the list of items in the Multi-Select field?

Example - If we have 5 options in a Multi-Select field, then the output should be 5.

Thanks,
Raakesh

Try this

Var text value = ToText([my multi select field]);

Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
Trim(Part($value,4,";"))<>"",
Trim(Part($value,5,";"))<>"",
Trim(Part($value,6,";"))<>"",
Trim(Part($value,7,";"))<>"",
Trim(Part($value,8,";"))<>"",
Trim(Part($value,9,";"))<>"",
Trim(Part($value,10,";"))<>"",
Trim(Part($value,11,";"))<>"",
Trim(Part($value,12,";"))<>"",
Trim(Part($value,13,";"))<>"",
Trim(Part($value,14,";"))<>"",
Trim(Part($value,15,";"))<>"",
Trim(Part($value,16,";"))<>"",
Trim(Part($value,17,";"))<>"",
Trim(Part($value,18,";"))<>"",
Trim(Part($value,19,";"))<>"",
Trim(Part($value,20,";"))<>"",
Trim(Part($value,21,";"))<>"",
Trim(Part($value,22,";"))<>"",
Trim(Part($value,23,";"))<>"",
Trim(Part($value,24,";"))<>"",
Trim(Part($value,25,";"))<>"")

Yes, I saw this reply from you on the other post as well. However, my requirement is I want to know how many options do exist in the multi-select field (Not how many of them I select). Assume in the status field I have 3 options (On-Track, On-Hold & Completed) then I should get the output as 3


is it possible by using a formula field?