Forum Discussion

vijaysingh's avatar
vijaysingh
Qrew Cadet
6 years ago

Checkbox drop down list changes on selection of specific value in another checkbox

Hi Team,

I am working on a application where there is a checkbox with 3 values and for every selection there is list of values to be displayed in another checkbox. 

Currently i have listed all the 3 categories values in the 2nd checkbox together as was finding hard to show different values in the 2nd checkbox based on selection in the 1st checkbox values.. 

Do you see this possible in QB? I am not looking for multiple check boxes to show different selections, only one checkbox where values gets changes based on selection.

Thanks,
Vijay

------------------------------
vijay singh
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    You are using the word checkbox, but do you really mean a multiple choice selection field.  Are you lookng for a conditikoal drop down, like you select the
    [Make] and select BMW and you get a drop down list of just the BMW models like

    2 series
    3 series 
    4 series
    X3

     and not Corolla or Prius as they are Toyota?


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • vijaysingh's avatar
      vijaysingh
      Qrew Cadet
      6 years ago
      That's correct Mark..Sorry for any confusion but you seems to got it exactly what i was trying to ask..

      ------------------------------
      vijay singh
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        OK, so your lucky day.  That is native functionality called Conditional drop downs . https://help.quickbase.com/user-assistance/conditional_dropdowns.html

        It's a shame that you have such short drop down lists to work with, because and it is truly impressive to see how efficiently Quick Base filters the next drop down when there are thousands of records.

        In you case, you just need to set up a master table to drive the drop down list for field 1 and then another table for the valid choices in field 2 and then make a relationship where One field 1 has many field 2s. I suggest making the Key field of these tables the actual text choices and not Record ID#.

        Then you will use those tables in a relationship back to your data entry record to provide the drop down lists. 

        Post back if you get stuck.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------