Custom rates for services based on employees

I’ve researched some old topics but haven’t quite found the solution I need. I have a situation where there are different services and the pay rate for each service varies based on the employee who is performing it. Example:
Service 1: Jane Doe is paid $20, John Smith is paid $25
Service 2: Jane Doe is paid $30, John Smith is paid $35
Service 3: Jane Doe is paid $40, John Smith is paid $45

I’m using a Form for the employee completes some services. Also, there may be more than one service submitted for each job. Example:
1/20/22: Jane Doe submits an entry for Service 1
1/22/22: John Smith submits an entry for Service 1 AND Service 3
1/22/22: Jane Doe submits an entry for Service 1 AND Service 3

I want to be able to roll up the employees total pay rate for these entries. Based on the above example my rolled up value for the work done would be:
1/20/22 by Jane would be $20
1/22/22 by John would be $70
1/22/22 by Jane would be $60

I’m using a Single Select field to associate all of these against payroll weeks so that I can group the weeks and see what the total pay should be for each person.

Hope this makes sense.

Thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.