Filtering shifts in payroll

Hi All,

Am new to coda and this is my first time posting so please go easy on me if it is a stupid question.

I am trying to filter the shifts in the “pay run info” table, so I can do calculations on the correct information and then populate other fields on the same line such as hours worked and
base pay. At the moment I have only been able to get it to show all shift or just the shifts from the full pay run, I need it to show just the shifts relevant to that person in that pay run.

Thanks in advance for your help on this matter.

Hey Rob,

Welcome to the community!

I can’t edit/copy your doc, so I’m not able to see the relations between the tables or see what fields are calculated . Therefore I have to do some guessing.

You seem to have 5 tables in the document, one having it’s name hidden and I assume none of them is a view of another.

My assumption is also that the ‘shift’ field in the ‘pay run info’ table is related to the ‘NoName’ table, but I really don’t understand how the PRI* fields relate to those tables.

Since I don’t understand your doc I can only give a partial response here, but maybe it can get you started. This would be the formula for the ‘Shift’ field: "NoName.filter(CurrentValue.Person = ThisRow.People)’

Since the 1st and the 3rd row have the same ‘People’ value (John), the results in the ‘Shift’ field will be the same. I would need to understand a bit better the data model to give you a proper answer.

Hope this helps,

Pablo

3 Likes

That did the job I have been fighting with that formula for 3 full days.
You are a star.

1 Like

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