Automation#21: Track Ticket Transfers Across Departments

Hello Everyone!

With Halloween just around the corner, we'd like to let you know the Zoho Desk team is always there to sweep away your customer service troubles!

This week, we’re excited to introduce a custom function that tracks tickets moved between departments.

While Zoho Desk has simplified customer service, keeping your support team stress-free and your customers happy often requires thoughtful adjustments. Zylker Techfix found a great solution with this feature. They handle services for different gadget types under specific departments, but sometimes tickets accidentally end up in the wrong department. Agents moved them to the correct one, but needed a way to track these transfers. By using the Time Entry feature and a custom function, they generated reports of all moved tickets effortlessly.

Here’s the custom function that utilizes the Time Entry feature to track tickets transferred between departments.

Prerequisites

1. Create Custom Fields

To track tickets moved from one Department (call it Dep A) to the other Department (call it Dep B) or vice versa, 

1.1 Go to Setup (S) >> Customization >> Layouts and Fields. Select Time Entry under Layouts and the Department (let's say Dep B) to which you would like to move the ticket. 

1.2 Create three custom single-line fields in the Time Entry layout of the respective department (Dep B). Click on the layout, 

1.2.1 Add a single line field with a label From department.

1.2.2 Add another single line field with a label To Department.

1.2.3  Add the third single line field with the label Agent Name.

1.3 Note the API names for the the single line fields 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, and you will find the API Name under the Edit Field. Refer to Create Custom Fields. 

If you would like move the ticket from Dep B to Dep A, create the similar fields in the time entry layout for Dep A.

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 Services.

      2.4 Set the connection name as ticket_time_entry_add.

      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(S), choose Workflows under Automation. 

2. In Workflow Rules, select the Department (Dep B) to which you want to move the tickets. 

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

In the Basic Information section,

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

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

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

7. Click Next.

In the Execute on section, follow these steps:

8. Select Create.  

9. Click Next.

10. Leave the Criteria section blank and click Next. 

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

12. Under Basic Information, enter a Name and Description for the custom function.         

13. Under Argument Mapping, give a desired Method Name. Map the argument mapping as below: 

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

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

1. //----------- User Input -------------
2. deskURL = "https://desk.zoho.com";
3. fromDepartmentFieldAPIName = "cf_from_department";
4. toDepartmentFieldAPIName = "cf_to_department";
5. agentAPIName = "cf_agent_name";
6. //----------- Configuration ------------------
7. logs = Collection();
8. timeEntryParam = Map();
9. cf = Map();
10. historyParam = Map();
11. historyParam.put("from",0);
12. historyParam.put("limit",1);
13. historyParam.put("fieldName","departmentId");
14. ticketHistory = invokeurl
15. [
16. url :deskURL + "/api/v1/tickets/" + ticketId + "/History"
17. type :GET
18. parameters:historyParam
19. connection:"ticket_time_entry_add"
20. ];
21. logs.insert("ticketHistory":ticketHistory);
22. if(ticketHistory != null && ticketHistory.get("data") != null)
23. {
24. historyDetails = ticketHistory.get("data").get("0");
25. logs.insert("historyDetails":historyDetails);
26. if(historyDetails.get("eventName") == "TicketUpdated" && historyDetails.get("eventInfo").get(0).get("propertyName") == "Department")
27. {
28.   departmentDetailsChanges = historyDetails.get("eventInfo").get("0").get("propertyValue");
29.   previousDepartment = departmentDetailsChanges.get("previousValue").get("name");
30.   currentDepartment = departmentDetailsChanges.get("updatedValue").get("name");
31.   agent = historyDetails.get("actor").get("name");
32.   departmentChangedTime = historyDetails.get("eventTime");
33.   cf.put(fromDepartmentFieldAPIName,previousDepartment);
34.   cf.put(toDepartmentFieldAPIName,currentDepartment);
35.   cf.put(agentAPIName,agent);
36.   timeEntryParam.put("executedTime",departmentChangedTime);
37.   timeEntryParam.put("cf",cf);
38.   logs.insert("timeEntryParam":timeEntryParam);
39.   createTimeEntry = invokeurl
40.   [
41.   url :deskURL + "/api/v1/tickets/" + ticketId + "/timeEntry"
42.   type :POST
43.   parameters:timeEntryParam.toString()
44.   connection:"ticket_time_entry_add"
45.   ];
46.   logs.insert("createTimeEntry":createTimeEntry);
47. }
48. }
49. info logs;

NOTE

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

b. In Line 3, add the API name of the From Department created in the Time Entry Layout.

c. In Line 4, add the API name of the To Department created in the Time Entry Layout.

d. In Line 5, add the API name of the Agent Name created in the Time Entry Layout.

15. Click Save to save the custom function.

16. Click Save again to save the workflow.

If you would like to move the ticket from Dep B to Dep A, create  the workflow rule in Dep A as well. 

Creating Ticket Tracking Reports

To track the ticket that moved from one department, you can generate Reports under Analytics. 

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

This custom function will help you keep an eye on your ticket movements, ensuring that none of your important tickets go missing!

Wishing you a delightful Halloween filled with joy and treats, along with a wonderful fall season! 🎃🍂

Until next week,

Warm regards,

Lydia Kiruba | Zoho Desk 

• Topic Participants

• Lydia | Zoho Desk

  

• Mohd Hayzee

• Ajith(AJ) | Zoho Desk

  

• Shivani | Zoho Desk

  

• 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

• Weekly Tips: Manage External Images in Zoho Mail

  When you receive emails every day, whether from clients, newsletters, or services, many of them contain external images that automatically load when you open the message. While this can make emails look more engaging, it can also impact your privacy and

• Implementing a Self-Invoicing/Vendor Portal in Zoho Creator

  Hello Zoho Community / Creator Experts, We would like to build a Self-Invoicing Portal (Vendor Portal) in Zoho Creator for our external contractors. Our goal is to allow approved contractors to log in, submit their invoice details (hours worked, project

• Function #32: Schedule low stock notifications on a timely basis to specific users of the organization

  Hello everyone and welcome back to our series! For a business that heavily relies on inventory, monitoring the stock levels and getting timely notifications of low stock items will ensure a smooth sail. Zoho Books allows you to always keep a check on

• SINCH HUB MESSAGEMEDIA with ZOHO DESK

  1) what I need from MessageMedia, 2) what I want to confirm on the Zoho Desk Dev Forum. MessageMedia – needs and requirements Goal: Send SMS from a Zoho Desk widget for EU users. Auth: HTTP Basic (API Key + Secret). Keys must not live in the browser.

