Hi all, I have three tables:
The Projects table has a multiple select field that lists all the people (from linked table) involved in each project record. People are often involved in multiple projects and all projects have more than one person involved. The sub-contracts table lists the contracts that each person (linked from People table) has and the project it relates to (linked to project table). Currently, each sub-contract record is created manually.
I would like to setup an automation that creates a new sub-contract record for each individual involved in each project. The automation trigger seems obvious (new record created in project table) and the action seems obvious (create new record(s) in the sub-contract table). The main problem I’m encountering is how to split the linked multiple select field of members? At the moment, the automation dumps all the individuals into one new sub-contract record.
I’m open to design / restructure tips as well as automation tips. This issue is similar to this previously unanswered question from @Tori_Klein Automation/Formula/Script to Create New Records from a Record with Multiple Linked Records?