I have the following tables:
1 - Employees - A list of employees (with misc data, none of it important beyond their names. currently 10 employees / 10 rows of data)
2 - Master certificates - A full listing of all certificates that each employee should / could have currently 70 different certifications (70 rows of data).
3 - Staff certificates - A conglomerate list of Employees (10 employees) & each certification (70 certifications) for a total of 700 rows of data
So say we hire someone, to save time I currently have a behavior set up where you can go to the "Master certificates" list and hit the "check box" and bulk select the certifications (Typically all of them) you would like to add to the "Staff certificates"
It runs the behaviour and adds 70 entries to the Staff certificates, with no "Employee" assigned.
I have tried to assign an "input()" to the employee selection field, but it doesn't allow me to select an employee. The best I can do is to tag these new entries as "Replace". Then I have set up a secondary behavior on the "Staff certificates" where you can pick an employee and it replaces that employee with all of the "Replace" tags.
Is there any way that I can accomplish these 2 behaviors in 1? I've been playing with this most of the day and I can't see the forest for the trees anymore.
Solved! Go to Solution.
Please read this tip:
Add any number of rows from any row within a table - Google Cloud Community .
Nice & Thanks! I think I can bang out what I need with a slightly modified version of this: Looping with actions
Also thanks Steve for the demo app
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |