Forum Discussion

DavidHoover's avatar
DavidHoover
Qrew Trainee
6 years ago

How to create a total of weekly allocated hours per employee

I'm looking for a way to create a total of all allocated hours per employee, per week. I currently have a Summary Report that does display the information needed, but management wants to be able to tr...
App builders
NotificationsEmail
Quickbase Automations
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
I suggest that you decide which weeks management wants to look at.  Hopefully they will say like "well we usually only look out about 6 weeks.

So make a summary fields on the Employee Record to summarize the allocated hours for the current week. call it [Allocated Hours Current Week]

The filter on the summary will be

where date is during the current week.

The copy the field and called it [Allocated Hours Current Week + 1]
Adjust the summary filters to be where
ALL of 
Date is during the next 1 weeks


duplicate to 
[Allocation Hours Current Week + 2]
Adjust the summary filters to be where
ALL of 
Date is during the next 2 weeks
Date is not during the next 1 week

and keep going so the +3 will be
Adjust the summary filters to be where
ALL of 
Date is during the next 3 weeks
Date is not during the next 2 weeks


The you can make a report when any of those say 6 summary fields is  > 50 hours or whatever the threshold of concern is.

If they want more weeks out well, just turn up the music real loud and keep on duplicatin' that Summary field.  It's pretty quick once you get the rhythm of the mental pattern going for the field duplication.




DavidHoover's avatar
DavidHoover
Qrew Trainee
6 years ago
In this scenario where/how would a notification get triggered? I do already have a Summary Report that displays the total hours allocated for all weeks in the future grouped by employee and weekly end date- I also used some JavaScript to highlight/color the cells (employ row, weekly end date column) that are over (and under) allocated. But management wants to notified in email instead of just looking at the summary report. I'd also like to be able to display the total hours allocated to an employee for any given week when the project managers are allocating hours (so instead of just management getting an email notification, the PM's can see in real-time how many hours an employee is already allocated (for any/all tasks they are assigned).