Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
2 years ago

Populating Dropdown list fields based off of other Dropdown list selections

Hello, I have a fairly large list that contains groups and sub-groups.  Much too many to list in a single dropdown mulitselect field.  I was wondering if it could be broken out?  The first list would contain the main groups.  (You must be able to select more than one option from all dropdown lists.)  After selecting the main group(s) in the first dropdown can a subsequent dropdown list be displayed showing the sub-groups for only the selected main groups in the first dropdown list?

How would you go about creating this functionality?
Thanks,
Brian



------------------------------
Brian Dunk
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    Quickbase has exceptional performance for large data sets and a great user experience when Conditional Drop Downs are used.

    But you are asking for a multi select filter on those drop downs and that functionality does not exists.

    Would you consider say offering the user several of those drop downs, where the user could select a single drop down filter and then a single result, and then have a formula to combine all of their separate selections into one multi select formula field? 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BrianDunk's avatar
      BrianDunk
      Qrew Cadet
      2 years ago

      HI Mark, is this possible?  Could a user select a single value (One Main Group) from one dropdown and have that list populate another dropdown with the appropriate Sub-Groups that go with that Main group?  However, in this second dropdown list could they select multiples from just this sub-group list?

      Brian



      ------------------------------
      Brian Dunk
      ------------------------------

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago

        No, that is not be behaviour of a drop down field off a relationship.  It does not allow for multi select.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------