help with getting a multi select field to allow multiple selects

  • 1
  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
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? 
Photo of la da

la da

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,296 Points 50k badge 2x thumb
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.
Photo of Raakesh Dhayanidhi

Raakesh Dhayanidhi

  • 70 Points
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,296 Points 50k badge 2x thumb
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,";"))<>"")
Photo of Raakesh Dhayanidhi

Raakesh Dhayanidhi

  • 70 Points
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