Hi all,
I'm working on an app which does several functions. In essence it tracks training across the organisation and acts as a training database.
My app has the following tables which would be relevant.
Employees (Contains the EmployeeID and Job Role Fields)
Courses Available (Contains the CourseID and the fields that determine which job roles should complete the course)
Session ID (Contains details of when each Course is being run)
Training_Record (This is a record of which EmployeeID has completed which Course and on which session. It also calculates whether the training is valid, expired or expiring)
What I need to do is pull a list of all the Mandatory training (Courses) an Employee needs to do, based on their job role, along with the status of their latest training.
If the employee changes role or the course changes requirements or we add a new employee or course this should update automatically.
I've replicated the steps from this template which has some of the core features which would get me part of the way there. This template has a feature where you can see what training an employee needs to complete based on their job role and whether the course has been designated as required.
To do this they have a bot which fires whenever a course is created or edited (Content Creation table) which populates Trainings table from which that information is then filtered out.
The bot fires a series of actions in the Content Creation table which the necessary number of rows to the Trainings table.
I've replicated this on my app. It works, except it times out at 121seconds due to the volume of employees. It seems as the current automation sequence can only deal with around 40 employees in the 121second limit. Issue here is that we have more than 40 employees who would need to complete mandatory training.
Iโve tried to use the same actions and add it as a Grouped Action which is manually pressed when a course is added. This works and runs the full 180 employees. The issue is that there is no way to update without it replicating the full 180 employees again and I cannot seem to filter out those records that already exist.
I'm wondering whether there is a more efficient way of doing what I require. Any advice or recommendations would be welcome.
LinkedIn
Twitter
