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 single-line field to insert into the custom function.     

            To find the API name, click the Gear wheel icon in the single-line field.

            Click on Edit Properties, and 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 Desk 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

• Choose Component for User Filter

  This filter in the Choose Component for User Filter would be better if had an Order or Group by function. Also, the Specify the default filter values: is very confusing and limiting.

• Preventing auto-redirect to Parent Record on Save...

  Our users often create records from the related list on th left side of the screen. They click the blue "plus" button to create the record. This is handy, but for some modules, or situations, they would like to remain on the record AFTER clicking "Save",

• Uplifted homepage experience

  Editions: All editions. Availability update: 17th February 2026: All editions in the CA and SA DC | JP DC (Free, Standard and Professional editions) 23 February 2026: JP (All Editions) | AU, CN (Free, Standard, Professional editions) 27 February 2026:

• Zoho Desk - Event Calendar View

  Hi Desk team, Are there any plans to introduce a calendar or timeline view for Events in Zoho Desk? It would be very helpful if we could see Events visually in a calendar and/or timeline. This is very helpful when desk side support activities need to

• Re-Apply SLA When Ticket Reopened from Closed Status?

  If you have an SLA applied, timers are deactivated when going to "On Hold" status type and reactivated when going back to an Open status type. What we discovered is when a customer replies to a closed case and it reopens, the SLA is not applied and timers

• Option to Delete Chats in IM

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

• Is it possible to make tags "required"

  We would like to be able to make the tag field a requirement for agents before they can close a ticket. This would help with monthly reporting, where a lot of tickets end up with no tag, causing manual work to go back and add the correct tag for each

• Showing the map along with mileage expense

  When you use the GPS to track mileage, it shows you the map of the actual path travelled. It would be very useful and practical to save that map with the mileage expense, so that when the report is created, it provides a map of each mileage expense associated

• ID:2406331

  Hello, I have sent the form (ID:2406331) but no answer after two days. This is a paid subscription, I am not allowed to use the eighth paid slot of 50GB email space anymore, only 7 are being used. Is anyone going to help me please so I can use the eighth

• CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

  Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

• Approval Workflow for Purchase Orders Abrir

  The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can

• I would like to know wich person viewed the file

  I have a franchise and my Operative Manual is in WorkdriveI, the user can´t download but despite I know How many views the file had, I would like to know wich person viewed the file Is it possible? thank you

• Transaction Rule Matching

  Q1. Is there a method to have the Transaction Rules applied across multiple Bank Accounts? Q2. To match "contains" text in Transaction Rules, is a wildcard or regular expression required? Is it case sensitive? Would searching for "issue" in the following

• Notebook on Mac: Fuzzy fonts in list view

  Hi, I am running Notebook on Mac OS 26. Generally it works fine, and the font display in the notes themselves is crisp. However, in the notes list (left of the open note) the font of the note titles as well as first lines is noticeable fuzzy. Attached

