Forum Discussion

edcooper's avatar
edcooper
Qrew Assistant Captain
8 years ago

Can you have a conditional dropdown in Essentials? If so, I have 4 tables:

QuickBase Essentials

Company Master
Contacts Master
Stores Master
Details - an intermediary table that has relationships with the above tables. In the details table I have 3 fields.
  Company - a dropdown that displays Companies from the Company table.
  Contact -    a dropdown that displays Contacts from the Contact table.
  Store -        a dropdown that displays Stores from the Store Master

I would like to set up a conditional dropdown so that when I am in the Store dropdown it only shows me stores that related to the Company Master.
Same for dropdown on Contacts.
Ask about Quickbase functionality
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    You will want to modify the field properties for 2 fields.

    [Related Store] and [Related Contact]

    And assuming you already have the relationships built between the companies and stores.

    Click the checkbox to make the field conditional, and chose the [Related Company] field in BOTH drop-downs.

    (This image uses different naming, but its the same idea)