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

• Search in module lists has detiorated

  Every module has a problem with the search function :-/

• YouTube Live #1: AI-powered agreement management with Zia and Zoho Sign

  Hi there! We're excited to announce Zoho Sign’s first YouTube live series, where you can catch the latest updates and interact with our Zoho Sign experts, pose questions, and discover lesser-known features. We're starting off by riding the AI wave in

• Search in module lists has detiorated

  Every module has a problem with the search function :-/

• Sales Receipts Duplicating when I run reports why and how do we rectify this and any other report if this happens

  find attached extract of my report

• Add Zoho Forms to Zoho CRM Plus bundle

  Great Zoho apps like CRM and Desk have very limited form builders when it comes to form and field rules, design, integration and deployment options. Many of my clients who use Zoho CRM Plus often hit limitations with the built in forms in CRM or Desk and are then disappointed to hear that they have to additionally pay for Zoho Forms to get all these great forms functionalities. Please consider adding Zoho Forms in the Zoho CRM Plus bundle. Best regards, Mladen Svraka Zoho Certified Consultant and

• Bigin: filter Contacts by Company fields

  Hello, I was wondering if there's a way to filter the contacts based on a field belonging to their company. I.e.: - filter contacts by Company Annual Revenue field - filter contacts by Company Employee No. field In case this is not possibile, what workaround

• Has Zoho changed the way it searches Items?

  Right now all of our searches have broken and we can no longer search using the SKU or alias. It was fine last night and we came in this morning to broken.....this is impacting our operations now.

• Refunds do not export from Shopify, Amazon and Esty to Zoho. And then do not go from Zoho inventory to Quickbooks.

  I have a huge hole in my accounts from refunds and the lack of synchronisation between shopify , Amazon and Etsy to Zoho ( i.e when I process a refund on shopify/ Amazon or Etsy it does not come through to Zoho) and then if I process a manual credit note/

• CRM->INVENTORY, sync products as composite items

  We have a product team working in the CRM, as it’s more convenient than using Books or Inventory—especially with features like Blueprints being available. Once a product reaches a certain stage, it needs to become visible in Inventory. To achieve this,

• Zoho Calendar not working since a few days

  Hey there, first off a minor thing, since I just tried to enable the Calendar after reading this in another topic (there was no setting for this though) : For some reason my current session is showing me based in New York - I'm in Germany, not using a

• Monthly timesheet, consolidation of time by project

  I have time logs for various jobs for project. Is it possible to consolidate the time spent for each job, when I am generating a timesheet for a month? I am getting the entries of jobs done on each day when I generate a timesheet for a month For example

• Building a Strong Online Identity with G-Tech Solutions

  In today’s fast-moving world, having a strong online identity is essential for every business. https://gtechsol.com.au helps businesses establish a digital presence that reflects their vision and values. By focusing on innovation and quality, they create

• Sending emails from an outlook account

  Hi, I need to know if it's possible to send automatic emails from an Outlook account configured in Zoho CRM and, if so, how I can accomplish that. To give you some context, I set up a domain and created a function that generates PDF files to be sent later

• Struggling with stock management in Zoho CRM – is Zoho Inventory the solution?

  My biggest pain point today with Zoho is inventory management. I run a retail business and reliable stock management is absolutely critical. Obviously, I need this inventory to be visible inside the CRM. At first, I tried handling it through custom modules

• Automating CRM backup storage?

  Hi there, We've recently set up automatic backups for our Zoho CRM account. We were hoping that the backup functionality would not require any manual work on our end, but it seems that we are always required to download the backups ourselves, store them,

• Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

  Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration

• can't login Kiosk URGENT

  already try, can't login pls help to support. thanks.

• 【Zoho CRM】CRM for Everyoneに関するアップデート：関連データ機能

  ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 今回は「Zoho CRM アップデート情報」の中から、CRM for Everyoneの新機能「関連データ機能」をご紹介します。 関連データ機能は、あるタブのデータを別のタブに柔軟に関連付け、異なるタブで管理されている情報を1か所にまとめて表示できます。 たとえば、組織タブとチームタブのデータを関連付けることで、必要な情報に効率よくアクセスでき、顧客理解を深めながら他チームとの連携もスムーズに行えます。 目次 1. 関連データの設定方法

• Zoho Books

  How do I manually insert opening balance?

• Profit / margins on Sales orders / Invoices / Estimates

  When we select an SKU or item name in any of these documents, much info such as invoice.line_items.rate is pulled from the item & filled into the document being worked on. If we had another lineItem DB field (hidden) auto filled at the same time: invoice.line_items.purchase_rate

