Expand all | Collapse all

Total # hrs work order spends with each department/time

  • 1.  Total # hrs work order spends with each department/time

    Posted 12-19-2019 18:59
    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?


  • 2.  RE: Total # hrs work order spends with each department/time

    Posted 12-19-2019 22:34

    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  would also have a calculated duration field  

    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. 

    Contact  me directly if you would like some help setting this up  

    It  does take a bit of setup but I can't think of a simpler way  

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach

  • 3.  RE: Total # hrs work order spends with each department/time

    Posted 12-20-2019 08:52
    I  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

  • 4.  RE: Total # hrs work order spends with each department/time

    Posted 12-22-2019 19:46

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

    Then add a Summary field for the Maximum Record ID # on the Work Order Change Table and use that to relate  the Work Order Change table to Work Orders.   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.   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.   

    Don Larson
    Westlake OH