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, 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 OAuth under Default Connection.

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

• Zoho One - White Label

  Releasing a white-label feature for Zoho One, or any software or service, can offer several advantages and benefits for both the company providing the software (Zoho in this case) and its users. Here are some key reasons for releasing a white-label feature

• Are this Features included in the Road Map

  1. Sync between description/short description in Zoho Books/Inventory and Zoho Commerce: I am unsure how it works now. I belive the description is not pulled. 2. Pick Up: This feature is great. It is added on Zoho Commerce but not on Books/Inventory which

• Reconciliation - Show Transactions After End Date

  I did a quick search, and I've only seen this brought up indirectly. In the reconciliation interface, transactions dated up to a week after the end date should be available for being reconciled. The use case is pretty simple... many times, transactions

• Auto populate email field in zoho form

  Hi,  Is there a way the email field in zoho forms can be auto populated based on the name selected from a drop down list?

• Option to accept and pay for estimate from Public Estimate link?

  Is there any way that our customers can get the Estimate in their email, click on "View Estimate" and from the public link, click Accept and Pay? When they click that, in the background Zoho would create the invoice record in the so that the payment would

• Kaizen #125 Manipulating Multi-Select Lookup fields (MxN) using Zoho CRM APIs

  Hello everyone! Welcome back to another week of Kaizen. In last week's post in the Kaizen series, we discussed how subforms work in Zoho CRM and how to manipulate subform data using Zoho CRM APIs. In this post, we will discuss how to manipulate a multi-select

• Easily track referrals with Zoho Forms

  Referral tracking can be a powerful way for businesses to understand where their leads are coming from. With Zoho Forms, tracking the referral sources of your leads is an easy and straightforward process. Here are some tips to help you make the most of

