I currently have a table called template table with about 100 items in it. I want to run an Airtable Automation, so when a new record is created in a second table (Request Table) and the name of the record matches the name in a field from the Template Table, I have a step to find all records with that name in them. Let’s say for that new record from the Request table there are 10 matching records in the template table. What I want to do now is go into a new table and copy those 10 records and essentially create 10 new records in the new table with all of that information.
I created an automation for this consisting of 3 parts:
Trigger: When Record is Created (Request Table)
Action1: Find Records (Template Table)
Action2: Create Record (New Table)
The problem that I am facing is that instead of creating 10 records in the new table, it takes all 10 records found in action 1 and puts 10 items into a single field for all fields in the table I am copying over. I want 10 records, but I am getting 1 record with everything inside the single record.
I tried the Repeating Group, but found that all the repeating group did was give me 10 records with all 10 items in each field (basically a duplicate of what was made in a single record before I added the repeating group).
Everything is working up until creating the records!
Any assistance would be greatly appreciated! Thank you in advance!