dynamic dropdown (report link)
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 pop...
Forum Discussion
Hi Mark -
I got this to work! I got an ask to make the contact field multi select. i.e. bringing back my previous example with some changes
Sales - Jennifer
Marketing - Paige
Marketing - Matt
Marketing - Laura
If I choose Marketing I was to choose one or more from my options that are showing (Matt, Paige, Laura). How would I go about setting that up?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
I got this to work! I got an ask to make the contact field multi select. i.e. bringing back my previous example with some changes
Sales - Jennifer
Marketing - Paige
Marketing - Matt
Marketing - Laura
If I choose Marketing I was to choose one or more from my options that are showing (Matt, Paige, Laura). How would I go about setting that up?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendSo if I understand you are creating request records. And you want to assign a contact to that request record.
Truthfully the easiest way to do that is to copy your current relationship where you are selecting a contact and just have two fields for contact one and contact to. Or perhaps duplicate it again and have contact three.
If you copy the field for related contact it will also copy the relationship.
If you want you can then have dynamic form rules that only open up the slot for the second contact when the first one is chosen, and only opens up the slot for the third contact when the second one is chosen. That would keep the form tidy.
If you look up the user ID is from all three relationships you can make a combined list user field which would combine them all that can be useful for reports being filtered on requests assigned to he current user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Truthfully the easiest way to do that is to copy your current relationship where you are selecting a contact and just have two fields for contact one and contact to. Or perhaps duplicate it again and have contact three.
If you copy the field for related contact it will also copy the relationship.
If you want you can then have dynamic form rules that only open up the slot for the second contact when the first one is chosen, and only opens up the slot for the third contact when the second one is chosen. That would keep the form tidy.
If you look up the user ID is from all three relationships you can make a combined list user field which would combine them all that can be useful for reports being filtered on requests assigned to he current user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------