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 t...
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
      ------------------------------
      • vijaysingh's avatar
        vijaysingh
        Qrew Cadet
        6 years ago
        Thanks Mark. 

        I did the same as mentioned by you above, not sure if missed something as not getting the conditional drop down list.. 

        Here are 3 tables involved. 

        Milestone 
        Milestone level 
        Milestone Name 

        Milestone table form has "Milestone Level" selection and that is linked to 'Milestone Level' table on it PK (Milestone Level).. "Milestone Name" column in Milestone table is linked with 'Milestone Name' table on its PK (Milestone Name).. 'Milestone Level' and 'Milestone Name' tables are connected to each other on "Milestone Level" column .. 

        I just pasted the conditional selection condition for "Milestone Name" column in Milestone table for your reference...Do you see anything missing?


        ------------------------------
        vijay singh
        ------------------------------