Forum Discussion
- QuickBaseCoachDQrew CaptainA 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. - RaakeshDhayanidQrew TraineeHello,
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 - QuickBaseCoachDQrew CaptainTry 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,";"))<>"") - RaakeshDhayanidQrew TraineeYes, 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
- RaakeshDhayanidQrew Traineeis it possible by using a formula field?