Forum Discussion

BrandonHermez's avatar
BrandonHermez
Qrew Member
5 years ago

Conditional Dropdwon

Hello,

I am making a ticketing application. The idea is that the person who opens a ticket, will see a Text - Multiple Choice field named "Attention". They will then choose between IT, Merchandising, or Facilities. 

The issue is I'm unsure how to go about making a dropdown that would change based on the three. I tried making a table for all three of the topics and played with the conditional settings a bunch but no luck. I will also add my relationship between the tables below. Thanks and any help would be very appreciated.



------------------------------
Brandon Hermez
------------------------------
Conditional-Dropdown
Relationships
  • ChristineWhite's avatar
    ChristineWhite
    Qrew Assistant Captain
    5 years ago
    I usually use the basic setup instructions https://help.quickbase.com/user-assistance/conditional_dropdowns_basic_setup.html
    and replace my table names with Countries, Cities and Employees from the Example.  Looks like Countries=Issues (Facility, IT, Merchandising), Cities=locations and Employees=Tickets.  Then just follow the instructions using your tables. So Issues have many locations and many tickets.  Locations have many Tickets.

    ------------------------------
    Christine White
    ------------------------------