Help

Custom rates for services based on employees

376 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joe_Gonzalez
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0