3 Replies Latest reply on Nov 4, 2009 8:55 AM by philmodjunk

    Tracking Attendance



      Tracking Attendance


      I am a client trying to use filemaker pro and I was wondering if I can use it to track my employees' attendance by the # of times they are late. I am aware of how to track the amount of hours worked but I am trying to create a database where I am tracking them when they are late or absent.


      In another words, is(are) there any way to track the demerits?  And if there are certain amount that would alert me. I can't seem to work out the project layouts.


      please help.


      thank you so very much ! 

        • 1. Re: Tracking Attendance

          Seems like that you are using a prebuilt or custom system. Its hard to help without knowing what you are working with including your structure.


          Can one use FM to track attendence.... yes...  Can your system be easly modified to accommodate this request... not sure.

          • 2. Re: Tracking Attendance

            As what the previous poster stated it is hard to say what will work with your system without knowing how it is set up. But you could write a fairly easy script to track this kind of information.  If you have a system set up to track employee hours then you could set up a new field for each employee's "start time", and another field that will be your "tardies" or "Absences"

              Make a script that loops through all your records when you want it to, and search for entries that happened past the start time or not at all for absences. Increase the tardy/absence field by 1 whenever a record matches the critieria.  You could also set in your loop a if check to see if the employee has exceeded the acceptable amount of tardy/absences and display those employees in a new report.


             That is the non-technical explaination for you anyway :) 

            • 3. Re: Tracking Attendance

              Depending on how you set this up, you may not even need a script.



              Date (Date)

              EmployeeID (Number)

              EmployeeName (Text)

              TimeExpected (Time)

              TimeArrived (Time)

              GracePeriod (Number)

              cTardyFlag : (TimeArrived - TimeExpected)/60 > GracePeriod

              sTardyCount  (Summary, Total of cTardyFlag)


              If you Log each employee's arrival in this table, you can simply perform a find for a given employee, specifying a range of dates and sTardyCount will show the total number of tardies. You can also build a summary report that lists all employees and sTardyCount can be used to give you a break down of how many times each employee was late.