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