Help

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

972 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tori_Klein
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

0 Replies 0