dynamic dropdown (report link)

Question

Hello,I need to create a table in my app that has a mapping of contacts to business unit so that in my main table Requests, the user can select a business unit and the matching contact will be populated. There are some business units that have more than one person assigned, and I would like for those to show the user a dropdown of those specific users for them to choose from. So for example:Sales - JenniferMarketing - PaigeMarketing - Matt

Please see attached screenshots for desired functionality. How would I go about this?------------------------------Thanks in advance,Jennifer Paschal------------------------------

MarkShnierYou · Answer

This can be done, but you need to drive this from table choices of Contacts from a relationship and not just the down and dirty multiple choice field types.

You will need a table of contacts and a column here for the business unit.

Then make a relationship between your "Table" and the contacts and look for the check box to make this choice conditional .....

Post back if you get stuck and also let me know if you have a ton of existing data. If here is little data just use Grid Edit to update the new field fore the contact which will be the lookup, to what I assume is now just a multiple choice field.

Here is a Help article on Conditional Drop Down, sometimes called CDD. https://help.quickbase.com/user-assistance/conditional_dropdowns.html

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community