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

• Checking if Creator has Change History

  Like zForms - whenever an entry was updated there's an option to attached change history to email notif. Trigger -> Successful form submission

• how to use validation rules in subform

  Is it possible to use validation rules for subforms? I tried the following code: entityMap = crmAPIRequest.toMap().get("record"); sum = 0; direct_billing = entityMap.get("direct_billing_details"); response = Map(); for each i in direct_billing { if(i.get("type")

• Adding contact role to a specific deal js sdk malfunctioning

  i was trying to add the contact role to a specific deal contact but repeatedly i am getting this error: { "code": "SUCCESS", "details": { "statusMessage": { "code": "INVALID_DATA", "details": { "expected_data_type": "jsonobject" }, "message": "body",

• Q3 Updates from Bigin!

  Hey Biginners, Hope you’re doing great! As we approach the end of 2025, we truly hope Bigin has been a part of helping you build your dream business this year! We've been busy working behind the scenes to bring you features that make running your business

• Client Script | Update - Introducing Subform Events and Actions

  Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce

• {"errors":[{"id":"500","title":"Servlet execution threw an exception"}]}

  Here's the call to move a file to trash. The resource_id is accurate and the file is present. header = Map(); header.put("Accept","application/vnd.api+json"); data = Map(); data_param1 = Map(); att_param1 = Map(); att_param1.put("status",51); data_param1.put("attributes",att_param1);

• Converting Sales Order to Invoice via API; Problem with decimal places tax

  We are having problems converting a Sales Order to an Invoice via API Call. The cause of the issue is, that the Tax value in a Sales Order is sometimes calculated with up to 16 decimal places (e.g. 0.8730000000000001). The max decimal places allowed in

• Zoho Canvas - Custom templates for related lists

  Hi, I see that the example pages load always one of our related lists in a custom template, but I dont know how to work with that:  1) How can i make my own custom templates for related lists?  2) Where and how can i check out existing custom templates?

• Kaizen #147 - Frequently Asked Questions on Zoho CRM Widgets

  Heya! It's Kaizen time again, folks! This week, we aim to address common queries about Zoho CRM Widgets through frequently asked questions from our developer forum. Take a quick glance at these FAQs and learn from your peers' inquiries. 1. Where can I

• open word file in zoho writer desktop version

  "How can I open a Microsoft Word (.doc or .docx) file in Zoho Writer if I only have the file saved on my computer and Zoho Writer doesn't appear as an option when I try 'Open with'? Is there a way to directly open the .doc file in Zoho Writer?"

• Zoho PDF editor has a lot of issues.

  Zoho PDF editor needs a lot of work. It hangs and glitches a lot. Deletes annotations and clearings randomly.

• Syncing contacts on Android

  I'm using the Zoho mail app on Android and although I can see my contacts from within the app, they're not synced to my native contact list and so I can't access them from within the native dialer. Is there any way that I can sync my contacts into my native address book? Regards, Martin

• Zohom mail

  Plz resolve the problem . I hope u understand .

• Zoho sheet desktop version

  Hi Zoho team Where can I access desktop version of zoho sheets? It is important as web version is slow and requires one to be online all the time to do even basic work. If it is available, please guide me to the same.

• ZOHO SHEETS

  Where can I access desktop version of zoho sheets? It is important to do basic work If it is available, please guide me to the same

• Using Zoho Flow to create sales orders from won deal in Zoho CRM

  Hi there, We are using Zoho Flow to create sales orders automatically when a deal is won in Zoho CRM. However, the sales order requires "Product Details" to be passed in "jsonobject", and is resulting in this error: Zoho CRM says "Invalid input for invalid

• Is Zoho Sheet available for Linux ?

  Is Zoho Sheet available for Linux ?

• Bharat

  a

• how to disable staff selection Zoho Booking integrated to SalesIQ?

  currently there is only one Consultant in my Zoho Bookings like this I integrate Zoho Bookings into Zoho SalesIQ to create a chatbot. Unfortunately, even though I only have one consultant for a consultation, the user have to pick the consultant. It will

• Zoho Bookings No Sync with Outlook

  Zoho Bookings appointments are showing on my Outlook Calendar but Outlook events are not showing on Zoho Bookings. How do I fix this?

• End Date in Zoho Bookings

  When I give my appointments a 30 minutes time I would expect the software not to even show the End Time.  But it actually makes the user pick an End Time.  Did I just miss a setting?  

• Custom confirmation message

  How can I change the message that users see after they submit the booking form? I have to confirm some details before their appointment is officially "confirmed", so I want to change it where it doesn't say their appointment is "confirmed" but rather

• 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

• Deluge sendmail in Zoho Desk schedule can't send email from a verified email address

  I am trying to add a scheduled action with ZDesk using a Deluge function that sends a weekly email to specific ticket client contacts I've already verified the email address for use in ZDesk, but sendmail won't allow it in its "from:" clause. I've attached

• unblock e-mail

  please unblock my e-mails info@meatnews.gr and myrtokaterini@meatnews.gr

• Changing Corporate Structure - How Best to Adapt Current and Future Zoho Instances

  My current company is Company A LLC with a dba ("doing business as" - essentially an alias) Product Name B. Basically, Company A is the legal entity and Product Name B is what customers see, but it's all one business right now. We currently have a Zoho

• How to Install Zoho Workdrive Desktop Sync for Ubuntu?

  Hi. I am newbie to Linux / Ubuntu. I downloaded a tar.gz file from Workdrive for installing the Workdrive Desktop Sync tool. Can someone give me step by step guide on how to install this on Ubuntu? I am using Ubuntu 19.04. Regards Senthil

• How to upload own video?

  How can you upload your own video on your zoho website? I do not want to use another host, but i want to insert my own files. how can i do this?

• Support new line in CRM Multiline text field display in Zoho Deluge

  Hi brainstrust, We have a Zoho CRM field which is a Muti Line (Small) field. It has data in it that has a carriage return after each line: When I pull that data in via Deluge, it displays as: I'm hoping a way I can change it from: Freehand : ENABLED Chenille

• Announcing new features in Trident for Windows (v.1.32.5.0)

  Hello Community! Trident for Windows just got better! This update includes new features designed to improve and simplify email and calendar management—and it includes a feature you’ve been waiting for. Let’s dive into what’s new! Save emails in EML or

• How to render either thumbnail_url or preview_url or preview_data_url

  I get 401 Unauthorised when using these urls in the <img> tag src attribute. Guide me on how to use them!

• Zoho CRM Calendar | Custom Buttons

  I'm working with my sales team to make our scheduling process easier for our team. We primary rely on Zoho CRM calendar to organize our events for our sales team. I was wondering if there is a way to add custom button in the Calendar view on events/meeting

• Create Lead Button in Zoho CRM Dashboard

  Right now to create Leads in the CRM our team is going into the Lead module, selecting the "Create Lead" button, then building out the lead. Is there anyway to add the "Create Lead" button or some sort of short cut to the Zoho CRM Dashboard to cut out

• Searching customer field

  Hello, When entering a receipt, we select customer information. The customer information is synced with Zoho CRM. However, we can't find the customer information because it searches for words that begin with the entered value. It needs to search for words

• Introducing Version-3 APIs - Explore New APIs & Enhancements

  Happy to announce the release of Version 3 (V3) APIs with an easy to use interface, new APIs, and more examples to help you understand and access the APIs better. V3 APIs can be accessed through our new link, where you can explore our complete documentation,

• Outgoing blocked: Unusual activity detected.

  Hello i can't send email from g.morris@adm-part.com mail, can you please help me.

• Zoho CRM Tracking Google Enhanced Conversions

  Can anyone @Zoho, consultants, or users help me understand if Zoho CRM is going to support Google's Enhanced Conversions? I included some information from Google below about it. We use Google Adwords for our pay per click advertising for lead generation,

• Billing Management: #5 Usage Billing

  After understanding the nuances of Advance Billing and Retainers, we will explore one of the booming billing models. Long ago, villagers drew water from a shared well in a small village. The well was a lifeline for the entire community. Ravi, the well

• Function #10: Update item prices automatically based on the last transaction created

  In businesses, item prices are not always fixed and can fluctuate due to various factors. If you find yourself manually adjusting the item rates every time they change, we have the ideal time-saving solution for you. In today's post, we bring you custom

• Inventory Adjustments

  Hi, How to transfer the material from one head to another ? Like materials purchased for manufacturing the laptop need to transfer from consumption inventory (Quantity of raw materials reduced) to destination inventory ( Quantity of Laptop increased)

• Next Page