Create records from multiple records found.

[Ringslinger]

Hey Airtable community,

I've got an automation where I need to create multiple task records when an episode is marked as "received". Here's my setup:

• Tasks List table: Contains template tasks linked to specific shows
• Episodes table: Where I check "received" to trigger automation
• Tasks table: Where new tasks should be created

Current automation:

1. Trigger: When "received" is checked in Episodes
2. Find records: Looks up matching tasks from Tasks List based on show
3. Create record: Tries to create tasks in Tasks table

Problem: The "Create record" action creates one record with all tasks combined, but I need separate records for each task found. 


Quick example: 

The "Tasks list" table has entries for 

Task List    | Show |
Transcode | Show A Show B |
Send to A  | Show B |
Send to B  | Show B |
Send to C

Show A : may fit one of those criteria. 
Show B : fits 3. 

When run the automation for show B I get this single record

Transcode, Send to A, Send to B |  Show B |

When it should be these 3 records.

Transcode | Show B |
Send to A  | Show B |
Send to B  | Show B |

Any ideas how to achieve this with basic automation features?

Any help will be appreciated. Thanks. 

[Mike_AutomaticN]

Hey @Ringslinger!

Repeating group is the solution to your issue. Please check this guide!

By following the instructions you’ll be able to create as many records are found with your find records action. 

Mike, Consultant @ Automatic Nation

[Mike_AutomaticN]

Hey @Ringslinger!

The solution to your issue is found using Repeting Groups within your automation. Please follow the guide of this link!

This is a game changer feature. Let me know if you have any question on implementation. 

Mike, Consultant @ Automatic Nation

[TheTimeSavingCo]

A repeating group like Mike mentioned should sort you out

You may want to check out Record Templates for what you're trying to do too: https://support.airtable.com/docs/using-record-templates-in-airtable

Does exactly what you need it to do by creating a template of tasks per Show, and might be simpler to manage as you no longer need a table dedicated to tasks.  Also lets you set relative deadlines for each task to the time the automation ran.  All doable without record templates, mind you; this just makes it a lot easier to do