Automating Attendance Tracking with Zoho Cliq Developer Platform

I wish remote work were permanently mandated so we could join work calls from a movie theatre or even while skydiving! But wait, it's time to wake up! The alarm has snoozed twice, and your team has already logged on for the day.

Keeping tabs on attendance shouldn't feel like guiding a flock of rebellious sheep. Hence, let's automate check-in and check-out notifications using the Zoho Cliq Platform Schedulers and the Zoho People API, eliminating the guesswork in attendance management and reducing the risk of errors associated with manual monitoring.

How does this solution benefit a business?

1. Real-time reminders reduce instances of ghost check-ins and ensure accurate recording of everyone's logged hours.
   
2. Essential for attendance tracking, payroll accuracy, compliance with labour laws, and audits.
   
3. The entire team stays informed, fostering a cohesive workflow that eliminates the need for micromanagement.      
   

Pre-requisites:  

Before beginning to script the code below, we must create a connection in Cliq with Zoho People. Once a connection is created and connected, you can use it in Deluge integration tasks and invoke URL scripts to access data from the required service.

Create a Zoho People default connection with any unique name with the scopes - ZohoPeople.Attendance.ALL , ZohoPeople.forms.ALL and ZohoPeople.leave.ALL

ⓘ Document for reference : Connections in Cliq 

 

How to obtain or locate the channel unique name in Cliq?

• Navigate to the top right corner of the channel and locate the three dots. Click it.

• In the menu that appears, select "Channel info" and a pop-up will open, displaying detailed channel information.

Hover over the "Connectors" section and click it. Under "API Parameters," you will find the Channel ID and unique name.

We need to create two schedulers, specifically one for check-in and another for check-out.

1. After a successful login in Cliq, hover to the top right corner and click your profile. Post clicking, navigate to Bots & Tools > Schedulers.
   
2. On the right, click the "Create Scheduler" button.
   
3. To learn more about schedulers and their purposes, refer to the Introduction to Schedulers.
   
4. Create a scheduler using your preferred name. Specify the following details: the scheduler name and a description.  
   

1. For the recurring period, choose the type "Weekly." Select Monday through Friday and set the time of execution to 11 AM or any other time that aligns with your company's check-in time, or customise the recurring period based on your specific use case.
   
2. Finally, click "Save & edit code" and paste the following code.
   

