Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Setup Automation for CRM use case: Find Criteria, Create records in junction table from matched criteria

Topic Labels: Automations
879 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kendy511
6 - Interface Innovator
6 - Interface Innovator

Input Data: 3 tables

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

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

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

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!

0 Replies 0