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.
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.