Skip to main content

I am struggling to create a way to have a reusable dropdown list. An example of this could be needing a product list dropdown that is used by multiple Zapier tables, so that each dropdown field is consistent and centrally managed.

 

The set up would be something like this:

Product Table would have a field named Product Name that will be used to populate a dropdown in a Customer Order Entry table.

 

My Zaps will update Customer Order Entry dropdown fields if the dropdowns are static.

The issue is that my Zaps will NOT update the Customer Order Entry dropdown fields that are generated dynamically. I’ve tried:

  1. Setting the value directly like I might do with a text field (this works with static list dropdowns)
  2. Sending that value to a sub-Zap, doing a table search on Product Table, returning the Record ID to the main Zap, and attempting to update the dropdown with the value of the Record ID.
  3. Trying scenario one, but with a linked field
  4. Trying scenario two, but with a linked field

Is this even possible? 

Hi ​@noice 

Try using the linked Record ID value to link the record in the other Table.

Try using a Linked field type: https://help.zapier.com/hc/en-us/articles/29621241506061-Create-linked-records-in-tables

Help links for using Zapier Tables: https://help.zapier.com/hc/en-us/categories/13398036609933-Tables


Hi there, ​@noice 👋

How did you get on with Troy’s suggestions here. Did they do the trick?

Keep us posted on how you’re getting on, want to make sure this gets sorted! 😁


I mentioned in the original post that I tried record id on linked records and dynamic drop downs. 

 

My setup was a sub-zap that processes the lookup data and routes it to one of six lookup tables and returns the record id. 

 

The issue turned out to be that test data doesn’t flow from the main zap to the sub zap so I was getting sub zap response data that was not what I expected to the field could not be updated with it. Ultimately, he did point me back to the docs which was where I found the answer so his help is appreciated.


Hi ​@noice,

That’s an amazing news! We’re glad to hear that the issue is now resolved!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