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

• Mollie Connect in Zoho Books

  Have noticed that Zoho Books is missing the most popular payment provider in Europe: Mollie. Knowing that Mollie has a solid Java SDK, why is this not yet implemented in Zoho Books for European customers?  More info: https://docs.mollie.com/oauth/ov

• Unable to change Lookup field from Multi Select to Single Select

  I am trying to change a Lookup field in my Zoho Creator form from Multi Select to Single Select, but I am unable to find any option to do this.

• Simple Callback Notifications Needed

  My team are terrible at remembering their CRM callbacks, often due to how long in the future they are set for. Is there a way i can set an e-mail notification for when a callback is due? For example we set it for 9am one day and five minutes before they

• Personal Data (RODO), Cookies / Trackers - ePrivacy

  I have noticed several issues that should be addressed on the customer support page. Zoho Desk provides the support portal, but it currently lacks the following options: A GDPR and personal data processing consent checkbox before logging in, located in

• How to set a multi-lookup field as mandatory?

• Allow Multiple Scheduled Appointments with Zoho Support

  Dear Zoho Team, I hope you're doing well. First, thank you for introducing the option to schedule support calls via the Zoho CRM booking link. This has been a fantastic enhancement, eliminating the need for back-and-forth coordination when scheduling

• Audit Log for Zoho One Admin Panel

  Dear Zoho One Team, We would like to request the addition of an Audit Log feature in the Zoho One Admin Panel. This log should provide visibility into any changes made within the Zoho One admin panel and directory, including but not limited to: Adding,

• Personalize your booking pages with Custom CSS

  Greetings from the Zoho Bookings team! We’re introducing Custom CSS for Zoho Bookings, designed to give you complete control over the look and feel of your booking pages. With this new feature, you can upload your own CSS file to customize colors, fonts,

• Bug: OAuth 2.0 State Parameter fails with Pipe Delimiters (RFC 6749 Non-Compliance)

  I've discovered a bug in how Zoho's API Console handles the OAuth 2.0 authorization flow when the state parameter contains pipe characters (|), and I'm hoping the Zoho team can address this in a future update. The Issue Zoho's OAuth 2.0 implementation

• Custom Function to increment a value by one

  Hi, I'm trying to find a solution to set up a counter on CRM records that tracks how many times certain actions have taken place. As a specific example: We have a field on Deals called "Times Close Updated". This starts at 0 on record creation. I'd like

• Customer address in Zoho Bookings

  Hello,  Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps.  It would also be advantageous for the "list view" to show appointment times instead of just duration and booking

• Access token generate from the refresh token not working for API

  Dear Sir/Madam, When I use my refresh token to obtain new access_token, that token return INVALID_TOKEN when the same API is called. I made sure that my api site is correct and match the auth web site. However the original access_token work fine.

• why does my campaign move back to draft?

  Every time I try to send my email campaign, it reverts back to Draft status.. this has happened three times in a row..how do i find out what the problem is? Thanks

• Service and Parts Line Item Limitations

  Hi FSM Team, We work with clients who deliver large-scale field service projects. In many cases, a single work order can contain 200+ service and parts line items. Currently, Zoho FSM limits work orders to 30 service and parts line items. While this works

• 【Zoho CRM】やりとりの要約機能リリースのお知らせ

  ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、新機能のやりとり要約機能をご紹介します。 Zoho CRMのやりとりの要約は、Ziaが生成する機能で、データに関連付けられた最近のやりとりを簡潔にまとめて提供します。 メール、通話、ミーティング、メモなどを1つの明確な要約にまとめ、重要なポイント、過去の話し合いの要点、結果、次のステップを表示することで、日常的な課題に対処します。 Ziaの強みは、単なる要約にとどまらず、内容の解釈も行える点です。やりとりの要約では、顧客との会話に潜む遅延、フォローアップ漏れ、約束、期限、感情、意図を特定します。

• Recent post analytics not very useful

  Hi, I'm enjoying some aspects of the Zoho Social. like being able to schedule posts to multiple channels. However, the recent posts analytics is disappointing. For example, I put up a reel on Instagram and Facebook yesterday. Instagram insights shows

• What happens to the files created by user, whose account is deleted.

  Hello, I created a folder in the My folders names "Quote" I shared the same with my colleague. She created some files and folders in that folder over the period of 1 and half year. Now she left company, and I deleted her account from Zoho. What happens

• Internal Error When Accessing Team Inbox.

  All our users are seeing this error in teaminbox. Because its a critical tool kindly resolve this issue ASAP.

• Sharing URLs and direct access

  Hello, I am storing my team's email signature images on Workdrive. I am creating a public image download share and adding “?directDownload=true” so that the image can be accessed without the Workdrive interface. A few questions: 1) Can we generate friendly

• Zoho Mail Android app update: Calendar enhancements

  Hello everyone! In the most recent version of the Zoho Mail Android app update, we have introduced various new enhancements for the calendar module. Let's explore what's new. Drag and drop events to update the date and time We have enhanced the calendar

