Requirements: Lookup Helper, Milestones PM+ Premium Edition
Create a Time Entry Line lookup field relating the Object in the Time Entry grid to be used for reporting.
Step 1. Select Child Object, Time Entry Line.
Step 2. Click ‘Select’ next to the Lookup Field created in Part 1.
Step 3. Select Related Object ID as the child matching field, then Select Record ID as the parent matching field.
Step 4. Expand Advanced Settings and uncheck both (Allow Overwrite of Existing Lookup Field Information and Allow Clearing of Existing Lookup Field Information).
Save and run.
To keep this lookup field updated as new time entries are logged, activate the setting then deploy a real-time trigger for the Time Entry Line in the Enable Real Time tab following the on-screen instructions.
Once the Lookup Helper setting has completed running and the real-time trigger has been deployed, you'll see that you now have a related list of Time Entry Lines available on your custom Object. Rollup Helper can be used to create a sum of the hours logged against the record, or reports can be created to view this data.
(1) Any time that is logged directly as a Time Entry Line record from the related list on your parent object will not appear on the grid. It is recommend to remove the new button on the related list to avoid this being an issue.
(2) Time Tracking settings must be setup in Milestones PM+.
|
|
|