AnsweredAssumed Answered

Script to create summary of time

Question asked by flamecoder on Aug 31, 2016
Latest reply on Sep 6, 2016 by flamecoder

I want to create an emailed report of time spent on a project during the last week. I have a scaled down drawing to show the relations.

Project Summary.png

From the Project table my script finds the records in the Time table between a range in Time Date field.

Records are sorted by __kf_Designer ID.

I have a calculation field on the Project table that takes the Time Length seconds value from the Time table and puts it into hh:mm:ss.

I also have a summary field on the Project table that totals the hh:mm:ss from the calculation above.

I'm trying to use the GetSummary(Project:Time Log Summary;Project:_kf_DesignerID) while looping thru the groups, when a change in _kf_DesignerID is detected, to get only the records that are within the range but it doesn't seem to work correctly.

 

Can anyone tell me how to go about doing this?

Outcomes