Power of Automation:: Daily Time log summary broadcast to Zoho Cliq using Schedule Custom Functions

Hello Everyone,

A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it.

Requirement:

One of our customers would like to calculate the total time logs added by each developer at 11:59 PM and post a summary message in a specific Zoho Cliq channel along with the developer's name and email address as shown below. This was accomplished using Schedule Custom Functions.    

Custom function code:

 

/* TODO
*Replace the channel Unique Name (Line 4)

*Replace the email ids i.e user email in the criteria  (Line 8)*/
portalId = "XXXXXX";

endPointV3 = "https://projects.zoho.com/api/v3/portal/";

channelUniqueName = "testchannelpeq";

userParam = Map();

userParam.put("filter",{"criteria":{{"cfid":"4","criteria_condition":"contains","value":{"user email 1"}},{"cfid":"4","criteria_condition":"contains","value":{"user email 2"}},{"cfid":"4","criteria_condition":"contains","value":{"user email 3"}},{"cfid":"4","criteria_condition":"contains","value":{"user email 4"}},{"cfid":"4","criteria_condition":"contains","value":{"user email 5"}},{"cfid":"4","criteria_condition":"contains","value":{"user email 6"}}},"pattern":"1 OR 2 OR 3 OR 4 OR 5 OR 6"});

getUserInfo = invokeurl

[

url :endPointV3 + portalId + "/users"

type :GET

parameters:userParam

connection:"YYYYYY"

];

// info getUserInfo;

userAndLoghours = List();

for each  user in getUserInfo.get("users")

{

/* Get all time logs*/

moduleTemplate = Map();

moduleTemplate.put("type","task");

timesheetParam = Map();

timesheetParam.put("view_type","day");

timesheetParam.put("module",moduleTemplate);

timesheetParam.put("start_date",zoho.currentdate);

timesheetParam.put("filter",{"criteria":{{"field_name":"user","criteria_condition":"is","value":{user.get("id")}}},"pattern":"1"});

taskTimesheetResponse = invokeurl

[

url :endPointV3 + portalId + "/timesheet"

type :GET

parameters:timesheetParam

connection:"YYYYYY"

];

info taskTimesheetResponse;

if(!taskTimesheetResponse.get("time_logs").isEmpty())

{

log = Map();

log.put("display_name",user.get("display_name"));

log.put("email_id",user.get("email"));

log.put("full_name",user.get("full_name"));

log.put("log_hours",taskTimesheetResponse.get("log_hours").get("total_hours"));

userAndLoghours.add(log);

}

}

/*  Send message to channel*/

if(userAndLoghours.size() > 0)

{

response = Map();

slidesList = list();

slidesList0 = Map();

slidesList0.put("type","table");

slidesList0.put("title","Log hours of developer");

data = Map();

headersList = list();

headersList.add("Developer");

headersList.add("Email");

headersList.add("Logged Hours");

data.put("headers",headersList);

rowsList = list();

for each  details in userAndLoghours

{

rowsList0 = Map();

rowsList0.put("Developer",details.get("full_name"));

rowsList0.put("Email",details.get("email_id"));

rowsList0.put("Logged Hours",details.get("log_hours"));

rowsList.add(rowsList0);

}

data.put("rows",rowsList);

slidesList0.put("data",data);

slidesList.add(slidesList0);

response.put("slides",slidesList);

response.put("text",zoho.currentdate.toString("dd-MMM-yyyy"));

info response;

chat = zoho.cliq.postToChannel(channelUniqueName,response,"YYYYYY");

}

 

Make sure to replace XXXXX with your Portal Id and YYYYYY with Zoho Oauth connection link name along with scopes: ZohoProjects.users.READ, ZohoProjects.timesheets.READ, ZohoCliq.Webhooks.CREATE. Please find the screenshot of the sample Schedule function for reference.

We hope you found this post useful. If you have any questions, feel free to share them in the comments below.

 

 

• Topic Participants

• Saraswathi S

  

• Sticky Posts

• Automation Series: Auto-create Dependent Task on Status Change

  In Zoho Projects, you can automatically create and assign a dependent task when a task’s status is updated. This helps teams stay aligned, ensures reviews happen on time, and reduces manual effort. In this post, we’ll walk through an easy setup using

• Time Log Reminder

  Tracking the time spent on tasks and issues is one of the most important functions of a timesheet. However, users may forget to update the time logs because they have their own goals to achieve. But, time logs must be updated at regular intervals to keep

