Requirement

Use Case

Pre-requisites

1. Search and install the Check-in/Check-out for Zoho Creator extension from Zoho Marketplace. Learn how to Install and Manage Extensions.
   
   

Alternatively, you can also install Check-in/Check-out for Zoho Creator extensions directly from the Zoho Creator. Navigate to the Operations section > Application > Marketplace > Extensions and install it.

Steps to Follow

1. Create a form with the following details to record the employee's details and check-in and check-out time.
   

   Form Name	Form Link Name	Field Type	Field Name	Field Link Name
   Employee Details	Employee_Details	Name	Employee Name	Employee_Name
   		Email	Email	Email
   		Phone	Phone	Phone
   		Address	Address	Address
   		Date	Date of Birth	Date_of_Birth
   		Image	Photo	Photo
   Employee Attendance	Employee_Attendance	Name	Employee Name	Employee_Name
   		Email	Email	Email
   		Date-Time	Check-In Time	CheckIn_Time
   		Date-Time	Check-Out Time	CheckOut_Time
   		Single Line	Status	Status

2. Create a page to add the Check-in/Check-out extension and add the required elements. For demonstration purposes here, we will be including the extension in our 'Dashboard' Page. Refer to this link to know how to build a dashboard.
   
   
3. Drag and drop the Check-in Check-out Widget extension listed under the Installed category under the Widgets section in the left pane.
   
   
4. Navigate to the page variables on the page and add the following page variables to include required parameters for the extension.
   

   Variable	Data Type
   appname	TEXT
   reportname	TEXT
   checkintime	TEXT
   checkouttime	TEXT
   criteria	TEXT
   dateformat	TEXT
   timezone (optional)	TEXT
   status	TEXT

1. 
   
   
5. Configure Page Script by adding the following script to the editor to supply data to the extension's parameters.
   
1. //Define values for the page variables.
2. input.appname = "task-management"; //Link name of the application.
   
3. input.reportname = "Employee_Attedance_Report"; //Report link name of the Employee Attendance form's report.
   
4. input.checkintime = "Check_In_Time"; //Field link name of the Check-In Time field in Employee Attendance form.
   
5. input.checkouttime = "Check_Out_Time"; //Field link name of the Check-Out Time field in Employee Attendance form.
   
6. input.criteria = "Email=\""+zoho.loginuserid+"\"" + "&Added_Time=\'" + today + "\'"; //Set criteria.
   
7. input.dateformat = "dd-MMM-yyyy"; //The date format specified in the date and time settings in your application settings.
   
8. input.timezone = "IST"; //Preferred time zone code.
   
9. input.status = "Status"; //Field link name of the Status field in Employee Attendance form.
   
6. Create a schedule to run on the preferred date and time to add the employee attendance entries for the day and to mark the status as 'Absent' for the absentees. Here, we have created a schedule to run daily at 00:00:01 hrs.
   
   
7. Click Add New Action > Deluge Script and add the following code in the Deluge editor.
   
1. //Fetch the  records from the Employee_Details form.
   
2. fetch_employees = Employee_Details[ID != 0];
   
3. //Add empty entries with the Employee_Name and Email in the Employee_Attendence form's report 'Employee Attendance Report' using the Deluge Add Records task
   
4. for each  data in fetch_employees
5. {
   
6. add_entry = insert into Employee_Attedance
   
7. [
   
8.   Added_User=zoho.loginuser
   
9.   Employee_Name=data.Employee_Name
   
10.   Email=data.Email
    
11. ];
    
12. }
    
13. //Fetch the absentees of the previous day ane mark the Status as 'Absent'.
    
14. fet_absentees = Employee_Attedance[Added_Time == today.subday(1) && Status == ""];
    
15. if(fet_absentees != null)
    
16. {
    
17. for each  absent_rec in fet_absentees
    
18. {
    
19. absent_rec.Status="Absent";
    
20. }
    
21. }

See How it Works

Related Links

1. Check-in and Check-out Extension
   
2. Understand Extensions
   
3. Install and Manage Extensions