I hope I can explain this shortly but I have a dispatch app with a few child tables one for employees, one with delivery routes, and one with vehicle info. A parent table called jobs is used to assign the employees to a route and a van and track their start and end times with total times and bonuses. I’m having trouble creating a table of timesheets based on the work or routes that person did for the week. I want to pull together all clock in/out times, total time worked, total bonuses, etc for each employee rather than for each job. I created a Timesheet table with all the employees manually added but if an employee is added or removed from the employee table it doesn’t reflect in the time sheet table. Also, the bonuses are yes or no for each route and I don’t know how to count how many they had. So basically I need to pull a table arranged by jobs and resort it into a table arranged by employees who did various jobs through the week. Necessary because one side is for dispatch, one is for payroll. Thank you so much for any help.
You should provide a detailed example of the data, and of your desired result.
I ended up using a slice.