Automation#22 Track Ticket Duration at Specific Status

Hello Everyone!

Welcome back to the Community Learning Series! Today, we explore how Zylker Techfix, a gadget servicing firm, boosted productivity by tracking the time spent at a particular ticket status in Zoho Desk. 

Zylker Techfix customized Zoho Desk’s ticket statuses to align with their servicing process. Here’s their workflow: when a gadget was submitted for service, the ticket entered “Open” status. After an initial examination, it moved to “Service” status, mapped to the “Hold” type while repairs were underway. Once repairs were complete, the ticket progressed to “Billing” and then to “Closed” after payment and delivery. To improve operations, Zylker Techfix wanted to know how long tickets stayed in “Service” status, giving them insights into potential delays and resource use. With a custom function, they tracked this time in a custom field, then used it to generate reports that highlighted areas for process improvement.

With this custom function, you can gain a clear view of your support timeline, identify bottlenecks, and serve clients more efficiently. Let’s dive into how you can implement this custom function to refine your own operations and drive productivity forward.

Prerequisites

1. Create a Custom Field

To track ticket duration at a StatusName (call it In progress) mapped to the Status Type On Hold, 

     

      1.1 Go to Setup (S) >> Customization >> Layouts and Fields.

             Select Tickets under Layouts and the Department in which you would like to track the ticket duration. 

      1.2 Create a custom single line field in the Tickets layout of the respective department. 

            1.2.1 Click on the layout, add a single line field with a label StatusTime. 

                      You can label the field with your preferred name. 

      1.3 Note the API names for the the single line field to insert into the custom function.     

            To find the API name, Click on the Gear wheel icon of the single line field.

            Click on Edit Properties, you will find the API Name under the Edit Field. Refer to Create Custom Fields. 

2. Create a connection

      2.1 Go to Setup(S) and choose Connections under Developer Space.

      2.2 Click Create Connection.

      2.3 Select Zoho OAuth under Default Connection.

      2.4 Set the connection name as deskconnection.

      2.5 Under Scope, choose the below scope values:

             Desk.tickets.READ

             Desk.tickets.UPDATE

      2.6 Click Create and Connect.

      2.7 Click Connect and click Accept.

Connection is created successfully.

Create a Workflow Rule

1. Go to Setup, choose Workflows under Automation. 

2. Under Workflows, click Rules >> Create Rule.

In the Basic Information section,

3. Select Tickets from the drop-down menu under Module.

4. Enter a Rule Name and Description for the rule.

5. If you want to activate the rule right away, select the Active checkbox. Else, create the rule and activate it later.

6. Click Next.

 

In the Execute on section, follow these steps:

7. Select Field Update, Choose Status.  

8. Click Next.

 

9. Leave the Criteria section blank and click Next. (Add a criteria if you require it.) 

10. In the Actions section, click the + icon and select New next to Custom Functions.

11. Enter a Name and Description for the custom function.

12. Under Argument Mapping, give a desired Method Name. Map the arguments as below: 

      12.1 In the Argument Name field, type ticketId and from the Value drop-down list, select Ticket Id under the Tickets Section.                                         

13. In the script window, insert the Custom Function given below:

