Skip to main content

Input Data: 3 tables







  • Table 1: [People] where I storage information and classify levels of people to take care








  • Table 2: [Task] where I create recurring task to notify me to take care for each levels people








  • Table 3: [Interaction] 's junction table between [Task] & [People] which I create action for each person and linked to main task involve








Workflow:


1/ When the Task in [Task] on time (Ex: CRM 6*)


2/ Lookup the people in [People] who have the same Client levels with The task input, and linked all of those people to Task 1 above


3/ With People we found above, automation create records in [Interaction] then linked to each person in step 2 and Task 1 (junction table)



Current Setting and Problem when setting automation:





  • Trigger: [Task] contains CRM 6* and Start date 's today (Step 1)


  • Action:


    -Find records [People] which have {level people} match Task name


    -Update record [Task] linked to List of Find record above (Step 2)




Problem: in step 3, I dont know how to setup action to seperate the List of Find records to create multi line records in junction table - in my case’s multi records in Interaction table.


Hope I can get some advices to figure this!

Be the first to reply!

Reply