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:
- Trigger: When "received" is checked in Episodes
- Find records: Looks up matching tasks from Tasks List based on show
- 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.
