Automation/Formula/Script to Create New Records from a Record with Multiple Linked Records?

I have a table of Researchers and a table of Projects. In the Projects table, I assign researchers to projects by adding them as linked records. Often, multiple researchers are assigned to the same project.

When multiple researchers are assigned to the same project (i.e. multiple records linked to the project), I’d like to automatically create new records in a separate table specifically for each researcher assigned to the project, so that I can send them emails and manage their assignments individually. For example, in the case of the records in this screenshot, I’d like to automatically create a new record for “Project 1_Tori Klein (test)” and “Project 1_Test Researcher.”

image

Any ideas for how I can do this? Thank you for your help!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.