1. currentDate = zoho.currentdate;
2. currentDateString = currentDate.toString("dd-MMM-yyyy");
3. fromIndex = 1;
4. toIndex = 200;
5. // Get all active users
6. users = zoho.people.getRecords("employee",fromIndex,toIndex,{},"{CONNECTION_LINK_NAME}");
7. usersList = List();
8. usersList.addAll(users);
9. iterations = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25};
10. // Get All Employees ( 4000 MAX )
11. if(users.size() == 200)
12. {
13. for each  iteration in iterations
14. {
15. fromIndex = fromIndex + toIndex;
16. toIndex = toIndex + 200;
17. users = zoho.people.getRecords("employee",fromIndex,toIndex,{},"{CONNECTION_LINK_NAME}");
18. if(users.size() > 0 && users.size() == 200)
19. {
20. usersList.addAll(users);
21. }
22. else if(users.size() > 0 && users.size() < 200)
23. {
24. usersList.addAll(users);
25. break;
26. }
27. else
28. {
29. break;
30. }
31. }
32. }
33.  
34. // Get all the employees checkedin from the morning.
35. getAttendenceEntries = invokeurl
36. [
37. url :"https://people.zoho.com/api/attendance/fetchLatestAttEntries?duration=240"
38. type :GET
39. connection:"{CONNECTION_LINK_NAME}"
40. ];
41. latestAttendanceRecords = getAttendenceEntries.get("response").get("result");
42. checkedInUsers = List();
43. for each  userRecord in latestAttendanceRecords
44. {
45. checkedInEmployeeEmail = userRecord.get("emailId");
46. checkedInUsers.add(checkedInEmployeeEmail);
47. }
48.  
49. // Get all the employees who applied for leave both approved and pending ( Remove PENDING to exclude only the leave approved employees )
50. leaveApprovedEmployees = invokeurl
51. [
52. url :"https://people.zoho.com/api/v2/leavetracker/leaves/records?from=" + currentDateString + "&to=" + currentDateString + "&dateFormat=dd-MMM-yyyy&approvalStatus=[APPROVED,PENDING]"
53. type :GET
54. connection:"{CONNECTION_LINK_NAME}"
55. ];
56. info  leaveApprovedEmployees;
57. leaveApprovedEmployeesList = List();
58. for each  member in leaveApprovedEmployees.get("records")
59. {
60. leaveApprovedEmployeesList.add(member.get("EmployeeId"));
61. }
62. info leaveApprovedEmployeesList;
63.  
64.  
65. // Add the users to yet to checkin list if they are not checked from the morning and not applied for leave
66. usersYetToCheckIn = list();
67. for each  user in usersList
68. {
69. employeeEmail = user.get("EmailID");
70. employeeId = user.get("EmployeeID");
71.     employeeStatus = user.get("Employeestatus");
72. if(!checkedInUsers.contains(employeeEmail) && !leaveApprovedEmployeesList.contains(employeeId) && employeeStatus.equals("Active"))
73. {
74. usersYetToCheckIn.add(employeeEmail);
75. }
76. }
77.  
78. // Mention the list of users in the channel.
79. if(usersYetToCheckIn.size() == 0)
80. {
81. info "No users were found yet to checked-in at 11 PM today. Great to see everyone wrapping in on time! ✅";
82. }
83. else
84. {
85. usersYetToCheckInString = "";
86. for each  user in usersYetToCheckIn
87. {
88. usersYetToCheckInString = usersYetToCheckInString + "[" + user + "](mail:" + user + ") \n";
89. }
90. usersYetToCheckInString = usersYetToCheckInString.subString(0,usersYetToCheckInString.length() - 2);
91. response = Map();
92. card = Map();
93. card.put("title","Employees who haven’t checked in yet ( " + usersYetToCheckIn.size() + " )");
94. card.put("thumbnail","https://i.pinimg.com/originals/85/e9/f3/85e9f3f5ac31fc5aab586e208297f43d.gif");
95. card.put("theme","modern-inline");
96. response.put("card",card);
97. response.put("text",usersYetToCheckInString);
98. info zoho.cliq.postToChannel("{CHANNEL_UNIQUE_NAME}",response);
99. }
    

1. Now, let's follow the same steps and create a scheduler for checkout reminders. Under the recurring period, choose the type as "Weekly." Select Monday through Friday and set the time of execution to 7 PM or any other time that aligns with your company's checkout time, or customise the recurring period based on your specific use case.
   
2. Click "Save & edit code" and paste the following code.
   

1. attendanceResponse = invokeurl
2. [
3. url :"https://people.zoho.com/api/attendance/fetchLatestAttEntries?duration=600"
4. type :GET
5. connection:"{CONNECTION_LINK_NAME}"
6. ];
7. info attendanceResponse;
8. todayDate = zoho.currenttime.toString("YYYY-MM-dd");
9. latestAttendanceRecords = attendanceResponse.get("response").get("result");
10. usersWithoutCheckout = list();
11. if(latestAttendanceRecords.size() > 0)
12. {
13. for each  userRecord in latestAttendanceRecords
14. {
15. userEmail = userRecord.get("emailId");
16. dailyEntries = userRecord.get("entries");
17. for each  dailyEntry in dailyEntries
18. {
19. if(dailyEntry.containsKey(todayDate))
20. {
21. todayEntryDetails = dailyEntry.get(todayDate);
22. attendanceLogs = todayEntryDetails.get("attEntries");
23. for each  logEntry in attendanceLogs
24. {
25. if(!logEntry.containsKey("checkOutTime"))
26. {
27. usersWithoutCheckout.add("{@" + userEmail + "}");
28. }
29. }
30. }
31. }
32. }
33. }
34. usersWithoutCheckoutString = usersWithoutCheckout.toString("\n");
35. if(usersWithoutCheckoutString.trim().length() == 0){
36. usersWithoutCheckoutString = "No users were found checked-in after 7 PM today. Great to see everyone wrapping up on time! ✅";
37. }
38. response = Map();
39. card = Map();
40. card.put("title","List of users who remain checked in ( " + usersWithoutCheckout.size() + " )");
41. card.put("thumbnail","https://media.tenor.com/Hd8nLZZTPRYAAAAi/alarm-clock-alarm.gif");
42. card.put("theme","modern-inline");
43. response.put("card",card);
44. response.put("text",usersWithoutCheckoutString);
45. info zoho.cliq.postToChannel("{CHANNEL_UNIQUE_NAME}",response);
    

