I’m building an automation for copying multiple record IDs from Zapier Tables into a new Spreadsheet template as new rows. The objective is to generate this spreadsheet from a “Form Submission in Interfaces” trigger and then email the spreadsheet to the email provided in the form submission.
I would like to pull all record IDs in the Zapier tables that match the brand name provided in the form submission. How do I do this?
Answer
How do I copy multiple record IDs from Zapier Tables into a new Spreadsheet template as new rows?
- Beginner
Best answer by SamB
Welcome to the Community
The Zapier Tables app has a Find Records search action that you could use to search all of the records in the table to see if it contained a match for a specific brand name supplied by the Google Forms trigger. That search action would return the information for all matched records (as line items) including their IDs.
One thing to note here is that that Find Records action is limited to a maximum of 1000 records. So if there’s more than 1000 records that would be a match for the brand name then it won’t be able to find them all.
Hope that helps to get you pointed in the right direction. If you run into any trouble in using that action or I’ve misunderstood what you’re wanting to do here just let us know!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
- Answer
Welcome to the Community
The Zapier Tables app has a Find Records search action that you could use to search all of the records in the table to see if it contained a match for a specific brand name supplied by the Google Forms trigger. That search action would return the information for all matched records (as line items) including their IDs.
One thing to note here is that that Find Records action is limited to a maximum of 1000 records. So if there’s more than 1000 records that would be a match for the brand name then it won’t be able to find them all.
Hope that helps to get you pointed in the right direction. If you run into any trouble in using that action or I’ve misunderstood what you’re wanting to do here just let us know!
- Beginner
Sam,
Thanks for the help! This helped us troubleshoot and get the automation working. Gotta be more active here this is a great resource.
+11- Community Manager
I’m so pleased to hear that
If you need any further help in future please do reach out again in the Community - we’re always here and happy to help. Until then, happy Zapping! ⚡
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.