Quick Base Discussions

Expand all | Collapse all

help with getting a multi select field to allow multiple selects

  • 1.  help with getting a multi select field to allow multiple selects

     
    Posted 07-03-2017 21:31
    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? 


  • 2.  RE: help with getting a multi select field to allow multiple selects

    Posted 07-03-2017 22:26
    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.


  • 3.  RE: help with getting a multi select field to allow multiple selects

    Posted 02-28-2019 21:00
    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


  • 4.  RE: help with getting a multi select field to allow multiple selects

    Posted 03-01-2019 02:32
    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,";"))<>"")


  • 5.  RE: help with getting a multi select field to allow multiple selects

    Posted 03-01-2019 08:19
    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



  • 6.  RE: help with getting a multi select field to allow multiple selects

    Posted 06-13-2019 09:19
    is it possible by using a formula field?