• Enhance Delay Configuration in Zoho Flow

  Dear Zoho Flow Support Team, We are writing to request an improvement to the delay configuration process within Zoho Flow. Currently, users are required to manually enter the exact delay duration (e.g., "2 days") in the delay block. This can be time-consuming

• Contratação ProdutivosX

  Bem-vindo(a) ao processo de contratação da ProdutivosX. Este formulário tem como objetivo coletar informações essenciais para análise de perfil profissional, alinhamento de competências e possível integração ao equipamento ProdutivosX. A ProdutivosX é

• Enhance Sign CRM integration

  Hello all, I'm working on a custom Deluge script to enhance the integration between Zoho CRM and Sign by using a writer merge template for additional flexibility. I want to replicate the post-sign document integration that exists between CRM and Sign

• Unified WhatsApp Number Management in Zoho Desk and SalesIQ

  Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers

• Problem using Zoho Desk API

  Goodmorning, I am trying to use the Zoho Desk API to create a dashboard in Grafana, but I am having a problem. Following the instructions in the API documentation, I created the API Console application (server-based application). Then I created the string

• Email Field Validation Incorrectly Rejects RFC-Compliant Addresses (Forward Slashes)

  I've encountered a validation issue with Zoho Creator's Email field that rejects RFC-compliant email addresses containing forward slashes, and I'm hoping the Zoho team can address this in a future update. The Issue When entering an email address containing

• Plug Sample #15 - Enable Human-Like, Contextual Interactions in SalesIQ with Zia Agents

  Zia Agents are conversational AI assistants designed to understand user intent and respond intelligently, helping businesses automate conversations and offer personalized support at scale. While Zia Agents are yet to be publicly released, access is currently

• Best way to schedule bill payments to vendors

  I've integrated Forte so that I can convert POs to bills and make payments to my vendors all through Books. Is there a way to schedule the bill payments as some of my vendors are net 30, net 60 and even net 90 days. If I can't get this to work, I'll have

• Seamless Round-Trip Navigation for Related Blocks (Detail View)

  As highlighted previously in this post (and here, here, here, and here), we still lack a fundamental capability for seamless navigation in Related Blocks. The popup that appears when adding a related record doesn't exist for viewing/editing existing records,

• Social Profile Logo Format

  Hello, I'm using Zoho Sites and am attempting to add a couple of social media accounts to my profile that aren't included in the default platforms that are available. What format is the logo required to be in? I have tried .png and .jpg with no success.

• How to create Sepa Direct Debit XML file: solution and code

  Even though Books provides a payment integration for Stripe and Gocardless (in Europe) there are customers that want to use the Sepa services of their own bank. Mainly because Stripe and Gocardless are quite expensive. In that case they would need a Sepa

• Traditional Spreadsheet vs Zoho Tables

  Hello everyone, This article explains the differences between Spreadsheet applications and no-code databases, such as Zoho Tables. While both tools belong to the "grid" family, the core difference lies in their purpose. A spreadsheet (such as Zoho Sheet,

• RFQ MODEL

  A Request for quotation model is used for Purchase Inquiries to multiple vendors. The Item is Created and then selected to send it to various vendors , once the Prices are received , a comparative chart is made for the user. this will help Zoho books

• Delegate Access - Mobile iOS/iPad

  We’re over the moon that delegate access is now available in Zoho Mail as we were nearly ready to switch platforms because of it! Is there a timeline on when delegate mailboxes will be accessible from the iOS and iPad OS applications? Thanks, Jake

• Request For Quotation (RFQ) module

  Hello, Do you have any plans to implement a RFQ module in to ZOHO Inventory? I would like to chose items that I require a price for, select a number of different suppliers to e-mail and have them submit there pricing online. I would then like to see a

• Support for Developing Zoho Recruit Extensions via Zoho Sigma

  Hi, I’m interested in building an extension for Zoho Recruit using Zoho Sigma. However, when I navigate to Sigma and attempt to create a new extension (via the "New Extension" option), Zoho Recruit does not appear as a listed service—only options like

• FOLDER DISAPPEARED

  Hello Zoho Community. I recently found a problem with no explanation: a folder in Zoho Analytics just disappeared, but the tables and SQL sentences still existed, the folder was not deleted. The solution for me in this case was to create a new folder,

• How to create estimates/Invoices with sub-totals

  Every other accounting package can create estimates and invoices with Sub-totals. How can I do that in ZohoBooks?

• Deluge scripts

  Why is there not a search function to make it easier to find the script of interest when modifications are required.

• Social media simplified with Zoho Social: Why should brands have a Threads profile?

  Just over a year ago, Instagram launched Threads, the all new social media app primarily focusing on sharing text online. It was welcomed by people worldwide with more than 10 million users in just seven hours, and it currently has over 175 million active

• Next Page