Options in a drop down

Question

I have an application that uses a reference field to pull in info from another table and another drop down with different options.&nbsp;
Is there a way to make the drop down only display certain options based off what is selected in the reference field?
I've looked at the conditional info, but that doesn't seem to apply to only having the field show the options that apply based off what is selected in the reference field.&nbsp;
For example if the user picks ABC store then in the line of business field I only what the option 123 to show...------------------------------LB------------------------------

chayceduncan · Answer

Does your secondary option have the matching input to match 123 with ABC in your example? Assuming that your second option is a reference field to another table also you can certainly use conditional dropdowns and is the way you want to go. Can you provide a little more info to help us figure out how to set that up in your structure?

------------------------------
Chayce Duncan
------------------------------

lb · Answer

My secondary field is not in a reference field it just in a regular drop down field. The one field uses information referenced in another field to supply the drop down options - and based of what is selected in that field I would like to have my other drop down field only show certain options vs all of the options - or even default select an option for them.

------------------------------
LB
------------------------------

chayceduncan · Answer

Unfortunately conditional dropdowns are only accessible through a relationship/table type setup. I would advise that instead of using a generic text-multiple choice with shared values that you create a table of those options and have your users pick from that table accordingly. That is the only way to dynamically update the list of options in a dropdown on a record by record basis.&nbsp;
------------------------------Chayce Duncan------------------------------

lb · Answer

Ok, when I build the table with the additional options how do I create the condition for the new related field to only show certain options based off of choices in another reference field?

------------------------------LB------------------------------

chayceduncan · Answer

In this additional table you will need to include a field that is associated with the first reference field. So for example let's say your first reference field is 'Status' and the second Reference field is now 'Sub-Status'. In your first dropdown you'll have options like the below for Status:&nbsp;
Not Started
In Progress
Complete

Now in your second table - you need a field for 'Sub-Status' but you also need to note the Status that it goes with and thats the binding element in your conditional dropdown. So your sub-status table might look like:&nbsp;
Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sub-Status
Not Started&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bids Pending
Not Started&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending Approval
Not Started&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending Signature
In Progress&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In Development
In Progress&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Final Validation
Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Invoice Pending
Complete&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Closed

Your new table needs to have a field that actually references your first value------------------------------Chayce Duncan------------------------------

Forum Discussion

Options in a drop down

5 Replies

Related Content

Update report filters when drop down options change

Conditional Drop-down

Search Options

Export Text - Multiple Choice fields and their options

Lookup Fields / Drop down options

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.