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

• Incremental Migration Issue – Ticket Showing Resolution on Dec 9 Despite Urgent MX Cutover (Ticket ID: 152080262)

  I am experiencing an issue with Zoho Mail incremental migration from Rackspace. The initial full migration completed successfully, but the incremental migration for one mailbox failed immediately with the message: “User not exist” This appears to be a

• Change Last Name to not required in Leads

  I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions for

• Resend Client Portal Invitation + View Email Delivery Status

  Hi Zoho Team, We hope you are doing well. We would like to request two important enhancements related to the Zoho Creator Client Portal invitation process. At the moment, when we add a user to the Client Portal, Zoho Creator automatically sends an invitation

• Get user last login

  1. Is there a way to programmatically get the last user login to trigger certain workflows? 2. Is there a way to programmatically access the custom fields on a user's account?

• Seeking Zoho Creator Expert (Delivery Management App / Logistics Ops) — Built & Deployed Before

  Hi everyone, We’re building a Delivery Management App (focused on delivery operations for now) using Zoho Creator. We’re looking for a Zoho Creator expert who has already developed and deployed a similar delivery/workflow system and can assist us with

• Zoho Expense Import Reports Won't Work Because Default Accounts Already Exist

  Im trying to import reports from another Zoho expense account to mine and im getting errors that won't allow the import to happen The account name that you've entered 'Ground Transportation' already exists. Enter another name for the account and try again.z

• Adding Multiple Files to a Zoho Vault Entry

  There is a old blog post talking about adding multiple file attachments to one Zoho Vault Secret: https://www.zoho.com/blog/vault/introducing-new-features-in-zoho-vault-powerful-password-sharing-wider-storing.html Is that still possible, I can see how

• FNB South Africa Bank Feed

  I should've thought this wouldn't work. As suspect, Zoho claims to be able to pull bank feeds from First National Bank (South Africa), but fails everytime. I suppose Xero (or even Sage One) is the way to go? If they (miraculously) get it to work again,

• Dropshipping Address - Does Not Show on Invoice Correctly

  When a dropshipping address is used for a customer, the correct ship-to address does not seem to show on the Invoice. It shows correctly on the Sales Order, Shipment Order, and Package, just not the Invoice. This is a problem, because the company being

• Zoho unreliable

  Some mails are delivered, others not. How can I trust Zoho any more? Some friends get my e-mail, some don't. Same with receiving e-mails: Some I get, some not. If I use Google, everything works well. But Zoho?!!! How to solve this problem? I already reported this problem before, but didn't get any reply. Thanks, Kim

• the custom domain forwards by default to the old career site / how to switch it off??

  dear friends, how to switch off the old version of the career site?? The set up custom domain forwards directly to the old site, so that I cant publish it... Any ideas? Thank you! KR, Victoria

• Preserve Ticket Issue Mapping When Migrating from Jira to Zoho Projects

  Hello Zoho Projects Team, We hope you are doing well. We are currently exploring a full migration from Jira to Zoho Projects, and we identified a critical limitation during the migration process involving Zoho Desk integration. Current Situation: We use

• Recording Shopify/Amazon fees in Zoho Books - Zoho Inventory

  We are currently flushing out the connections between Shopify/Amazon and Zoho Inventory. For other users of Zoho Books - Zoho Inventory, where and at what point do you record the merchant fees associated with theses channels? I have gotten mixed responses

• Pre-fill webforms in Recruit

  I don't want to use the career site portal (as I have my own already), but I would like to direct users to the application forms for each role, from my website job pages. Is there a way to pre-fill fields in Recruit application forms, so that I only have

• Taxes Payable Adjustment

  I am from Canada and I need to make an adjustment to my Taxes Payable (HST) account.  Basically I need to take a portion of the amount within Taxes Payable and expense that portion to another account.  The adjusting entry would like like the following:

• ASAP Widget Not showing "My Tickets"ed

  Hello Team, I have created a ZOHO ASAP Widget and embedded to my portal app.clearvuiq.com , widget renders ok and I can open tickets from widget. However I want my opened tickets to be visible in the widget. How can I achieve that?

• Bug Causing Major Sync & SO Access Failures in Zoho POS

  We are experiencing critical and recurring issues in Zoho POS that all trace back to role-permission handling defects in the latest POS app version. These issues directly affect syncing, login ability, and Sales Order access for role-restricted users

• How to view CRM Sales Orders in Desk

  What's the usual way to view all CRM sales orders linked to a contact, when viewing a ticket in Desk? I don't want to have to open a new tab to see the order in CRM. And the Desk CRM sidebar doesn't seem to be configurable. Would I have to use an extension

