Post

1 follower Follow
0
Avatar

Timesheet calculations

New to Podio and setting it up for project management.  Figured I'd tackle the Time Clock first as it would be the hardest part. 

I have a Time Clock app with these fields

User (contact)
Time In (date with time)
Time Out (date with time)
Status (calculation): @Time Out !=null ? "Clocked Out" : "Clocked In";
Hours Worked (calculation): moment(@Time Out).diff(moment(@Time In),'hours',true);
WeekNum (calculation): moment(@Time In).isoWeek();
Year (calculation): moment(@Time In).format('YYYY');
Relationship: links to itself (Time Clock app) all fields - from my understanding this is required for All of or Sum of

As the user clocks out each day (i.e., not in a report), I want them to see a running total of hours worked that week. 

Basically the function would be: For User and WeekNum in Year, return total Hours Worked.  Seems simple enough and I've tried various things I've found on here but none have worked.  Later I want to show overtime and PTO also, but I can calculate those I think if I can get those hours for the week to work.

New to Podio as I said so may just not be going about it the right way.  I don't know Javascript either.

 

Jeff Clifton

Please sign in to leave a comment.

1 comment

0
Avatar

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.

Jeff Clifton 0 votes