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

• Zoho IP blocked by SpamHaus

  ERROR CODE :550 - 5.7.0 Your server IP address is in the SpamHaus SBL-XBL database, bye

• IMAP Communication Problems - IMAP Down Again

  We are experiencing the same problems over the last week or so that were supposedly 'solved' according to this thread. Zoho Imap Down Again This is affecting attempts to use IMAP on multiple ISPs and users so is definitely narrowed down to Zoho problems.

• Can't login to Zoho mail

  I'm logged into Zoho but when I try to go in zoho mail I get: Invalid request! The input passed is invalid or the URL is invoked without valid parameters. Please check your input and try again. I just set up my mx records and stuff with namecheap a few

• Hotmail is STILL blocking the zoho mail IP

  Greetings, as I already mentioned in my last message, my Zoho IP has been blocked by Hotmail for more than 15 days. Although someone said that the issue was "solved," it still isn't, and this amount of time seems neither normal for a "serious" company,

• Keyboard shortcut M key

  I'm trying to customize my keyboard shortcuts and assign the "m" key. But it says the key is already assigned. I've looked through all my shortcuts and can't see any assigned "m". When I select an email and press the M key, nothing happens. What is the

• Manage customer access across multi-brand help centers

  Hello everyone! Managing customer's access across multiple brands has been streamlined with the ability to invite, reinvite, approve, reject, and deactivate contacts individually for each help center brand . This enhancement gives administrators precise

• White Label certificate

  Hi all, About 72 hours ago, we fulfilled all steps for white labeling (CNAME to point to mail.cs.zohohost.eu), but since then the configuration page is now stuck at "generating certificate" since 3 days. When I execute an NSLOOKUP mail.webfoundry.be it

• Unusual activity detected from this IP. Please try again after some time

  When i try to create new addresses on my account i am getting this error, it has been 24 hours now and i am still getting this error can anyone help

• How to add a new domain in my account?

  Probably zoho has the worst UI in the market. Cannot add a new domain to manage a new email address.

• Report sorting not working

  I make extensive use of Summary reports and Pivot Tables. Most of these reports are structured such that I have several columns of "information" data that I want displayed, followed by one or more "Data" summarizations. For example, I have the following

• New Enhancements in Wizards

  Dear All, Wizards help you break a long form into a series of smaller forms on different screens, making it less overwhelming. We are thrilled to introduce a couple of enhancements to wizards in Zoho CRM: Enhancements for conditional rules in Wizards

• Find and Merge Duplicates to trigger webhook

  My sales team uses the Find and Merge Duplicates feature often to cleanup records in the CRM. We use webhooks to signal to our internal tools database when new Contacts are created, updated, or deleted, in order to keep our DB in sync with Zoho CRM. However,

• Charting the 2025 Voyage: Zoho Invoice's Year in Review

  2025 has been a year of progress, productivity, and purposeful growth for Zoho Invoice. From expanding into new regions to refining everyday workflows, each update was designed to help businesses stay compliant, get paid faster, and work with confidence.

• How to Hide System-DefinedTemplates in Service Report

  Is there any option available to hide system-defined templates? these templates are causing confusion for field users.

• WhatsApp Report in Bigin CRM

  Reporting feature for Bigin CRM’s integrated WhatsApp that provides insights such as: Number of WhatsApp conversations closed Number of messages sent and received Number of conversations replied to Response and closure metrics for WhatsApp chats More

• Issue with Azure DevOps Integration in Zoho Flow

  Hello, All workflows between Zoho Flow and Azure DevOps have stopped working for several days now. Upon further investigation, it seems that the connection to Azure DevOps is no longer directly supported. Indeed, Microsoft has deprecated the Azure DevOps

• Narrative 16: Simplify with workflows

  Behind the scenes of a successful ticketing system: BTS Series Narrative 16: Simplify with workflows What is a workflow? A workflow organizes business tasks in a defined sequence that makes each step clear to all participants. This ensures work is completed

• Zoho Invoice Customer Login Portal

  Are there any plans for a customer portal to Zoho Invoice, ala Freshbooks?  I would like customers that I invoice to be able to login to review invoices and invoice history.  I have not switched from Freshbooks for this very reason.