Wrapping up and checking out for the day, hopefully

Whether you're from HR, tired of chasing attendance logs, or an enthusiastic team lead trying to increase your team's visibility and adjust workload accordingly, Cliq Platform's schedulers are essential and ensure that accurate tracking is consistent and compliance is maintained. Additionally, this would be scalable to handle organizations of any size.

If attendance tracking is a binge-watchable series, what plot twist would these reminders add to your team's script? Let us know in the comments below!

• Topic Participants

• Harsha SS

  

• Ram Freedman

  

• Sticky Posts

• Automate attendance tracking with Zoho Cliq Developer Platform

  I wish remote work were permanently mandated so we could join work calls from a movie theatre or even while skydiving! But wait, it's time to wake up! The alarm has snoozed twice, and your team has already logged on for the day. Keeping tabs on attendance

• Automating Employee Birthday Notifications in Zoho Cliq

  Have you ever missed a birthday and felt like the office Grinch? Fear not, the Cliq Developer Platform has got your back! With Zoho Cliq's Schedulers, you can be the office party-cipant who never forgets a single cake, balloon, or awkward rendition of

• Customer payment alerts in Zoho Cliq

  For businesses that depend on cash flow, payment updates are essential for operational decision-making and go beyond simple accounting entries. The sales team needs to be notified when invoices are cleared so that upcoming orders can be released. In contrast,

• Accelerate Github code reviews with Zoho Cliq Platform's link handlers

  Code reviews are critical, and they can get buried in conversations or lost when using multiple tools. With the Cliq Platform's link handlers, let's transform shared Github pull request links into interactive, real-time code reviews on channels. Share

• App Spotlight : PagerDuty for Zoho Cliq

  App Spotlight brings you hand-picked apps to enhance the power of your Zoho apps and tools. Visit the Zoho Marketplace to explore all of our apps, integrations, and extensions. In today's fast-paced world, seizing every moment is essential for operational

• Recent Topics

• GCLID arrives not in CRM with iframe integrated ZOHO Form

  Hello amazing community, I enabled Adwords integration in ZOHO CRM. I have a ZOHO Form integrated in a wordpress. I tested iframe and Javascript. I enabled the "handover" GCLID in the ZOHO Form. When I add a GLID with http://www.example.com/?gclid=TeSter-123.

• Bidirectional sync between Zoho Bookings and Zoho CRM - Part 1

  Hey, community members! The default integration between Zoho CRM and Zoho Bookings is unidirectional, which means that any appointments booked, rescheduled, or deleted in Zoho Bookings will be reflected in Zoho CRM. However, any modifications made to

• Is it possible to edit placeholder text?

  In the master slides I want to make sure my templates have more meaning for the users and want to replace the standard placeholder text with something more instructional. Instead of "Click to edit Mast subtitle styles" I want to have "Click to enter reporting

• How to allow download of a file AFTER information is collected?

  I can't find this anywhere. Can someone help with what seems to be a pretty basic web function today? - File is stored in Workdrive - Prospect goes to a URL where the file is located - System requests prospect to enter "Name" and "Email" - An email is

