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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of ed cooper

ed cooper

  • 922 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
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)