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!