• Function #46: Auto-Calculate Sales Margin on a Quote

  Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it's

• Invalid URL error when embedded sending url into iframe for my website when using in another region

  Hi team, My site is currently working on integrating your signature feature as part of the system functionality, it's working great but recently there's been a problem like this: After successfully creating the document, i will embed a sending url into

• New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!

  Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementally

• Kaizen #59 - Creating alerts and custom messages using Client Script

  Hello everyone! We are happy to resume our Zoho CRM Developer Community series - The Kaizen series! Welcome back to the new start of Kaizen! This post is about Client Script and its simple use cases involving ZDK Client functions. What is Client Script?

• Universal search

  Hi, it would be useful if the search bar was universal-so if you entered a term, it would bring up results from contacts, candidates, clients etc all at the same time (but broken down under the relevant headings)

• Attachment reminder?

  My team and I often need to attach files to our messages, e.g. an explanatory screenshot or a shipping label. More often that I want to admit I mention the attachment but forget to actually attach it. Some email clients have a check-for-missing-attachments

• ZIA in Zoho Cliq

  Is It possible to use the ZIA feature from Zoho Analytics in the Zoho Cliq?

• 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,

• Multiple upload field CRM

  I desperately need the functionality to add more than one upload field to web to contacts form. How can I do this?

• Critical Need for Global Search in Zoho FSM

  Hello Zoho FSM Team, We are currently in the process of deciding whether to fully transition to Zoho FSM for managing our field service operations. At present, our team actively uses Zoho Desk (with over 50 users) and Service Fusion, which we are considering

• Collections Management: # 1 Payment Collection is All About Convenience

  "Sir, can you come tomorrow? My manager wasn't available for the cheque sign-off", the customer said, avoiding eye contact. Ravi forced a polite smile, but inside, he felt a sense of defeat. He had already visited the customer's office twice in the last

• Audio/video quality issues with Zoho Meeting – Any roadmap for improvement?

  Hi Zoho Team, We’ve been using Zoho Meeting for both internal and external meetings, and unfortunately, the experience has been consistently poor. The video and audio quality are so unreliable that it often renders meetings ineffective—especially with

• Cash based businesses cannot use the new fixed asset module

  Hello all, If your bookkeeping is reporting in cash, you cannot use the new fixed acid module, as it does all the depreciation bookings accrual and not cash. This is definitive and you can't turn them into a cash booking. They will never appear in your

• Zoho Learn & Zoho Connect

  Hi, Is there a way to sync the knowledge base we have in Zoho Learn with the manuals section is Zoho Connect? Thanks,

• Apply Payment Received Amount Zoho Books Invoice

  Hello team here is the sample code How can apply the payment received record over a unpaid zoho books invoice. //......................... paymentID = customer_payment.get("payment_id"); organizationID = organization.get("organization_id"); paymentmaplist

• [Live Webinar] New in Zoho WorkDrive: AI enhancements, Data Loss Prevention, Version Controls, and more

  Hello everyone, We're excited to bring you another round of powerful updates in Zoho WorkDrive! Join us on May 15 for an exclusive live webinar where we’ll unveil the latest features designed to enhance your team’s productivity, collaboration, and data

• Live webinar: Streamlining legal operations: Leveraging Zoho WorkDrive for law firm success

  Hello everyone, Managing legal documents across departments and jurisdictions can be complex, but it doesn’t have to be. Join us on March 6 for an exclusive webinar where we’ll show you how Zoho WorkDrive empowers legal teams to stay compliant, organized,

