1 Reply Latest reply on Nov 6, 2012 9:27 AM by disabled_ntaylor

    time tracking

    MaryHickey

      Summary

      time tracking

      Product

      FileMaker Pro

      Description of the issue

      I am trying to figure out how to track time worked on a project in my data base over time. The idea is to have a start time button, stop time button and a total time calculation.

      I thought this would be a simple process but can not figure it out. Can some point me in the right direction?

      Or does someone know if there is there a pre-made template for this?

      Thanks

        • 1. Re: time tracking

               Mary Hickey:

               Thank you for the post.

                

               While there are a number of ways to do this, one way would be to use 3 Fields: TimeStart (Time Field), TimeStop (Time Field), and TotalTime (Calculation Field). Two buttons could be used, START and STOP. The START button sets a variable using the Get (CurrentTime) function and then the "Set Field" script step to set the field TimeStart to the result. The STOP button sets a variable using the Get (CurrentTime) function and the the "Set Field" script step to set the field TimeStop to the result. The third field TotalTime is a calculation field with the calculation TimeStop - TimeStart.

                

               Please note that you are posting to the Report an Issue part of the forum. It is intended for posting possible bug reports. Had you posted this to the FM Pro Forum section (see tab at top of screen), your post would have been seen by more people and probably gotten a quicker response.

                

               TSFalcon

               FileMaker, Inc.