I would like to use an automation to create multiple new child records when a parent record is updated. I understand how to set up the first part of the automation, but am having difficulty figuring out how to create the multiple child records.
I have the following tables: Documents, Groups, and Training.
- Groups identifies the group that users belong to. Users can have multiple groups.
- Documents is a child of Groups. When documents are submitted, someone determines which group(s) (multi-select field) require training to that document.
- Training is a child of Documents and Groups. Users answer quiz questions related to the document.
I want to create a training record for each user where their group is indicated for training in the document record. There will be 5-10 groups and could be 100 or so users, so I could create individual automations for each group, but not for each user.
------------------------------
Bre Butler
------------------------------
