AnsweredAssumed Answered

Please help: automatic time in and time out using ID with barcode

Question asked by xtremu on Jul 16, 2010
Latest reply on Jul 16, 2010 by xtremu

Title

Please help: automatic time in and time out using ID with barcode

Post

I am currently working on a database for the gate entry system of our school wherein this system will track the student and employee information/record in the database which will show if they are currently enrolled or not and if they are still an employee or not.  We are using ID barcode for the gate entry to monitor the status of an individual and to record it in our database for the time in and time out activity.  The TIME IN will be done through first ID barcode detection of our system and automatically record the time in of that individual into our database, the second ID detection of our system will be recorded in our TIME OUT field and so on…

Student Table

Fields:

  1. Student info (such as First, Last name, address, contact #., etc)
  2. Student ID – number

 

History Table

Fields:

  1. Student ID – number/ auto-serial number
  2. Check In Time – Time
  3. Check Out Time - Time

I want to display the check In and Checkout time fields in the portal under student table. Is this possible so that there is an automatic check in and checkout time using their ID with barcode in the scanner and save that time in the database?

 I would appreciate any suggestions to make the functionality I described above to work properly.

Thanks and more power to the File Maker Pro 11 Advanced team.

Outcomes