ID Card Workshop User Manual

Professional membership management and ID card software for businesses and organizations.

  
General
Video Tutorial
Create a new project
Card Designer
Card Issuing Center And Record Seeker
Script Engine
Records Manager
Project Manager
Others

Sample 2 : Employee system with check in/check out feature

Following is a example of employee management system with check in and check out feature and checking log feature

*Click here to download the project file of this sample.(you can import the project file in Project Manager of ID Card Workshop)

Database Structure:
Field NameData Type
IDNumber
First_NameText
Last_NameText
DepartmentText
TitleText
LocationText
BuildingText
PhoneText
EmailText
Date_Of_HireDateTime
PhotoImage
Is_Card_ActiveYes/No
checking_logText
checked_inYes/No


 Here is the Check In Script(Manually Triggered Script):

var Time_now = new Date();
checked_in=true;
checking_log=checking_log+"Check In:"+Time_now+"\r\n" ;


 Here is the Check Out Script(Manually Triggered Script):

var Time_now = new Date();
checked_in=false;
checking_log=checking_log+"Check Out:"+Time_now+"\r\n" ;


By adding the above manually triggered scripts into "Records Preview" event, the scripts and a 'run' button will be appeared on the window of "Records Preview" window, the window will be appeared once a record found by records seeker. Select the script and click "run" button, the script will change the status of checked_in,  and adding the check in/out info into the checking log.

In order to ensure the size of the checking_long will not grow uncontrollably, you may also need adding the following automatically triggered log clearing script into "Records Preview" event, it will clear the checking log automatically after the length of checking_log is larger than 6000 letters.

if(checking_log!=null && checking_log.length>6000)
{
    checking_log="";
}   


 
 Copyright © ID Card Workshop Team