I have the following:
I want:
Have an action/workflow for the “Staff” table to be able to create records in the “Entry” table for this specific [StaffID], one record per [CourseID] where Staff[Assignment] is contains in Course[Applicability].
Basically, when a new staff is added, I want to populate “no details entries” for this individual for all applicable “Course” automatically, then go through the list of “no details entries” manually to fill the details.
I know there’s an action called “Data: add a new row to another table using values from this row” but this only creates one record in the destination table. I would need to repeat this action for each Course[CourseID] applicable.
Any tips?
Search the form, the sample applications of Steve and Matt are in the form. you can do whatever you want.
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |