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?