1. ///----<<<< User Inputs >>>>----
2. deskURL = "https://desk.zoho.com";
3. //Replace with your custom domain
4. //Replace your Custom Field API Name to Update Desired Type Status Duration Ex: Open 
5. durationApiName = "cf_status_name";
6. // ex: "cf_open_time"
7. //Replace your Desired Status Type Name Ex: Open
8. statusType = "On Hold";
9. // Open or On Hold or Closed
10. //Replace the Status Name 
11. statusName = "In Progress";
12. // Ex: In Progress, Waiting for Reply, etc
13. // ----<<<< Initial Configs >>>>----
14. logs = Map();
15. logs.insert("ticketId":ticketId);
16. openHoursToUpdate = 0;
17. openMinutesToUpdate = 0;
18. onHoldHoursToUpdate = 0;
19. onHoldMinutesToUpdate = 0;
20. //---------------------------
21. try 
22. {
23. // ---- start your logic from here ----
24. ticketStatusLifeCycleInfo = invokeurl
25. [
26.   url :deskURL + "/api/v1/tickets/" + ticketId + "/statusLifeCycle"
27.   type :GET
28.   connection:"deskconnection"
29. ];
30. logs.insert("ticketStatusLifeCycleInfo":ticketStatusLifeCycleInfo);
31. if(ticketStatusLifeCycleInfo != null && ticketStatusLifeCycleInfo.containsKey("statusLifeCycle") && ticketStatusLifeCycleInfo.get("statusLifeCycle").size() > 0)
32. {
33.   for each  statusInfo in ticketStatusLifeCycleInfo.get("statusLifeCycle")
34.   {
35.   statusType = statusInfo.get("statusType");
36.   statusName = statusInfo.get("status");
37.   if(statusType == statusType && statusName == statusName)
38.   {
39.     statusDuration = statusInfo.get("duration");
40.     if(statusDuration != null && statusDuration != "")
41.     {
42.     statusDuration = statusDuration.replaceAll(" hrs","");
43.     durationCollection = statusDuration.toCollection(":");
44.     hourDuration = durationCollection.get(0);
45.     minuteDuration = durationCollection.get(1);
46.     openHoursToUpdate = openHoursToUpdate + hourDuration.toNumber();
47.     openMinutesToUpdate = openMinutesToUpdate + minuteDuration.toNumber();
48.     }
49.   }
50.   }
51.   openHoursToUpdate = (openMinutesToUpdate / 60).toNumber() + openHoursToUpdate;
52.   openMinutesToUpdate = openMinutesToUpdate % 60;
53.   logs.insert("openHoursToUpdate":openHoursToUpdate);
54.   logs.insert("openMinutesToUpdate":openMinutesToUpdate);
55.   ticketUpdateParams = Map();
56.   ticketUpdateParams.insert("cf":{durationApiName:openHoursToUpdate + ":" + openMinutesToUpdate});
57.   logs.insert("ticketUpdateParams":ticketUpdateParams);
58.   ticketUpdate = invokeurl
59.   [
60.   url :deskURL + "/api/v1/tickets/" + ticketId
61.   type :PUT
62.   parameters:ticketUpdateParams + ""
63.   connection:"deskconnection"
64.   ];
65.   logs.insert("ticketUpdate":ticketUpdate);
66. }
67. }
68. catch (errorInfo)
69. {
70. logs.insert("errorInfo":errorInfo);
71. }
72. info "logs: \n" + logs; 
    
73. logs.insert("errorInfo":errorInfo);
    
74. info "logs: \n" + logs;

NOTE

a. In Line 2, Replace ".com" with the domain extension based on your Data Center.

b. In Line 5, add the API name of the custom field created within the Tickets layout. 

c. In Line 8 and line 11, enter the status type and status name. 

14. Click Save to save the custom function.

15. Click Save again to save the workflow.

Creating Ticket Tracking Reports

You can generate Reports under Analytics to view the time duration of your tickets in one go. 

Go to the Analytics module >> Choose Reports >> Add Report >> Select Tickets module and Time Entry under Related modules. Refer to Create Custom Report 

Let us know how this custom helps improve your ticketing process.

Until next week,

Warm regards,

Lydia | Zoho Desk 

• Topic Participants

• Lydia | Zoho Desk

  

• Mohd Hayzee

• Shivani | Zoho Desk

  

• admin

• Sticky Posts

• Register for Zoho Desk Beta Community

  With the start of the year, we have decided to take a small step in making the life of our customers a little easier. We now have easy access to all our upcoming features and a faster way to request for beta access. We open betas for some of our features

• Share your Zoho Desk story with us!

  Tell us how you use Zoho Desk for your business and inspire others with your story. Be it a simple workflow rule that helps you navigate complex processes or a macro that saves your team a lot of time; share it here and help the community learn and grow with shared knowledge. 

• Tip #1: Learn to pick the right channels

  Mail, live chat, telephony, social media, web forms—there are so many support channels out there. Trying to pick the right channels to offer your customers can get pretty confusing. Emails are most useful when the customer wants to put things on record. However, escalated or complicated issues should not be resolved over email because it's slow and impersonal.  When you need immediate responses, live chat is more suitable. It's also quick and convenient, so it's the go-to channel for small issues. 

• Welcome to Zoho Desk Community - Say hello here!

  Hello everyone! Though we have been here for a while, it’s time to formally establish the Zoho Desk Community; we’re really happy to have you all here! This can be the place where you take a moment to introduce yourself to the rest of the community. We’d love to hear all about you, what you do, what company or industry you work for, how you use Zoho Desk and anything else that you will like to share! Here’s a little about me. I am Chinmayee. I have been associated with Zoho since 2014. I joined here

• Webinar 1: Blueprint for Customer Service

  With the launch of a host of new features in Zoho Desk, we thought it’ll be great to have a few webinars to help our customers make the most of them. We’re starting off with our most talked about feature, Blueprint in Zoho Desk. You can register for the Blueprint webinar here: The webinar will be delivered by our in-house product experts. This is a good opportunity to ask questions to our experts and understand how Blueprint can help you automate your service processes. We look forward to seeing

• Recent Topics

• Issue showing too many consultations in my workspace link.

  Hi Team, I’ve set up two Workspaces to track meetings from different sources. So far, this has been working well, and the two Workspaces are differentiated without any issues. However, when I navigate to Consultations and share the link to my personal