• Live Webinar: Optimizing back-office operations in the manufacturing industry to maximize profitability

  Hello everyone, We’re excited to invite you to our upcoming live webinar on February 6! Discover how Zoho WorkDrive can help manufacturing businesses optimize back-office operations, improve efficiency, and boost profitability. Our product experts will

• Live webinar: 2024 recap of Zoho WorkDrive

  Hello everyone, We’re excited to invite you to our year-end live webinar! This session will take you through the transformative features and updates we’ve introduced in Zoho WorkDrive this year, helping you streamline document management like never before.

• Live webinar: Explore WorkDrive's seamless integrations with key Zoho apps

  Hello everyone, We’re excited to invite you to our upcoming live webinar, where we'll delve into the seamless integration of WorkDrive with other key Zoho applications! This is a fantastic opportunity to enhance your productivity and streamline your workflows

• Live webinar: Getting the most out of WorkDrive in Zoho Workplace

  Hello everyone, We’re excited to invite you to our upcoming live webinar, where we’ll explore how to maximize your use of WorkDrive as part of the Zoho Workplace bundle. This is a fantastic opportunity to elevate your productivity and streamline your

• Live webinar: Mastering data migration, organization, and team collaboration

  Hello everyone, We’re excited to invite you to our upcoming live webinar! Discover how to seamlessly migrate your data, optimize file organization, and boost team collaboration using Zoho WorkDrive’s powerful features. This is a fantastic opportunity

• Join our live webinar: Explore the WorkDrive TrueSync application!

  Hello everyone, We are thrilled to invite you to a live webinar focused on mastering the WorkDrive TrueSync application. Discover how to seamlessly sync your content between the cloud and your computer, ensuring smooth and efficient file management. Our

• Envio de mails

  Hola! No puedo enviar mails pero si recibirlos. No se como solucionarlo! Mi dominio es chidobebes.com.ar

• ERROR CODE :554 - Your access to this mail system has been rejected due to poor reputation of a domain used in message transfer

  In my email configuration: The domain's MX Records are pointed to Zoho The domain's SPF Records have been pointed out successfully DKIM is enabled. DMARC Record is pointed for the domain. The domain name is digioorja.in. Still facing the issue of Error:

• This Operation has been restricted. Please contact support-as@zohocorp.com for further details

  l tried to verify my domain (casalimpaeperfumada.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details.

• SLOW EMAILS

  Is there an issue with the Zoho server? For two days now I've been having issues with very long buffering. Please advise. Thank you.

• POP3 authentication error - SOLVED

  Just in case others are as forgetful as me ... As Zoho has changed the POP server for personal and free organisational users, I needed to change the POP server on my email client. This failed persistently but eventually I remembered that I had chosen

• Add Zoho One Groups/Departments to Shared Mailbox Access

  Hi, I hope you're doing well. Currently, in Zoho Mail, I can manually add specific users or the entire organization to a shared mailbox. However, there is no option to add Zoho One groups or departments. Feature Request: We would like the ability to assign

• Allow Filters with Only Special Characters in Zoho Mail

  Hi Zoho Mail Team, I hope you're doing well. We have noticed that currently, Zoho Mail does not allow creating filter criteria using only special characters, such as = or #. However, there are scenarios where such a filter is necessary. For example: Filtering

• How to save email as PDF?

  I saw 2 previous threads about this. One is from 14 years ago. The other was closed as "answered" a year ago but the feature was never implemented: https://help.zoho.com/portal/en/community/topic/how-to-download-save-emails-as-pdf Is the "save as PDF"

• Flexible plans

  Hi, I have a Workplace Standard subscription. On Zoho's website, it mentions that with the annual plan it's possible to have multiple plans under the same organization—for example, Workplace Standard and Mail Lite. However, I can’t find a way to do this

• Weekly Tips : Teamwork made easy with Multiple Assignees

  Let's say you are working on a big project where different parts of a single task need attention from several people at the same time—like reviewing a proposal that requires input from sales, legal, and finance teams. Instead of sending separate reminders

• Cannot give public access to Html Snippet in Zoho Creator Page

  Hi, I created a form in Zoho Creator and published it. The permalink works but I want to override the css of the form. (style based URL parameters is not good enough) So I created a page and added an Html snippet. I can now override the css, which is

• Weekly Tips : Customize your Compose for a smoother workflow

  You are someone who sends a lot of emails, but half the sections in the composer just get in your way — like fields you never use or sections that clutter the space. You find yourself always hunting for the same few formatting tools, and the layout just

• Accounting on the Go Series-43:Enhancing Your Reporting Efficiency with Dashboard Filter State Retention

  Hello everyone! Welcome back to our series on Zoho Books mobile app features. Today, we will talk about a feature that yet again helps you focus on work that really matters-Dashboard Filter State Retention. Imagine you're working on your Zoho Books dashboard,

• Next Page