Any help with this? I have Globiflow setup now if that helps any. I'm starting to think it's not doable.
I changed User from a contact to a relationship with an app called Employee.
Basically my relevant data looks like this:
Employee Week Number Hours worked Year
Joe 1 7 2019
Joe 1 6 2019
John 2 3 2019
Joe 2 3 2019
I want to create these fields:
Total hours in week:
PTO/LWOP: (manual number field)
Overtime: (Total Hours + PTO - 40)
If you were on an item that was in week 2 of the year, it would show totals for week 2.
If unable to display on the same item, is there a way to make a good PDF report without having to do calculations in Exel afterward.
Would need to print a separate report per employee of hours work for week X.