I have a table called Task template, which contains a 18 records of all the tasks I want assigned to a project. I have been using a simple automation that runs in airtable when a new project record is detected. The automation finds all the tasks in the template table then loops through the resulting list and creates new tasks in the task table matching each of the template tasks. This all works fine.
This evening I added a step to set a field in each newly created task to be the assignee based on a field in the project table that initiated the automation. This works too... but sets ALL 18 tasks with the same assignee, and this is not what I want.
Each task has a field called "system task ID" which is a text field containing value 001 - 018. The intent was to make these tasks referenceable in the softr platform I am using with this data.
The challenge I need to figure out is how can I set the automation to set the assignee ONLY on newly created tasks with a system id of 001 - 010?
Below is a screenshot of current the automation. I had an idea about creating separate automations based on grid views that filter to create the groups of tasks I want assigned, but that seem potentially redundant and figured someone may have a more elegant approach?
@Mike_AutomaticN you were johnny-on-the-sot with your other answer earlier today, perhaps you have a trick to solve this one?