Employee Global Assignment
I have an Employees table and a Safety Topics table. I have them joined with a Safety Assignments table to achieve a many to many relationship. My overall goal is to have someone post a new safety top...
Forum Discussion
Hi Jordan,
Automating the process of creating a record for every Employee in your many to many table whenever a new Safety Topic is added is something that you can do with Pipelines. You can set a Pipeline up to trigger whenever a new Safety Topic is added and then have it go to your Employee table, pull up every employee and then create a record in the Safety Assignments table for each employee it finds related to the Safety Topic that triggered it. There is an example article we have of using Pipelines to import in template records and your use case is a little different but pretty similar, instead of bringing in a list of template records you are bringing in a list of employees instead and relating them to your Safety Topic. This way you can avoid the manual process of having to go in employee by employee
------------------------------
Evan Martinez
------------------------------
Automating the process of creating a record for every Employee in your many to many table whenever a new Safety Topic is added is something that you can do with Pipelines. You can set a Pipeline up to trigger whenever a new Safety Topic is added and then have it go to your Employee table, pull up every employee and then create a record in the Safety Assignments table for each employee it finds related to the Safety Topic that triggered it. There is an example article we have of using Pipelines to import in template records and your use case is a little different but pretty similar, instead of bringing in a list of template records you are bringing in a list of employees instead and relating them to your Safety Topic. This way you can avoid the manual process of having to go in employee by employee
------------------------------
Evan Martinez
------------------------------