Cross Product

Okay,

I have 5 Tables

1. Employee
2. Training
3. Group
4. Event
5. Employee Training Map

Parent            Child
Employee      Employee Training Map
Training          Employee Training Map
Event             Employee Training Map
Group            Training
Event             Group

I would like to be able to create an Event and select a Group and a number of employees. Then I would like to create a record for each Training and Employee that I have selected in the Employee Training Map.

Example

Before
Training         Group        Employee      Event          Employee Training Map
T1    G1         G1             E1                   
T2    G1         G2             E2                                    
T3    G2                           E3                                    

Create an Event:                                                                                 
Event 
G1 E1 E2

Quickbase will automatically create records in Employee Training Map

After
Training         Group        Employee      Event          Employee Training Map
T1    G1         G1             E1                 G1 E1 E2    T1   E1
T2    G1         G2             E2                                     T1  E2
T3    G2                           E3                                    T2  E1
                                                                                 T2 E2

Three points:

(1) Can you confirm that this is the ER Diagram for your tables?



(2) I don't understand what you are indicating by tabular information you have listed under the Before, Event, and After headings as the column headings appear to be tables names not field names. Can you clarify what the fields are? 

(3) I get the impression you want to start on a form that creates and events and select a Group of Training and a set of Employees. A Group of Trainings can be selected with a lookup. But how do you propose to select a set of Employees?

1. Yes, this diagram is correct.

2. Each line is supposed to be a record in a table. When an event is added, a number of records are added equal to the cross product of the number of Employees and Trainings selected in the Event.

3. In my mind, the employees would be selected individually. There is not really a better way to group the employees logically. So our Training Coordinator would select the Group (G1) and the Related Employees (E1, E2, E3, E4). Then the records would be created based on the cross product of the Trainings in the Group and the Employees selected.

This can easily be done with script. However, the GUI portion of the solution would be a lot simpler if there was a way to select a set of Employees as a group (department, job title, location, manager etc) in a similar way that Training are selected through a common Group.

I agree. Unfortunately, our goal is to create a training app that is flexible, and will allow our training coordinator to sign up very different groups of employees for different employees.

Could you point me toward a java script resource that could get me started, or provide me with some basic instructions.

Thank you so much.

I think you should refine the workflow and criteria that would be used to select which Employees are to participate in the cross product. You will be creating a substantial GUI to select "random" employees. See this demo:

Process Selected
https://haversineconsulting.quickbase.com/db/bkfwuwx2p?a=td

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=462

My approach would be native as despite Dan's efforts, I don't do script.

I would make an Event record and then allow the user to "Quick Select" off a list of employees to add those employees to the Event.  by Quick Select, I mean that I have a technique which basically has the user click a button on the Event which creates or edits the current user in a table called User Focus and records the Record ID# of the Event.  Then I present the user with a list of employees where the user then can click click click to select which employees attended that Event.  Each click will create a record under that Event Record as a child, but does not disturb the report, so that it is quick for the user to continue to quickly select employees.  The user may use the normal filter box and dynamic filters on the table report to help narrow down which employees to select.

Then on that report there would be a button to return to the Focus Event.

So now we have our group of employees defined under the Event and now we need to create a record for each employee for each training type that was covered in that event.  So then the user would click to see a list of available training courses, and when they click, it would create an employee-training record for each employee for that training course.  That would be done with API_RunImport to basically import the employee list for the Focus group into the table of employee-trainings for the Focus Training Course.

If you wanted to work together to get this working on a Go To Meeting session, contact me via the information on my website  QuickBaseCoach.com.

It would probably take a couple or maybe three of hours to get this working.

I know that my approach may feel not normal for someone used to script, but it works well if you get yourself into a low code / no code mindset.