• Trigger workflows from SLA escalations in Zoho Desk?

  Hey everyone, I’m currently working with SLA escalation rules in Zoho Desk and ran into a limitation that I’m hoping someone here has solved more elegantly. As far as I can tell, SLA escalations only support fairly limited actions (like changing the ticket

• Zoho CRM Email Templates 100% Width No Background How?

  Hi, On the Zoho CRM Email Templates in setup > customization > templates > new templates > I choose blank template, but still it puts in a gray background and a max width for the email. I just want to make an email that looks like an email I would send from gmail that has no background or max width. How do you do this? 

• ZOHO CRM Quote Export / Quote Report

  How can I either Export my quote list, or create a Report that shows all quotes AND includes the NOTES field in a column. I attempted to Run a Report which includes ALL FIELDS, however it does not include the Notes Field (but oddly does include the fields

• Introducing Radio Buttons and Numeric Range Sliders in Zoho CRM

  Release update: 1. 2 March 2026: Currently out for CN, JP, AU and CA DCs (Free and standard editions). For other DCs, this will be released by mid-March. 2. 26 March 2026: CA, SA, AU, JP, CN DCs - Free, Standard, Professional, Enterprise, Ultimate, CRM

• All new Address Field in Zoho CRM: maintain structured and accurate address inputs

  Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24

• Adding a Mark Up

  Can you use the discount column to be a mar up column on estimates and invoices?

• URGENT. Recovering email without eArchive

  Hello, I have deleted some email from my trash but do not have eArchive. Is it possible to recovery without this? many thanks!

• Subscription Statuses - Dunning

  How are other companies handling the scenario when customers don't pay and dunning takes over? Our issue is that in my situations, we want our customers to be able to catch up their late payments and continue their subscription after the dunning process

• Logo Doesnt appear on email

  Hi, 1. PROBLEM: mails sent to customer from zoho invoice ( Estimates and incoices etc.) Logo doesnt appaer on email. 2. SUGGESTION: there must be an option to select from google fonts if we want specific font to the pdf templates. thanks

• How to see Statement Details Shown in Unclassified Transactions in All Transactions?

  All, The list of Unclassified Transactions show the Statement Details and Descriptions. What is the method to see that column in the All Transactions list? -Thanks!

• Non-Avalara Tax Automation wtih Zoho Books

  We are paying a ridiculous amount for Avalara. Our team wants to make a change, but they're the only software fully integrated with Zoho. We also don't have the bandwidth to do this manually, so we do need some sort of automated software solution. We

• Migrating to the new outgoing webhook model in Zoho Connect

  Dear User, Outgoing webhooks configured across the Zoho Connect Integrations page, Zoho Flow, and Zapier will stop working after May 31, 2026. This is due to an upcoming upgrade to our outgoing webhook flow. This update is mandatory only for networks

• Create formula calculations in Assemblies for scaling quantities

  Something we have been encountering with our composite items is dealing with scaling of quantity of one or more items within the composite assembly relative to the number of complete units being sold. I.e. running the equation 2(n-1) on one of the assembly

• Lastest update

  The latest update to notepad has completely trashed all my notes. If I go to view it it just opens up a screen with a box with dotted lines around it for me to add something I can import saved nodes but you can't view them at all. Anybody else having

• Tip #67- Exploring technician console: Disable Input Devices- 'Insider Insights'

  Hello Zoho Assist Community! Picture this: you are in the middle of a critical remote session, carefully configuring a system or running an important update, and the customer accidentally clicks somewhere or types something that undoes your progress.

• What matters more in Zoho implementations: tools or system architecture?

  I recently worked on a full-stack migration for a catering equipment business using Zoho One with Shopify, and it raised a few interesting observations. The setup included migrating a large product catalog (around 9,700+ SKUs), integrating multiple supplier

• Facturation électronique 2026 - obligation dès le 1er septembre 2026

  Bonjour, Je me permets de réagir à divers posts publiés ici et là concernant le projet de E-Invoicing, dans le cadre de la facturation électronique prévue très prochainement. Dans le cadre du passage à la facturation électronique pour les entreprises,

• [Webinar] Solving business challenges: One tool for documents, forms, PDFs, e-signatures, and more

  Hi Zoho Writer users, Most businesses rely on multiple tools, such as a word processor, form builder, e-signature provider, and PDF editor, for their document workflows. Managing multiple subscriptions, switching between tools, and moving data across

• Deposit on invoice

  I'm trying to figure out how to customize an Estimate to include a Deposit/Retainer Invoice line within the Estimate. I tried creating my own custom field called "Deposit" where I manually inputted the deposit amount, which was nice. However, my employer

• Zoho NOTEBOOK: What are file size restrictions?

  I understand that Zoho NOTEBOOK is a free product, and what it offers is great. But I'm wondering what the file size restrictions are. When I record an audio note in Zoho Notebook, what is the maximum length of recording time/audio file size? When I wish to upload MP4 video, what is the maximum video size I can upload per Zoho Notebook restriction? Moreover, does Zoho Notebook use its own storage structure, or can I upgrade my storage for Zoho Notebook to add larger file attachments, videos and audio

• Concern Regarding Stock Validation in Inventory Management

  Hi Zoho Team, We would like to highlight a concern regarding stock validation in the inventory system. As per standard inventory management practices, if the stock level is zero, the system should not allow users to create a shipment, packing slip, or

• Automation Series #2: SLA vs Supervisor Rule in Zoho Desk

  SLA vs Supervisor Rule: Keeping tickets on track in Zoho Desk This post is part of the "Desk Automation Series," Chapter 1. Through this series, we will help you choose the right automation type in Zoho Desk by comparing commonly confused automations

• Zoho Recruit - Email Relay

  Good day, Has anyone succeeded in setting up an email relay for Office 365? If I add the details from https://support.microsoft.com/en-us/office/pop-imap-and-smtp-settings-8361e398-8af4-4e97-b147-6c6c4ac95353, I get the connection error. Regards, Eka

• Better use of contacts

  Zoho inventory has the ability to add multiple contacts to customers. However Zoho inventory doesn't currently provide a way to link a contact to objects like sales orders. This means that while you can tell what company has placed a sales order you can't

• Notebook AI limits

  Hi folks, Working with the AI transcription tools in Notebook, on the Mac App, which I find quite handy, but the one thing I am struggling with is the inability to either edit or copy the results of the transcript: I can't click in any of the boxes, and

• Disappointment with Zoho Payments

  Dear Gowdhaman, I am writing to inform you that I am removing Zoho Payments from my website. I cannot continue to disappoint my customers due to the lack of UPI support, as has been the case with my experience so far. Please note that the 0.5% transaction

• Next Page