Hi! I'm trying to use a Task Template table & an automation to create Tasks aligned to an Account based on a specific criteria. I've got the automation working with the following set up:
- When a record matches a condition in the Accounts table
- Product/Service [LinkedRecord to the Product/Service table] is not empty
- Find Records in Task Template table & create list based on Product/Service dynamically pulling in Product/Service of Airtable ID in trigger
- Create Records in the Task List for Accounts table with the relevant fields.
Here is the problem: I want the "trigger" to be a multiselect field (IE there could be one or many product/services purchased by an account). I am having trouble figuring out how to change the trigger such that it creates tasks that are linked to multiple Product/Services. (In the Task Template table I've also linked the Tasks to the Product/Service. Some of these tasks can be for all three services). I want to look at ALL of the tags in the Product/Services Field on the Account table and then have the automation find all of the Tasks in the Task Template that have each of those Product/Services and create these as a new Task in the Task List for Accounts table.
What am I missing to get the system to watch multi-select fields?
Additionally, I want to figure out a way to set up more logic with the "buckets" of tasks. Essentially, within one product specifically, there will be additional tasks based on additional add-on services. So, I need to figure out a trigger that is watching if this specific product is tagged in the Product/Services field on the Account level AND this other single select field is ABC, pull in the tasks for the Product/Services AND ABC.
Currently, I only have the Product/Services as a LinkedRecord field tied to both the Accounts & Task Template tables. Do I need to do the same thing for this secondary tag for the products that have additional criteria for more unique tasks?
Thanks all!