• CRM Validation Rules Support Only Single Condition

  Simply put, CRM validation rules support only a single condition for each field on "All Records". You also cannot specify additional validation rules on the same field because it has already been used in an existing validation rule. The ONLY solution

• Unapproved Leaves are hard to distinguish in Attendance View

  This is a an unapproved leave request It appears in the Attendance view without any visual indicator if its approved or not For a whole day request this might be manageable but for hourly requests it gets very hard to know which are approved, which are

• Performance Appraisal Probation Period

  Hello All,  Is there any possible way to create an appraisal cycle for new staff members, at the end of probation period? Many thanks!

• Zoho Creatorの一括操作における処理の同期/非同期について

  現在、Creatorのレポート機能を利用して、複数のレコードに対して一括で処理を実行しようとしていますが、処理の実行順序について確認したいことがあります。 レポート内の複数レコードに一括で処理を実行した際、処理は同期的に行われるのでしょうか？それとも非同期的に行われるのでしょうか？ 【同期処理の場合】 レコード①に対する処理が開始され、終了後にレコード②に対する処理が開始され、最後にレコード③に対する処理が実行されるように、処理が順番に行われる場合。 【非同期処理の場合】 レコード①、レコード②、レコード③の処理が一斉に開始され、それぞれ並行して処理が行われ、全処理が終了する場合。

• Adding Chargebee as a Data Connector

  Is it possible to get Chargebee added as a Zoho Analytics data connector?

• Mail Delivery Failed

  Good morning,   I have just set up an account with 5 users, however each time a message is sent to 1 user a m'mail delivery failed' message is generated. See below.   Any ideas   Thanks   Rob   This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: robb@thesmartgroup.ae mailbox is full: retry timeout exceeded ------ This is a copy of the message,

• Delete commerce website

  I need to delete a commerce website, but the only option is to click on settings, REQUEST DELETE, choose an urgency notice, add a message....AND THEN nothing, no way to send the request. Why is nothing simple!?!?!  I just want to delete the store.  The

• Adding external users to Zoho Social under Zoho ONE licence - how to best achieve this

  My client has a small business, and we are looking to implementing Zoho ONE with a single flexible user licence as that is all they really need and offers the best pricing for the range of modules we eventually wish to set them up with, one of which will

• Has anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?

  Hi all, I’ve been experimenting with building my own AI support assistant and wanted to see if anyone here has tackled something similar within Zoho. Right now, I’ve set up a Retrieval-Augmented Generation (RAG) pipeline outside of Zoho using FAISS. It

• This mobile number has been marked spam. Please contact support.

  Problem Description: One of our sales agents in our organization is unable to sign in to Zoho Mail. When attempting to log in, the following message appears: This mobile number has been marked as spam. Please contact support at as@zohocorp.com @zohocorp

• What’s New in Zoho Inventory | April 2025

  Hello users, April has been a big month in Zoho Inventory! We’ve rolled out powerful new features to help you streamline production, optimise stock management, and tailor your workflows. While several updates bring helpful enhancements, three major additions

• When Zoho Tables Beta will be open to EU data center

  Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!

• Pass current date to a field using Zoho Flow

  I am trying to generate an invoice automatically once somebody submits a record in Zoho CRM. I get an error in the invoice date. I have entered {{zoho.currentdate}} in the Date field. When I test the flow, I get "Zoho Books says "Invalid value passed

• API: Mark Sales Order as Open + Custom Status

  Hi, it's possible to create Custom Status (sub-status actually) states for the Sales Order. So you have Open, Void. Then under Open you can have Open, and create one called Order Paid, Order Shipped, etc etc...which is grouped under Open. I can use the

• Multi-Unit Inventory with Flexible Unit Selection (Purchase in One Unit, Sell in Another)

  We need multi-unit inventory management in Zoho Books with the flexibility to choose units (e.g., Box or Piece) at the time of purchase or sale. For example, if 1 Box = 10 Pieces, we should be able to record purchases in Boxes but sell either in Boxes

• 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

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

  This is the error i keep getting when trying to use my Zoho Domain Mail. This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details Find attached. I hope this can be resolved very quickly so i can go on and make

• Tip 26: How to hide the "Submit" button from a form

  Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in.  Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and then

• filter broke my data

  I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize they

• Email address for forwarding is not saving and there's no confirmation ema

  Steps to reproduce: 1. Enter my forward email in the email forward section of the account 2. Click save 3. See a notification stating saved successfully 4. Refresh the page, no forward email is saved 5. No email confirmation received at the forwarding

• How do I move Notes around within a Group?

  It says here: " You can now sort notes by title (alphabetically), or by date modified and date created. You can even organize your notes by dragging and dropping them into a particular order. To sort your notes, simply go to Settings and tap “Sort By.” Please note: all sort settings will be saved and synced across devices, except for custom sorting. Custom sorting will be device specific."However, I am unable to 'custom sort' in either Notebook for Mac or on the Web. In addition, I can't find the

