Options in a drop down
I have an application that uses a reference field to pull in info from another table and another drop down with different options.
Is there a way to make the drop down only display certain options...
Forum Discussion
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
------------------------------
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
------------------------------
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.
------------------------------
Chayce Duncan
------------------------------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
------------------------------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:
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:
Status Sub-Status
Not Started Bids Pending
Not Started Pending Approval
Not Started Pending Signature
In Progress In Development
In Progress Final Validation
Complete Invoice Pending
Complete Closed
Your new table needs to have a field that actually references your first value
------------------------------
Chayce Duncan
------------------------------