Relation Data Employee Productivity/Efficiency

I’m not an expert, far from it, and I need help that may seem simple but I’m not able to develop it despite knowing that I have to use Relation for this…
I’m trying to create an Employee Productivity/Efficiency item in the app, something simple like Hours Worked per day / (divided) by the number of Jobs per day.
I have two Tables, the first one being LOG (Time Sheet) where I have the Employees ID, Hours per Day and Hours per Week among other information, while the second Table has the list of Jobs (by team) but to make it easier, let’s leave it by Employee.
I created a relation between both using Employee ID and I would like to be able to see the total number of jobs for that employee on the specified day in the LOG or, on the contrary, in the Jobs table, I could have the data on the hours worked on that day by employee.
First Image is JOBS Table
Second Image JLOG Table

As previously informed, the Job Table is by team but I am using the Employee ID for relation.

2 questions come to mind, silly perhaps:

  1. Does 1 log correspond to exactly 1 job and does 1 job correspond exactly to 1 log?

  2. Have you looked at Glide’s template gallery? It seems this type of task tracking application would be in there. Glide the company itself has built a number of templates and they might have a task tracking template.

Hi Nathan,
No, a log (timesheet) has several jobs.
In fact, I saw some task templates but I didn’t find anything that indicated the performance (productivity) of the employees.

So a job can contain multiple logs, and each log is recorded at the employee level?

What if multiple employees work on the same job? Where would you display this info?

1 Like

1 - Usually a log (one employee) contain multiple jobs. If you are talking about multiple logs from different employees, yes, there are multiple logs for one job.
2 - This will certainly happen. There are several employees doing the same job, but I haven’t thought about how to demonstrate this to everyone. I was initially thinking about being able to link the information to the team owner and then develop it for the others…

I’ll try to improve my explanation of how it works and what I need here:

1 - There are 15 employees;
2 - Everyone marks the Timesheet per day, this is what generates the LOG Table. The Timesheet can have more than one “Shift”, for example when the employee marks the entry, exit for lunch, return from lunch and exit (in this case 2 Shifts are generated). However, this is already consolidated in the LOG table, in addition to the daily and weekly value of the employee’s salary in the LOG.
3 - The employees work in teams, that is, the jobs are distributed to teams that have an owner but the entire team goes to work, but at this exact moment I don’t have the individual opening of the employees in the Jobs Table. They are opened by teams. So I’ll have to create a relationship to insert the workers individually.
4 - What I need is to have a Link between how long the employee worked and the day wage(LOG) and the number of Jobs he/she executed during that period.
For example, with a relation I can bring to the Jobs Table all the hours worked and daily salaries by the team owner, that is, I have the data but I can’t link it to the corresponding work day.