AnsweredAssumed Answered

Email notifications to PM based on timesheet tasks?

Question asked by tomthor on Sep 19, 2012
Latest reply on Sep 19, 2012 by TerriEchegoyen4207684
Hi,

I could not find anything specific to this in the forums but I apologize in advance if this has been answered. I would like to set up a Process that does the below.

1.
Finds submitted times
2.
Locks the timesheets
3.
Send an email notification to the project managers based on the timesheet tasks of the resource
4.
Allow the project manager to approve the task (we have added an approved field on each task for this)

I am struggling with creating a process script that looks at a timesheet, looks at the task and then emails the project manager who owns that project/task.
Additional steps will be needed to deal with returns timesheets however, I think that part is ok.

We are keeping the general premise that resource managers approve timesheets, but we need project managers to approve the tasks. It is possible to assign the timesheet to assign groups, but I am looking to do this per individual project manager.

My gut is telling me that I will need a GEL script to
1. First extract the project manager email for each timesheet task (group by task)
2. Send the notification.
3. Do some assigning/Or permit project managers to approve task levels.

I’m pretty sure this has been done a couple of times and I would be very grateful if anyone could possibly shed some light. Are any of you running PPM with a similar rule?

Thanks,
Tom

Outcomes