• Add Baseline methods to API

  There are no API methods for creating or querying baselines,  Use case: Customer is notified of the current project start date according to plan via another product/integration. We would like to auto create a baseline (Automated via API) at the point

• Fixed Assets beg balance

  Hello, I trust you are well I'm a new zoho books user and I find it difficult to plug in the fixed assets balance and here's what I have done: 1- I imported the fixed assets data into the fixed assets module as per the instructions 2- the import process

• CRM Deluge how can link attach file with workdrive file.

  Hi, We have create file at workdrive and would like to link to attachment at crm module by deluge. Right now can only upload it to attachment but can not link the file from workdrive. Thank you

• Feature announcement: AI-powered document generator in Zoho Sign

  Hi there! We recently announced manual document creation by offering an editor within Zoho Sign. Today, we are excited to announce AI-powered document generation to help you draft agreements, purchase orders, and other important business documents in

• Permanently deleted files

  Is there a way to get back permanently deleted files from your account if they were accidentally deleted and no longer recoverable from the recycling bin? I know I am probably screwed but I just figured I would ask.

• Shared Mailbox in iOS app

  Hi, On the desktop I am using a Shared mailbox for our company's general mailbox that somebody else should be able to view. In the iOS app however I can't find it? Old sources on the internet says this isn't possible but that can't be right? Somebody

• Tip #41- Simplify Compliance and Efficiency with Zoho Assist’s Data Cleanup Feature- 'Insider Insights'

  Managing device data efficiently is just as important as securing remote access. With Zoho Assist’s Data Cleanup feature, admins can easily remove outdated or unnecessary device records, keeping the console organized and secure. This action is carried

• Revenue Management: #6 Revenue Recognition in Professional Services Industry

  If you run a consulting firm, agency, or any service-based business, you have a situation where you have signed the contract, maybe even sent the invoice, and have received some initial payments. So, can you consider this as revenue? What if the project

• Zoho fsm scheduled maintenance dispatch

  Hi, I'm reaching out regarding an issue I'm encountering with the Scheduled Maintenance feature in Zoho FSM. I’m trying to configure it so that it automatically dispatches all maintenance jobs scheduled within the next 150 days, starting from today. However,

• zoho.inventory.getRecords returns no records

  I running a custom function (Deluge) in Zoho Flow with a connection to Zoho Inventory. To debug the problem, I created the test function below. It returns "Number of contacts fetched: 0". This confirms that there's no issue with the org ID or connection

• Feature announcement - Simplifying document creation with Zoho Sign

  Hi there, We are pleased to announce the release of our document creation feature, enabling you to create, edit, and finalize documents like agreements, purchase orders, and contracts without relying on external tools or applications. &lt;br&gt; This

• Integrating File Attachments in Zoho Flow Email Notifications

  Hi, I would like to be able to send an email once an entry is made in a form, and in this email, I would like to attach a file that has been added to the form using the ImageUpload (or FileUpload) widget. So, I started by creating a flow that will trigger

• Zoho project purchases

  Hi Folks, I think having a purchase module in projects will help in putting together a project p and L. Project wise purchases and expenses.  Do let me know your thoughts.

• How can I restore all the deleted Time entries of a Task in Zoho Projects

  How can I restore all the deleted Time entries of a Task in Zoho Projects? Query: In Zoho Projects, I cloned a task and deleted the time entries from the cloned task. However, this also deleted the time entries from the original task. How can I restore

• Is there a way to make an account inactive in ZoHo Desk

  We have a few Clients "Accounts" that we no longer do business with. It would be beneficial for them to not show up in lists. However, we want to go back and view tickets, time, etc.

• How to set the value of the Phone field importing contacts in Zoho Desk

  Hi everyone, i'm new in Zoho Desk, we're setting up the environment and i'm importing contacts from another CRM using a file CSV and i'm getting a problem with phone numbers (italian): the leading zero is cut away, also if the value is inside double quotes.