• Random Leads are being created

  Hi, Every few days I am getting random leads that are being created with no form interactions at all. The email addresses are from obvious spam, such as 'Easymerchantsx'. When I look at the timeline, there is a Visit record and then a Lead Created record,

• Print a price list or price book

  Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

• Bar Chart -- sort X-axis

  Hi! I created a bar chart ("Top 10 Products by Revenue") X-axis: Product Name Y-axis: Revenue Filter: Revenue - Top 10 Here's a picture: http://screencast.com/t/ZTJlZTdkNz The x-axis is sorted alphabetically by Product Name. How can I force it to sort numerically by Revenue?

• ZoHo Flow Custom Function not Processing JSON

  JSON is being escaped and converting all the quotes in the JSON to '&quot;' Here's the Code: void InsertRowInE123EligibitySheet(map input) { rawData = get("data",""); decodedData = rawData.htmlDecode(); data = decodedData.toMap(); sheet_id = "ID GOES

• Managing functions

  Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created

• Zoho FSM - Service Appointment Trouble Adding Field Agent

  Hello, I just started using Zoho FSM and I'm currently adding older work orders from prior Field Service application I use. The work order that im trying to add is from an earlier date, and when I try to add a field agent to a service appointment it does

• 年内最後のユーザー向けイベント：5名限定！ 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (12/18)

  ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 12月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら（無料） https://us02web.zoom.us/meeting/register/QHn6kJAcRs-znJ1l5jk0ww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。

• How do I get my account id?

  Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts

• Zoho Quartz Screen Recording

  Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you

• auto close automated alert tickets which are similar

  Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves

• Maintain knowledge base integrity by moderating article comments

  Hello everyone, A knowledge base provides a self-service platform where customers can refer to articles, user manuals, and other resources to learn about the company's products or services and troubleshoot problems. Often, readers leave a comment on the

• Making another calendar your default calendar

  I am trying to make another calendar my default calendar when I add events to it. It keep going to a single calendar, I need it to go to my google calendar by default, as this is linked to other services / websites. I cannot find an option to make it

• Option to Delete Chats in IM

  Currently, there is no option to delete any chats in IM, regardless of their source.

• Referencing a cell from another sheet

  My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by

• Group mail for external email addresses

  Hello, I was just wondering if the Group mail feature works with external email addresses - e.g. gmail.com or a completely different domain? it seems only internal addresses (hosted with Zoho) receive the mail. Thanks, Oliver

• The email address you have entered belongs to a different deployment/region.

  Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward

• Use Zoho Flow Credits for CRM ‘Actions by Zoho Flow’

  Hello Team, We would like to submit a feature request regarding credit usage for “Actions by Zoho Flow” in Zoho CRM. Use Case: We are Zoho One users and actively use Zoho Flow, where our organization has 52,000 Flow tasks per month. In Zoho CRM, we use

• Unusual activity detected from this IP. Please try again after some time.

  Hello Zoho admin and IT team We are a registered website in Eloctronic services and we been trying to add our users to the zoho system but this issue faced us ,, hope you unlocked us please.

• Alert if a field is ticked.

  Hi There, We have two modules named Opportunities (Deals) and End Users (CustomModule1), as per the image below. Within Opportunities, we have a lookup field that looks up from the End Users Module. We are looking to get an alert either via email or another

• Zoho CRM Analytics - Allow To Reorder Dashboards

  I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go

• Sending a Template to Sign

  hi, trying to send a template to be signed using this as a test: $accessToken = "1000.xxx" $templateId = "1234" $uri = "https://sign.zoho.eu/api/v1/templates/$templateId/createdocument" $payload = @{ templates = @( @{ template_id = $templateId request_name

• Adding Choices in a Sub-Form Dropdown

  Hi, Has anybody tried Adding Choices to a Dropdown in a Zoho Creator Sub-Form programmatically? My Deluge code adds rows to a subform with 2 fields A and B. A - text field. B - dropdown. My Deluge script adds the row and displays A successfully. For the

• Next Page