• Introducing the Zoho Projects Learning Space

  Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,

• Update on V2 API End-of-Life Timeline

  Dear Users, Earlier this year, we shared the launch of the V3 APIs and requested users to migrate from the older V2 APIs by December 2025. We have received valuable feedback from our users and partners regarding their migration timelines. We are happy

• Automation Series: Auto-update Phase Status

  Hello Folks! You can auto-update your phase's status based on status of underlying tasks using custom functions. In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your

• Recent Topics

• Admin asked me for Backend Details when I wanted to verify my ZeptoMail Account

  Please provide the backend details where you will be adding the SMTP/API information of ZeptoMail Who knows what this means?

• Optimising CRM-Projects workflows to manage requests, using Forms as an intermediary

  Is it possible to create a workflow between three apps with traceability between them all? We send information from Zoho CRM Deals over to Zoho Projects for project management and execution. We have used a lookup of sorts to create tasks in the past,

• Marketing Tip #15: Rank better with keyword-rich URLs for product pages

  Your product page URL is a small detail that can make a surprisingly big difference. Clean, readable URLs help in two ways: They’re easier for customers to trust and remember (no one likes clicking a link that looks messy or random). They help search

• Conditional fields when converting a Lead and creating a Deal

  Hi, On my Deal page I have a field which has a rule against it. Depending on the value entered, depends on which further fields are displayed. When I convert a Lead and select for a Deal to be created as well, all fields are shown, regardless of the value

• ATE Session on Payment Gateways: Our experts are live now. Post your questions now!

  Hello everyone, Our experts are all excited to answer all your questions related to payment workflows. Please feel free to join this session and learn more about this topic. If you have a query at anytime, please post them here.

• Upload data deleted all Zoho form data that we manage

  Good morning. Let me introduce myself, I'm Iky from Indonesia. I'm experiencing an error or problem using Zoho Forms. I manage Zoho Forms, but I previously encountered an error when I misclicked the delete button in the upload format. It apparently deleted

• ZOHO FORMにURL表示ができない

  初心者です。 ZOHO FORM で宿泊者名簿を作っています。 ゲストが、URLをクリックするとStripeで支払いができるようにURLを表示をしたいのですが、 上手くできません。 やり方が分かる方、ぜひ教えてください。

• Custom module - change from autonumber to name

  I fear I know the answer to this already, but thought I'd ask the question. I created a custom module and instead of having a name as being the primary field, I changed it to an auto-number. I didn't realise that all searches would only show this reference.

• No Automatic Spacing on the Notebook App?

  When I'm adding to notes on the app, I have to add spaces between words myself, rather than it automatically doing it. All my other apps add spacing, so it must be something with Zoho. Is there a setting I need to change, or something else I can do so

• Holidays - Cannot Enter Two Holidays on Same Day

  I have a fairly common setup, where part-time employees receive 1/2 day's pay on a holiday and full-time employees receive a full day's pay. Historically, I've been able to accommodate this by entering two separate holidays, one that covers full-time

• Zoho Bookings and Survey Integration through Flow

  I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would be

• Campaigns set up and execution assistance

  Hello Community, Can someone recommend a professional who can assist with the completion of my set up and deployment of Campaigns? Looking for a person or company that is not going to ask for big dollars up-front without a guarantee of performance to

• Zobot with Plugs

  Hello, I am having a problem with Zobot using Plugs. Here is my current flow: When I run the flow, I should immediately see the messages from the initial cards (Send Message cards), then after running the plug, and finally, see the messages after the

• Kaizen #223 - File Manager in CRM Widget Using ZRC Methods

  Hello, CRM Wizards! Here is what we are improving this week with Kaizen. we will explore the new ZRC (Zoho Request Client) introduced in Widget SDK v1.5, and learn how to use it to build a Related List Widget that integrates with Zoho WorkDrive. It helps

• Remove Powered by Zoho at the footer

  Hi, I've read two past tickets regarding this but it seems that the instructions given are outdated. I assume the layout keeps on changing, which makes it frustrating for me to search high and low. Please let me know how exactly do I do this now? Th

• Error AS101 when adding new email alias

  Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.

• No Need To Fix Something That Is Working

  Zoho Books is a great financial tool which helps businesses to become more efficient and productive with day-to-day operations. As such, every change, upgrade, improvement needs to be carefully thought before implemented in the software and I'm sure Zoho