• javax.mail.authenticationfailedexception 535 authentication failed

  Hi, I am facing 535 authentication failed error when trying to send email from zoho desktop as well as in webmail. Can you suggest to fix this issue,. Regards, Rekha

• Pocket from Mozilla is closing shop. Don’t lose your favorites . Move them to Zoho Mail Bookmarks now! 📥🔖

  The end of Pocket shouldn't mean the end of your important links and content. Easily import them into Zoho Mail's Bookmarks and continue right where you left off. You can bring over your entire Saves, Collections, and tags just the way they are. Bookmarks

• Zoho Sign: need to leave document pending for up to a year, or maybe there's a better way?

  I have zoho one, maybe there's a better way to do this with another service than sending a zoho sign template from zoho crm. At the end of the day this requirement is due to regulations, no matter how dumb it may seem. I'm just looking for a way of getting

• 'Add Tax To Amount' not reflected in Invoice

  Hi Zoho Support, I'm experiencing an issue with tax calculation display in my invoice template. Despite having "Add tax to amount" box checked in the template settings, the Amount column is not showing the tax-inclusive total for line items. Current behaviour:

• To Do: shareable task links without login

  Hi! I’m using Zoho Mail and ToDo in my daily work, and I’ve run into one limitation that’s a real blocker for me. Right now, to share tasks with managers or directors, they need to have a Zoho account and be added to a group. In practice, many of them

• Separate Items & Services

  Hi, please separate items and services into different categories. Thank you

• Unable to edit or delete email address

  I signed up for free Zoho today. I usually am pretty good at understanding and configuring things like this, but your interface baffles me, and your online help is cryptic to say the least. I have spent hours just trying to set up a couple of email accounts in Zoho before pointing my domain MX records to Zoho. I solved some other issues on my own, but I can't figure out this latest problem: I have created two email addresses in Zoho. Let's call the first one myname@mydomain.com and the second one

• Mastering Zia Match Scores | Let's Talk Recruit

  Feeling overwhelmed by hundreds of resumes for every job? You’re not alone! Welcome back to Let’s Talk Recruit, where we break down Zoho Recruit’s features and hiring best practices into simple, actionable insights for recruiters. Imagine having an assistant

• We are unable to process your request now. Please try again after sometime or contact support@zohoaccounts.com

  I cannot sign up and return the error of we are unable to process your request now. Please try again after sometime or contact support@zohoaccounts.com

• Multi-currency - What's cooking ?

  Hi,       We have been doing this feature for sometime and we would like to give you some glimpses of it.  Working with Multi Currency :        Multicurrency support gives you the ability to handle business transactions in multiple currencies. You can define a base currency for your organization and add more currencies with exchange rates based on the base currency.  Setup :        From the setup page, you can manage all the currencies supported by your organization.       Currencies page        

• Integrating Chatbot with Zoho Creator Application

  Is it possible to integrate a chatbot with a Zoho Creator application?

• How to reduce programmatically the image uploaded by user?

  I need a function that will automatically reduce the pixel dimension to 800 x 600 pixels / 180 resolution or (approx. 1.37MB) of image uploaded by user from digital camera, for example, 2271 x 1704 pixels /180 resolution or approx. 11.1MB. After the user selected the image, the function will able to detect if pixels is above 800x600, process the photo (crop/ reduce) and resume upload. Need help...  

• Dark mode for Zoho Creator / Zoho CRM Code editor

  Hi Team, Is there any plans for Dark mode in Zoho creator / Zoho Crm code editor and development pages in pipeline?

• Is there a way to make a button scroll down?

  Looking to have a button on a landing page scroll down to another section on the page. Any recomendations outside of coding?

• Collective-booking event not added to all staff calendars

  We assign two staff to certain events. When the client books this event, it adds it to one staff calendar (the 'organiser') but not the other. How can I ensure all staff assigned to a collective booking get the event in their calendar? (A side note: it

• ZOHO Android Client

  Hi, I installed the Android app, but it had an issue, so I reinstalled it. I was able to add multiple accounts, but now when I add the next account, it just duplicates the one I already have and will not even allow me to enter the info for another account.

• I'd like to suggest a feature enhancement for SalesIQ that would greatly improve the user experience across different channels.

  Hello Zoho Team, Current Limitation: When I enable the pre-chat form under Brands > Flow Controls to collect the visitor’s name and email, it gets applied globally across all channels, including WhatsApp, Messenger, and Instagram. This doesn't quite align

• Enhance Barcode/QR Code scanner with bulk scanning or continuously scanning

  Dear Zoho Creator, As we all know, after each scan, the scanning frame closes. Imagine having 100 items; we would need to tap 100 times and wait roughly 1 second each time for the scanning frame to reopen on mobile web. It's not just about wasting time;

• Next Page