• Kaizen #219: Actions API - Webhooks APIs - Part 1

  Hello all!! Welcome back to a fresh Kaizen week. In the previous weeks, we covered Workflow Rules APIs, Actions APIs - Email Notification APIs, Tasks Update API, and Field Update API. This week, we will continue with another Actions API - Webhooks API

• Pricing Strategies: #3 Services never Stop with just Plans

  "Hey, while you're here, could you also take a look at the vegetable patch?" Aaron hears that line almost every week. He runs a small gardening service, the kind where customers subscribe to a simple monthly plan that includes basic maintenance, mowing,

• Cropping Photos for Zoho Sites

  Hi, I'm wondering if there is a built in crop tool for zoho sites for my photos so I can crop them and see what the crop looks like on the site?

• bulk edit records and run internal logic

  hi there is few logics in manner "it this than that" logics work well when i edit entry openning it one by one (via workflow "on add/edit - on success" , for custom field "on update/on user input") but when i try bulk edit records - logic does not work.  how can i turn on logic to work as programmed - for mass editing records via bulk edit?

• Possible for first Signer of Sign Form to specify the next signer in the sequence

  We have many use cases where multiple signers need sign the same document. We'd love to be able to use sign forms, where the a signer who uses the Sign Form link can specify the name and email address for the next person in the sequence.

• BUG: Can't copy-paste data outside Sheet

  Currently I can't paste data copied from inside any of my Zoho Sheet files to any other app. Copy-paste works inside the sheet It does NOT work between two different sheets These sheets are built from automation templates Everything works fine if I create

• Zoho CRM Community Digest - November 2025 | Part 1

  Hello Everyone! Here’s what came through in the first half of November: new updates and a few helpful community discussions with real, notable solutions. Product Updates: Android App Update: Inctroducing Swipe Actions You can now swipe left or right on

• Upload own Background Image and set Camera to 16:9

  Hi, in all known online meeting tools, I can set up a background image reflecting our corporate design. This doesn't work in Cliq. Additionally, Cliq detects our cameras as 4:3, showing black bars on the right and left sides during the meeting. Where

• Truesync for Linux

  Is Truesync available on linux ?

• Hidding/excluding specific picklist options from filter

  Hi. Is it possible to hide/exclude specific picklist options from this filter? I don't want them to be shown when someone tries to filter in the leads module

• Subforms to Capture Multi-Row Data in Job Sheets

  Subforms transform your job sheets from simple checklists to powerful, data-rich forms. In field service work — whether maintenance, inspection, installation, or repair — a single job can involve multiple repeatable entries: readings, parts used, activities

• Add "Fetch Composite Item" Action for Inventory

  I want to make a Flow that uses information returned in the GET call for Composite Items, and it's not currently available in Zoho Flow. Please consider adding this functionality.

• Adress Labels for sending of the oder und barcode

  We want to print with my address labels to stick on the order of the ware can. there are these options?

• printing individual labels - Dymo LabelWriter

  I am trying to print individual labels to my Dymo LabelWriter - has anyone done this? Latest Update (December 2025): The Canvas Print View is now available! We encourage you all to try it out and share your feedback with us. Learn more here: Zoho CRM

• Zoho Creator for Agriculture

  Greetings, I am starting to work on  Zoho Creator specifically for the agricultural field, any recommendations, tips or ideas that might be helpful ? Also, if you are interested by any means in working on such project, kindly contact me. The project is

• Custom Print Layout

  I would like to create a custom print layout of a Lead or Contact. Is there a way to do that? What I mean is that if I'm viewing a specific lead or contact I'd like to be able to print or export that lead/contact and only print and/or export certain information.

• Print View

  Nothing happens when I'm in a module , ie; Contacts, and I hit the Print View Button. Even when it does come up and say "loading", nothing loads

• Get Holiday ready with Zoho Mail's Offline mode

  With the holiday season right around the corner, this is the perfect time to get ready to unplug, relax, and enjoy a well-deserved break. In addition to preparing yourself, you can also make sure your organization members are set for their time away from

• Solution to Import PST File into Office 365.

  MailsDaddy OST to Office 365 Migration Tool is an outstanding solution to recover OST files and migrate them into Office 365 without any hassle. Using this software users can multiple OST files into Office 365 with complete data security. It offers users

• Zoho CRM Kiosk issues

  Firstly this is for a system on the AU servers if that makes a difference. Issues are as follows (For Kiosk): 1. Re-ordering fields in the screen builder is broken. The fields seem to be re-ordering themselves, unless you order everything by moving the

• Email Template Edits Not Saving

  I can make an edit, click save, and see the blue bar annimation at the top, but the edits don't actually save. Important, because my email templates are now broken and clients are receiving bad emails. Tried on Chrome, Firefox and IE.

• Default Ticket View - Table?

  Guys, We mostly use the table view to queue tickets. Maybe I am missing it - but how can I set that view as 'default" for all our agents? Thanks JV

• Next Page