Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Re: dynamic dropdown (report link)

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
------------------------------

2 Replies

Sort By
  • JENNIFERPASCHAL's avatar
    JENNIFERPASCHAL
    Qrew Trainee
    4 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      So 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
      ------------------------------