Skip to main content

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!

Hey ​@Tim_Stuart,

The issue you are having corresponds to the incorrect mapping of the variables within the Create Record action. When mapping on such action, you will want to take the values from the CURRENT ITEM being looped, and not from all of the found records. Video below shows a different use case, but please pay attention to how I create the repeating group (min 1:39) and most importantly, how I select the variable from the current item (min 2:08).

 


Hope this helps!!

Feel free to grab a slot using this link out if you’d like to go through it together. I’d be happy to help.

Mike, Consultant @ Automatic Nation


Thanks, Mike_AutomaticN!

 

Yes, I was able to get this to work thanks to your video! I really appreciate your help!


Glad to hear that ​@Tim_Stuart! Feel free to shoot any other question you might have :D

Mike, Consultant @ Automatic Nation


Reply