Forum Discussion
5 Replies
- 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?