Total # hrs work order spends with each department/time

Question

I have not been able to find a solution thus far.

Case: Have a department field with multiple departments and want to track how long a work order spends in each department, i.e. its duration.

[Date Modified] - [Date Created] is fine for first department the work order lands in, however, when the work order travels to the next department is where I get lost.

Any suggestions?

------------------------------
T$
------------------------------

markshnier__you · Answer

I can tell you my approach but I can't really walk through all the code to do this.i would set up a child table to Work Orders. It would have a department and a field for start date/time and End date time. It &nbsp;would also have a calculated duration field &nbsp;
And I would make a set of formula URL buttons to create a log entry to start a log entry with a start time and department and then hide those when the clock is running and have a button to edit the log entry to stop the clock.&nbsp;Contact &nbsp;me directly if you would like some help setting this up &nbsp;It &nbsp;does take a bit of setup but I can't think of a simpler way &nbsp;
------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jasonjohnson2 · Answer

I&nbsp; got an idea! In my job we do installs and check in and out the workforce per site which is similar. I have a schedule table which we can say is a Work Order table. Connected to that I have a Time Card table and connected to that is a Time Entry table. In your environment you can make a Timecard for each department. I made a KanBan Report and display it on my Work Order form. In this case you can use an Automation to create the timecards when a work order is made. In the end it is a great way in the for to drag a timecard over to check in/out without having to save the record or have it refresh the screen. I even have a section below to make edits. I have an image to show but please forgive the edit I had to do, a bit messy. Our people love the drag and drop feature and the best part unlike buttons no code. I still miss buttons.
------------------------------Jason Johnson------------------------------

donlarson · Answer

Mike,I chase this problem frequently.&nbsp; &nbsp;I recommend and architecture change.&nbsp; &nbsp;Instead of a Department field, create a Department Table.&nbsp; You then add a change table.

Then add a Summary field for the Maximum Record ID #&nbsp;on the Work Order Change Table and use that to relate&nbsp; the Work Order Change table to Work Orders.&nbsp; &nbsp;You can now create Look Up fields in Work Orders from the Change Table

Now to move the Work Order to another Department you have the Users add a Record to the Work Order Change Table.&nbsp; &nbsp;You might also use an Automation to create the record in the Change table based upon some criteria in the Work Orders Table.The nice thing about this is you now know exactly when every child record was created and can look at the Duration between those records with additional Summary Fields in Work Orders on the Create Date.Your users will also not be able to argue about the data the change happened.&nbsp; &nbsp;

​------------------------------Don LarsonPaasporterWestlake OH------------------------------

Forum Discussion

Total # hrs work order spends with each department/time

Related Content

Running Total

Totaling Child Records Live on Parent Form

Total Formula with 2 IF statements

Document Creation - Report Totals

Summary report & adding a total between grouping