• Inventory to Xero Invocie Sync Issues

  Has anyone had an issue with Invoices not syncing to Xero. It seems to be an issue when there is VAT on a shipping cost, but I cannot be 100% as the error is vague: "Unable to export Invoice 'INV-000053' as the account mapped with some items does not

• How to activate RFQ? What if a price list has ladder price for items?

  Where can I find the option to activate request for quotation? How does it work? If the item has ladder price, does it gets calculated depending on how many items are in the cart?

• Mailk got blocked / Inquiry About Email Sending Limits and Upgrade Options

  Dear Zoho Support Team, My name is Kamr Elsayed I created this account to use for applying for vocational training in Germany. As part of this process, I send multiple emails to different companies. However, after sending only 8 emails today, I received

• Can't join canal Developers Zoho User

  Hello, I received an invitation to join this channel, but I get an error when I try to join it, and I get the same error when I go to the Zoho Cliq interface > Search for a channel. Is this because I don't have a license linked to this email address?

• Desk Email reply - set default font / use custom font

  Hello, in our e-mails, which we send to our customers, a certain font must be used (Corporate Design): Segoe UI https://en.wikipedia.org/wiki/Segoe#Segoe_UI How can this be included? How can this be set as the default font to ensure that this font is

• PDF Templates - Checkbox Borders

  Is there a way to remove the border of a radio/checkbox on a PDF? I'd like to use the function of checkbox but if there's no easy way to remove the border (the PDF form already has a rectangle so it gets cluttered), then I'm forced to create a single

• Zoho CRM's custom views are now deployable from sandboxes

  This feature is now available for users in the AU, JP, and CN DCs. New update: This feature is now available for users in CA and SA DCs. Hello everyone, We're excited to announce that you can now deploy custom views from sandboxes to your production environment

• Generate a link for Zoho Sign we can copy and use in a separate email

  Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to

• UK MTD reports concerning turnover and cerash accounting

  Hi I am a sole trader, and I have just started with Zoho Books in order to comply with the new HMRC requirements. I use 'cash basis' - which I understand to mean that income is when the cash comes in (not the invoice date) and expenses are when they are

• Settings Icon No Longer in ZOHO Desk?

  In ZOHO desk, there has been a gear icon for settings. as of yesterday, it is no longer there. I showed up briefly this morning but is gone again. Anybody else experiecing this?

• Introducing the all-new email parser!

  Greetings, We are pleased to introduce to you, a brand-new, upgraded version of the Zoho CRM Email Parser, which is packed with fresh features and has been completely redesigned to meet latest customers needs and their business requirements. On that note,

• Tip #43 - Track, Review, and Analyze Your Assist Sessions with Reports-'Insider Insights'

  Did you know you can generate detailed reports for both remote support sessions and unattended access sessions in Zoho Assist? This makes it easy to monitor technician activity, measure efficiency, and review customer interactions. Let us now take a closer

• Function #20: Custom calculation in item table of invoices

  When you create an invoice in Zoho Books, the 'Amount' of a line item is typically calculated as the product of the "Quantity" and the "Rate" of the item. For instance, if an item has a sales rate of $50 and a quantity of 5 is sold, then the amount would

• Can we generate APK and IOS app?

  Dears, I want to know the availability to develop the app on zoho and after that .. generate the APK or IOS app  and after that I added them to play store or IOS store.. Is it possible to do this .. I want not to use zoho app or let my customers use it. thanks 

• CBSA - GST CHARGES on imports

  Hi there, We have a questions about landed cost categorization. We received a shipment from overseas. CBSA invoiced us for the GST on the items. Now we entered the CBSA-GST as a separate bill and attached it as landed cost to the main invoice based on

• Simplified Call Logging

  Our organization would like to start logging calls in our CRM; however, with 13 fields that can't be removed, our team is finding it extremely cumbersome. For our use case, we only need to record that a call happened theirfor would only need the following

• Sub form doesn't as formula field

  Is it possible to get formula field in sub form in futures?

• Week date range in pivot table

  Hello, I need to create a report that breakouts the data by week.  I am using the pivot table report, and breaking out the date by week, however the date is displayed as 'Week 1 2014' format.  Is there anyway to get the actual dates in there? ex. 1/6/2014-1/12/2014 Thanks,

• How do I get Status History data of my Projects?

  I want to build a table in Zoho Analytics that Groups by Date, when Projects entered a certain status. I cannot find Status History or any such useful data available in the Setup of my Data Source sync. Please advise how I can achieve this?

• Is it possible to hide fields in a Subform?

  Since layout rules cannot be used with Subforms, is there another way, or is it even possible, to hide fields in a subform based on a picklist fields within said subform? For example, if the Service Provided is Internet, then I do not want to see the

• Next Page