• Using email "importance" as workflow-criteria

  I'd like to set up a workflow that triggers if an incoming email has been flagged as "high importance" but I'm not seeing any way to do that. Hopefully I'm just missing something obvious...?

• This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

  I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the

• What is Resolution Time in Business Hours

  HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

• Check & Unchecked Task Segregation in Export

  It must have a feature to represent checked and unchecked tasks as [ ] and [✅] respectively when exporting it to Arratai or WhatsApp ; as Keep Notes by Google contains…

• WorkDrive Download Issue

  My client has been sending me files via WorkDrive, which generally has worked fine. Recently files won't download at all. If you try and individually select and download a file, a popup will appear in the bottom right saying it's preparing and then it

• Feature Request: Add Tax ID Display on Event Tickets

  Hello Backstage Team, I’ve had several clients bring up an issue regarding tax compliance when creating events. For tax purposes, they are required to show their Tax ID on the event tickets. Currently, this isn’t an option, so they have to manually generate

• Resolution Time Report

  From data to decisions: A deep dive into ticketing system reports What are time-based reports? Time-based reports are valuable tools that help us understand how well things are going by breaking down key metrics over specific periods. By tracking, measuring,

• Support Custom Background in Zoho Cliq Video Calls and Meetings

  Hello Zoho Cliq Team, We hope you are doing well. We would like to request an enhancement to the video background capabilities in Zoho Cliq, specifically the ability to upload and use custom backgrounds. Current Limitation At present, Zoho Cliq allows

• Add RTL (Right-to-Left) Text Direction Button in Zoho Cliq

  Greetings Zoho Team, We would like to request the addition of an RTL (Right-to-Left) text direction button in Zoho Cliq, similar to what is already available in other Zoho apps like Zoho Desk. Currently, while using Zoho Cliq with the English interface,

• Enable Backgrounds and Video Filters for 1:1 Cliq Calls Across All Zoho Entry

  Hello Zoho Cliq Team, We hope you are doing well. We would like to request an enhancement related specifically to 1:1 video calls in Zoho Cliq. Current Behavior Zoho Cliq currently provides background and video filter options in the following scenarios:

• Proposal: Actionable API Error Messages to Reduce Support Ticket Volume

  I've encountered a long-standing frustration with how Zoho Creator's API communicates errors to developers, and I'm hoping the Zoho team can address this in a future update. This issue has persisted for over 9 years based on community discussions, and

• Zoho Flow: Stripe a Zoho Marketing Automation

  Hola! Quiero hacer un flujo con Zoho Flow, para que cuando se haga un pago en Stripe, añada el lead en Zoho Marketing Automation. Lo he configurado, configurando el disparador como "Payment created" y mapeando el campo de Stripe "Receipt email address".

• Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

  Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

• Need Customer Item Inward Module along with QC

  Need Customer Item Inward Module along with QC 1. Using Transfer Orders hit the item balance sheet 2. Items without inventory it becomes difficult for tracking purpose. 3. Custom Modules become tedious to capture multiple items, item subforms are not

• LESS_THAN_MIN_OCCURANCE - code 2945

  Hi I'm trying to post a customer record to creator API and getting this error message. So cryptic. Can someone please help? Thanks Varun

• Zoho email

  I need a list of email addresses of all contacts on my zoho

• Shift-Centric View for Assigning and Managing Shifts in Zoho People

  Hello Zoho People Product Team, Greetings and hope you are doing well. This feature request is related to Zoho People - please don't move it to zoho one! We would like to submit a feature request regarding the shift assignment and management view in Zoho

• Zoho Sheet for Desktop

  Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?

• Introducing parent-child ticketing in Zoho Desk [Early access]

  Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

• cant upload images in signature- urgent help needed. ta!

  HI, I have been trying to insert the company logo in the signature. i have tried it several times since yesterday, the longest I waited was 1 hour and 12 minutes for the pop up window to upload a 180 KB .jpg file. what am i doing wrong.. an urgent reply

• Add Ticket button in Home view

  When I go to the My Tickets or the Knowledge Base view in our Help Centre, the Add Ticket button is available, but not in the Home view. I would really like for it to be displayed in the Home view as well. Is this possible? Thanks.

• 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

• Add zoho calendar to google calendar

  Hi I keep seeing instructions on how to sync Zoho CRM calendar with google calendar but no instructions on how to view Zoho calendar in my google calendar.

• Next Page