Discussions

 View Only
  • 1.  Can you have a conditional dropdown in Essentials? If so, I have 4 tables:

    Posted 10-01-2017 01:14
    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.


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

    Posted 10-01-2017 20:16
    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)