• How to center a field inside a section?

  I’ve been trying to center a field inside a section in Zoho Canvas. When I align it visually, it looks centered in the editor, but after clicking Save, the field appears misaligned on the actual canvas. I also tried setting the field to full width, but

• Kaizen #192 - Implementing Custom Token Persistence in Python SDK

  Welcome back to another week of Kaizen! Last week, we discussed how to implement Login with Zoho using OAuth 2.0 and saw how to bring it to life in a real-world application with the Zoho CRM Python SDK. We also discussed how Zylker Academy built a custom

• Showing the map along with mileage expense

  When you use the GPS to track mileage, it shows you the map of the actual path travelled. It would be very useful and practical to save that map with the mileage expense, so that when the report is created, it provides a map of each mileage expense associated

• Enable Validation Rule for Multi-Select Picklist Field

  Zoho, Please allow validation rules for multi-select fields.

• File Upload field not showing in workflow

  Hi, I have added a field on Zoho CRM. I want to use it in a workflow where that particular field is updated based on another field, however it is not showing up in the field list to select it in the workflow. Why is this please?

• CRM Custom function updating a module record shows the Super Admin user as the record modifier

  Dear Zoho CRM Team, Is there any way to update this so that when a custom function has updated a record the Super Admin user doesn't become the modifier? This happens on the record as a modifier and shows up in the audit logs. It would be more useful

• Best way to fetch employee names from Zoho People into Zoho Creator Inventory Stock Form field Employee Name Lookup

  Hi Team, I have a requirement in my Zoho Creator application (Inventory Stock Adjustment) where I need to fetch employee names from Zoho People and use them as a lookup in a form. Currently, I am considering using an integration field to fetch this data

• get file api is returning Junk data

  I am working on extension development where at one point I need to retrieve attachments on records I found out I can use only invokeconnection and not invokeurl in extension development The invoke connection returns the image in raw binary format. When

• Need help with message box

  End user updates many records at once. Each have unique serial number. They want a confirmation box that says starting number, ending number and qty. Is there any way to do this? I been searching and asking support but seems like no great solution.

• [Webinar] The Transformative Power of Gen BI

  Traditional decision-making tools are no longer enough. The integration of generative AI into business intelligence (BI) is proving to be a true game changer—enabling businesses to make faster, smarter, and better informed decisions. Early adopters of

• Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

  Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon

• How to access the saved Query using API?

  I have created a query in setting. Is it possible to access it from a API? What's the endpoint? I tried /v8/queries/important_deals but didnt' work.

• création d'une base de données

  base de donnee d'un lycée

• User Session variables to recall after form submit & redirect to menu

  Hey, Forgive me if this is a simple answer I have overlooked. I have built a big onboarding process for my SAAS platform which is built and managed by an external Dev team. I am hoping to embed my new creator app on the SAAS platform. I have a menu page

• Zoho Writer Merge Template with data from Zoho Analytics Views

  Hello, Is there any way to pull information from Zoho Analytics and put it into a Merge Template? I am trying to create a bulk export of one report that filters on a field to create a single document for each of the filter fields.

• Having to enter bill before stock shows as available.

  Hi, Am I right in thinking you must create a bill from the purchase order receipt before the goods are available for shipping?

• Agent Availability Report

  From data to decisions: A deep dive into ticketing system reports Businesses need to track when their support agents check in and check out from work. This report, titled Agent Availability, is one of the static reports that helps managers track the number

• AI-driven construction analytics using Zoho Projects Plus

  Construction projects thrive on timelines; if a project is completed on or before the expected time, it makes headlines, but if it gets delayed, the company’s credibility will be at risk. Such projects require precise planning and constant monitoring,

• Canadian payroll

  Hello ZOHO, is any updates on when payroll for Canada will be available?

• Unified customer view: Bringing product intelligence into your CRM data

  For businesses today, applications and digital interfaces are the main touch points in the customer journey. While Zoho CRM data already tells who your customers are and what they buy, Zoho Apptics tells you how they interact and engage with your product.

• Next Page