• Add an email to an existing ticket is not working

  I noticed that in Zoho Desk the funcionality to add an email to an existing ticket is not working using the syntax [##12345##], has the method changed? In red is the syntax we use to add email to an existing ticket As you can see, he did not add the email

• New CRM to Campaigns Sync Doesn't Continue Making Updates

  Changes made in CRM are not appearing in mapped fields in matching Campaign records after migrating to the new sync process. The only way we've found to get records to update is to call into Support and point out the problem. After convincing Support

• Zoho Integration with UPS

  I have 2 questions: Firstly, is there a way to notify UPS that we have a package to collect once we have done the shipping label? Secondly, how do I get the tracking number and shipment method onto the Invoice and Package Slip for the customer? Than

• Cannot log in to IMAP account as of last night

  Hey I've been using MFA with an authenticator for a while and have had to use application passwords for Outlook and Edison Mail on my Android devices. Last night the app passwords started to be rejected on my Android devices so I created new ones for

• Low Stock View

  We use the Low Stock view frequently as a guide to inform us when to reorder items, but the view is misleading because it does not take into account Purchase Orders that have already been raised. Unless you are aware and check item by item, this can lead

• Improve History Feature in Zoho Inventory

  At present there is a "history" tab on Zoho Inventory Items, however this only shows a date and time stamp along with the users name. It doesn't say what was changed. What is the value of this if you can't see what was changed? My Ideal is to include

• Show backordered items on packing slip

  We send out a lot of large orders, and often there are one or two things backordered. How can I fix the packing slips to show quantity ordered  & quantity packed There should also be the ability to "ship" 0 of an item so the receiver knows that things

• Document | Files

  The vendor "Partial matches" still not fixed here after years of putting up with having to select most vendors manually ! ( again, the banking "Transaction rules" would solve a lot of these issues ) Some unwanted, irrelevant pdf's also arrive. It would

• books+POS+ tap to pay+ stripe

  So in the UK we now have tap to pay with stripe. So we can use the stripe app as a POS terminal. Brilliant news. Can we hope that the Books App might add this feature ASAP. It would be great to have one system rather than using the not very good Square

• Canvas Form View - Client Script Page on load - Url params not working

  We have a custom module with a canvas page for form view. We have a button in Customers module to open this canvas page using invokeurl function. We send few parameters as in the URL as query parameters. https://crm.zoho.in/crm/orgxxxxxxxx/tab/CustomModule12/create/canvas/64333200000261xxxx?layoutId=643332000002605001&c=${Customers.Customer

• Sending Recruit SMS's to Zoho Cliq - Or tracking in the Messages module in Recruit?

  Is there any way to send SMS Gateway messages in Recruit to ZOho Cliq? We use 2-way SMS massages a lot in Zoho Recruit to speed up communication with Candidates. However the only way to keep track of received SMS's is by keeping a look out for the Email

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

  Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?

• Zohomail does not support additional fields in mailto links

  Hello, I set up Zohomail as default composer in Firefox according to manual here: https://www.zoho.com/mail/help/defaultcomposer.html#alink2 Later, I wanted to use this functionality to answer in a Linux mailing list thread using mailto link: mailto:xxxxx@kernel.org?In-Reply-To=%3C727o0521-q24p-s0qq-66n0-sn436rpqqr1p@example.com%3E&Cc=xxxxx%example.org&Subject=Re%3A%20%5BPATCH%20v2%28%29

• Is it possible to set a customer context variable in Zobot

  Hi, I want to use a context variable to route users down different paths in my Zobot chat flow. I know I can do this when the user enters data. But I want to know if I can use a variable that is 'hard coded' on the card, that the user is unaware of. Use

• Cannot change Blog Title

  There is nowhere to change the blog title. You can change the blog URL but that is making no difference to the text "Enter Your Post Title" am I missing something?

• Pending Sales Order Reports

  Pending sale order report is available for any single customer, Individual report is available after 3-4 clicks but consolidated list is needed to know the status each item. please help me.

• Kaizen #203 - Answering Your Questions | Handling API Limits and Error Responses

  Hi Everyone, Welcome back to yet another post in the Kaizen Series! We appreciate your keen participation in the 200th milestone celebration of the Kaizen series. We will continue to answer the queries we received through the feedback. When working with

• How to verify website ownership with google search console

  Hi, I am having a free .in domain provided by Zoho I have created a website on it now I want to verify my ownership to google webmaster. Can you please help me how to do that.

• Kaizen #89 - Color Coding using Client Script

  Hello everyone! Welcome back to another exciting Kaizen post. Today let us see how you can apply color codes to the List and Detail Pages of Zoho CRM using Client Script. Need for color code in Zoho CRM When you mark things with different colors as a

• "SPF record exceed the allowed limit of 10"

  Hi, I was wondering if there were a "universal Zoho SPF record" that would allow all my configured Zoho services that email things to meet this limitation ? or do I have to have an entry for mail, com, billing, etc?

• Zoho Mail android app update: Block & reject future emails, Report phishing, Spam alerts, Suspicious URL detection

  Hello everyone! In the most recent Zoho Mail Android app update, we have brought in support for the following features: Block & reject future emails Report Phishing Spam alerts in the mail details screen. Suspicious URL detection. Block & reject future

• What is Resolution Time in Business Hours

  HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

• Animated GIF Images in Chat

  I know this seems to be a small feature request but in a recent Cliq update Zoho disabled autoplay for animated GIFs posted in Cliq conversations. We think this was not a good change. In our organization, animated GIFs in a chat play a role in expressing

• I can't seem to login in to Mail Apps of MacOS /IOS

  Hi, i'm having trouble in signing in to mail apps from IOS. It's always come back to wrong passwords. But i already changed my password like 3 times. But still it says wrong credentials

• Profile Image Showing Incorrectly in Zoho Mail

  Hi everyone, I’m facing a serious issue with Zoho Mail. The profile image showing for my email address is incorrect — it’s not my image. When I send an email to my Gmail account, it displays someone else’s image. This looks very suspicious and can make

• I need access to my old email

  I need access to my old email bromzeman@zoho.com to verify it for forwarding. I can’t access the inbox to get the confirmation code. Please assist with recovery or forwarding. as you might already know, they made alot of the email addresses to have that

• Set Defaults for Email Groups

  Is there a way to set defaults for all of the groups that I establish as a moderator? For example, I want every group I establish to have the following settings: 1. Moderator is <user> 2. User is <user>, <user> 3. Notifications for new group turned

• LOGS FOR RECEIVED MAIL ( READ DATE & TIME)

  In Zoho mail we can extract the read logs of received mails so that we can see when we have read the mail and at what time & we have read it.

• Domain verification probem

  Hello, i use a domain from Namecheap with hosting from Cinfu when i try to verify my domain on zoho i get "TXT Verification failure" i even tried the HTML verification and the code appears but also giving me the verification failure error.

• Switching to Cloudflare email routing from Zoho Mail

  Hello, I'm currently working on migrating from Zoho Mail to Cloudflare's email routing solution. This requires changing MX and TXT records for our custom domain - when we do this, will our users still be able to log into their accounts and access an archived

• Un Subscription Button

  How can i Add the Un Subscription Button in Zoho mail

• Documents unable view and need to downlad

  I can't view .doc files in Zoho mail unless I download them, but I can view PDF files without downloading.

• we encountered a problem while sending your email. please try again later.

• Next Page