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?
Best answer by SamB
View original
+11
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!
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
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
