Start Work / Stop Work

[Charlie Ward]

I am currently using the Facilities Request (facilities_request) and the Requested Item (sc_req_item) tables to process requests from a record producer. I am needing to somehow create a "Start Work" and "Stop Work" button to log the actual time it takes a technician or request fulfiller to complete the request(task). We aren't using Facilities Request Task (facilities_request_task) table at the moment.

I'm not sure where to start. I see there is a Time Worked table and a Time Card table, however these aren't exactly what I'm looking for.

My goal is on a task record, specifically Facilities Request and Requested Item requests to have a "Start Work" Button and a "Stop Work" button. When the "Start Work" button is pressed, the time the work started is logged somewhere either in a field on the same table or some other table. When the "Stop Work" button is pressed, the time is logged also. The technician or request fulfiller would be able to do this multiple times if either they have to place the request on hold or possibly stop the actual work timer to work on a different task.

I've already created UI action buttons for our instance, to manually change the state by using a button instead of changing the drop down field on the form. However, it's the coding / scripts I'm needing assistance with.

Any help or guidance would be much appreciated.

[tcastleman]

I know you mentioned Time Worked table, but have you used the Time Worked field on a task form before?

That's really what it sounds like you want. It allows the tech to start an stop the time working on the ticket. Also you can have the times tracked in the activity log as well by adding it to the fields the log tracks.

[Charlie Ward]

Do you know how this would tie into reporting? That is my ultimate goal is to have dashboards to show How long it's taking to fulfill a request from open to close and what the actual technician work time is.

[Charlie Ward]

Also, it looks like the time only saves if you click Save/Update on the request.

For Example:

If there is a plumber who opens a request to replace a leaky faucet, he'd need to have some sort of stop watch on the request that he can say "Start Work" and then come back after he's completed the taks and then click "Stop Work" and the time would be logged. In between he may have to review a different record in the instance.

[tcastleman]

Get's tracked on a table called "task_time_worked". You can add this table as a related list to the facilities tickets to track it there. Also you can report off that table and build gauges from those reports.