Automation#19:Auto-Close Tickets Upon Task Completion

Hello Everyone!

We’re excited to bring you another custom function this week. In this edition, we’ll show you how to automatically close tickets when all associated tasks are marked as completed.

Let’s see how ZylkaPure, a leading water filter company, benefits from this functionality. ZylkaPure specializes in installing and servicing water filters for homes and offices. When a customer books a service, a ticket is created, and the specific tasks required for the service are added to it. As service engineers carry out the necessary work, they update the status of each task. Once all tasks are marked as completed, the system automatically closes the ticket, ensuring a streamlined process and reducing manual follow-ups.

Implementing this custom function in your portal can automate ticket closure and simplify your workflow. Follow these steps to set up the automation in your system.

Prerequisites

1. Create a connection

      1.1 Go to Setup and choose Connections under Developer Space.
      1.2 Click Create Connection.
      1.3 Select Zoho Desk under Default Services.
      1.4 Give the connection name as closeticketbytask.
      1.5 Under Scope, choose the below scope values:

            Desk.activities.READ

            Desk.activities.tasks.READ

            Desk.tickets.UPDATE

      1.6 Click Create and Connect.
      1.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 Tasks 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 and select the field Status to execute this rule every time the task status is updated.  

8. Click Next.

 

In the Criteria section

9. Specify the criteria as Status is Completed, AND Completed Time is not empty.

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 taskId and from the Value drop-down list, select Task Id under Task Section.

 12.2 In the Argument Name field, type associatedTicketId, and from the Value drop-down list, select Ticket Id under Tasks Section.                                                    

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

1. // ----<<<< User Inputs >>>>----
2. // --- Replace ".com" with appropriate domain based on your DC
3. deskURL = "https://desk.zoho.in";
4. // --- Enter a status name to indicate the 'completed' status of a task ---
5. taskCompletedStatusName = "Completed";
6. taskCanceledStatusName = "Canceled";
7. // --- Enter the name of the custom status to be updated in the Ticket after the completion of all the associated Tasks ---
8. statusNameToUpdateInTicket = "Closed";
9. // ----<<<< Initial Configs >>>>----
10. logs = Map();
11. logs.insert("taskId":taskId,"associatedTicketId":associatedTicketId);
12. tasksListToProcess = List();
13. shallUpdateTicketStatus = false;
14. //---------------------------
15. try
16. {
17.  // ---- Check to find the Task and Ticket association ----
18. isTicketAssociatedWithThisTask = !isNull(associatedTicketId) && !isEmpty(associatedTicketId);
19.  if(isTicketAssociatedWithThisTask)
20.  {
21.   // --- Get the list of all tasks associated with this ticket ---
22.   getTasksListApiParam = Map();
23. getTasksListApiParam.insert("from":0,"limit":100,"isSpam":false,"sortBy":"createdTime");
24.   logs.insert("getTasksListApiParam":getTasksListApiParam);
25.   getTasksListApiResponse = invokeurl
26.   [
27.   url :deskURL + "/api/v1/tickets/" + associatedTicketId + "/tasks"
28.   type :GET
29.   parameters:getTasksListApiParam
30.   headers:{"Content-Type":"application/json"}
31.   connection:"closeticketbytask"
32.   ];
33.   logs.insert("getTasksListApiResponse":getTasksListApiResponse);
34.   isValidToProcess_getTasksListApiResponse = !isNull(getTasksListApiResponse) && !isEmpty(getTasksListApiResponse) && getTasksListApiResponse.size() > 0 && getTasksListApiResponse.containsKey("data");
35. logs.insert("isValidToProcess_getTasksListApiResponse":isValidToProcess_getTasksListApiResponse);
36.   if(isValidToProcess_getTasksListApiResponse)
37.   {
38.   tasksListToProcess = getTasksListApiResponse.get("data");
39.   }
40.  }
41. logs.insert("isTicketAssociatedWithThisTask":isTicketAssociatedWithThisTask,"tasksListToProcess_size":tasksListToProcess.size());
42.  if(tasksListToProcess.size() > 0)
43.  {
44.   // --- Check to ensure that all tasks are completed or not ---
45.   for each  currentTaskDetail in tasksListToProcess
46.   {
47.   currentTaskStatusName = currentTaskDetail.get("status");
48.   currentTaskCompletedTime = currentTaskDetail.get("completedTime");
49. if((currentTaskStatusName == taskCompletedStatusName || currentTaskStatusName == taskCanceledStatusName) && !isNull(currentTaskCompletedTime))
50.   {
51.   shallUpdateTicketStatus = true;
52.   }
53.   else
54.   {
55.   logs.insert("notCompletedTaskId":currentTaskDetail.get("id"));
56.   shallUpdateTicketStatus = false;
57.   break;
58.   }
59.   }
60.  }
61.  logs.insert("shallUpdateTicketStatus":shallUpdateTicketStatus);
62.  if(shallUpdateTicketStatus)
63.  {
64.   // --- Update status field to the associated ticket ---
65.   ticketUpdateApiParam = Map();
66.   ticketUpdateApiParam.insert("status":statusNameToUpdateInTicket);
67.   logs.insert("ticketUpdateApiParam":ticketUpdateApiParam);
68.   ticketUpdateApiResponse = invokeurl
69.   [
70.   url :deskURL + "/api/v1/tickets/" + associatedTicketId
71.   type :PATCH
72.   parameters:ticketUpdateApiParam.toString()
73.   headers:{"Content-Type":"application/json"}
74.   connection:"closeticketbytask"
75.   ];
76.   logs.insert("ticketUpdateApiResponse":ticketUpdateApiResponse);
77.  }
78. }
79. catch (errorInfo)
80. {
81.  logs.insert("errorInfo":errorInfo);
82. }
83. info "logs: \n" + logs;
84. if(logs.containKey("errorInfo"))
85. {
86.  ths "Error happen in the CF execution";
87. }

NOTE

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

In case you have a custom name for the task status or ticket status, you can make suitable changes in the following lines:

b. Line 7 ==> Enter a status name to indicate the 'completed' status of a task

c. Line 9 ==> Enter the name of the status you want to be updated in the Ticket after the completion of all the associated Tasks

14. Click Save to save the custom function.
15. Click Save again to save the workflow.

We trust this solution will streamline your workflow! Stay tuned for more fresh insights and tips to help you make the most of Zoho Desk and optimize your experience.

• Topic Participants

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

• How to create auto populate field based on custom module in Zoho CRM?

  Hello, i'm still new to Zoho CRM and work as administrator in my company. Currently, I'm configuring layout for Quotes Module. So, the idea is, I've created a read-only field in Quotes called "Spec". I want this field automatically filled with Specification

• Office 365 and CRM mail integration: permission required

  Has anyone run into this weird problem? My email server is Office 365. When I try to configure Zoho CRM to use this server, a Microsoft popup window opens requesting user and password. After entering that, I get a message in the Microsoft window saying

• Deluge - Can't get phone number SalesIQ

  Hey folks, I’m building a custom plug for SalesIQ that’s supposed to register leads into Zoho CRM. The SalesIQ chat is being implemented on WhatsApp, and in my plug I’m using this line: mobile_clean = session.get("phone").get("value"); From what I understand,

• Zoho Desk - Community

  As a regular user of Zoho Cares Community I would really love to see the publish date of articles. For example, when I look at Announcements, it would be very beneficial to see which ones were posted recently, over those which have just and a recent comment.

• access to quartz for my customers

  Hi how can I have access to the application quartz you use for us to send you screen rocording, this feature would be immensely useful for our customers support https://quartz.zoho.com/

• Issue with Inline Images in Email Reply via Zoho Desk API

  Hi, I am attempting to send inline images in an email reply using the Zoho Desk API, but the images are not being displayed inline for the recipient. I have followed this documentation: https://desk.zoho.com/DeskAPIDocument#Uploads https://desk.zoho.com/DeskAPIDocument#Threads#Threads_SendEmailReply

• How to search a value stored in a subform?

  Hello, We store serial numbers in subforms but now we would like to be able to search the values to be able to easily find the record with the serial number. I saw that it's not possible to search such values through global search but is it possible to do it an other way? Thank you,

• Field Dependency Not Working on Detail Page in Zoho Desk

  Hi Support Team, I’ve created field dependencies between two fields in Zoho Desk, and they are working correctly on the Create and Edit layouts. However, on the Detail page, the fields are not displaying according to the dependencies I’ve set — they appear

• How do the keyword critera work?

  Hi, I'm working on automated assignment of tickets based on keywords. How does this feature work? Where does this criteria look for keywords - email address, subject, email body? Can you please clarify this as I want to avoid overlapping with criteria

• Error: Unsupported content type: text/html;charset=UTF-8 after tryeing to get the token for n8n automation

  I am working on ZOHO Desk automation and need to get the ZOHO auth token for n8n I have created the app in ZOHO Desk API, got client id and client secret. Added all data required to get a token in n8n. After I sign in with my ZOHO credentials in ZOHO

• Improving Collaboration Features in Zoho Portal

  Hello Zoho Community, I’ve recently started exploring Zoho services and I’m really impressed with the wide range of features. However, I feel there is still room for improvement in the collaboration area. For example, it would be really helpful if we

• Automated Shopify Emails Not Being Delivered

  I have an ecommerce store with Shopify. I recently set up my email to be served through Zoho. Since doing this, customers are not receiving some of our automated emails from Shopify itself. Our initial email that confirms their purchase goes through but our Shipping Notification that is automatically sent out upon fulfillment is not going through. Sometimes we get a notice that it's been classified as spam, sometimes nothing. I can send/receive email via Outlook on my desktop and I can send/receive

• Send a campaign to one recipient.

  Very often I speak to a customer and they say they didn't see my email (maybe it went in Junk, maybe they deleted it). Anyway, I just want to go into the Campaign and send it to one person. You already have a feature very close to this - when sending a Test. While developing a campaign, I can send tests to anyone. Why can't we have this AFTER  the campaign has been sent? I know, there's a caveat, and that's in the use of merge tags. Most of the time I only use FNAME, but maybe you could check if

• Try FSM again for our business

  We already have our customers individual equipment in CRM with serial numbers, install dates, warranty length and importantly next service which is generally 2 years. a month before the service date is due we get get a report and send out service reminders.

• Get Cliq Meetings in my O365 calendar

  Hi, we are currently evaluating to replace the Teams Messaging and Meetings with Cliq. We currently still have all our email and calendars in O365. What i want to achieve is, to create a (ZOHO) meeting from Cliq and have this meeting added to my Outlook/O365

• Issue with Zoho Help Portal – Tickets Missing or Not Answered

  Hi, How are you? I think there may be an issue with the Zoho Help Portal. I opened a few tickets directly in the help portal a some time ago but never received any response I also opened ticket 148356451 by email. I did receive a reply to it, but the

• DUNS & Bradstreet and Credit risk monitoring integration with Zoho books

  Small businesses not being paid by bigger clients and clients of all sizes is a huge problem. It will be nice if Zoho develops integration with DUNS & Bradstreet(D&B) and Credit risk monitoring integration with Zoho books. That have small businesses can

• Zoho Forms - Form Rules based on attachment fields

  Many businesses use forms to collect documents and images from customers. In many cases, you may want to trigger a notification or other automation based on whether or not an attachment was added. I've noticed that attachment fields do not appear in Rules

• Can't open draft email for editing

  Last night I started composing an email and I let it save in drafts. This morning I want to continue working on the email. It is in my Drafts folder but it will not open. The only option there is to delete it. This is not the first time it has happened. On previous occasions I have just deleted the draft and started afresh, but I really want this one back. Windows 10 with Pale Moon 28.10.0 browser.

• Open filtered deals from campaign

  Do you think a feature like this would be feasible? Say you are seeing campaign "XYZ" in CRM. The campaign has a related list of deals. If you want to see the related deals in a deal view, you should navigate to the Deals module, open the campaign filter,

• Change scheduling emails time

  When sending an individual email there is a great feature to schedule them to send later. I could only use the one time that is suggested. Is there a way to select another time? Regards, Glenn

• Zoho CRM: how can I control which contacts to sync with Outlook?

  I was just playing around syncing contacts from Zoho to MS Outlook (MS365 account.) The problem is our firm has hundreds of thousands of contacts and I don't want to bury my contacts list in outlook. Any help with this is greatly appreciated.

• How to overcome limitations in meetings

  As a company, one of our deliverables is a meeting between two other companies, where we act as facilitators. So, if we recorded this meeting  in Zoho CRM, it should be connected to 2 accounts, 2 contacts, and 1 campaign (a campaign, in our use, is the

• Add a 'Log a Call' link to three dot icon in Canvas

  Hi, There's a three dot element when creating a canvas called 'More'. I would like to modify this to add a link that says 'Log a Call' in order to quickly record the details of a cellphone call. I'd also like this to be a simple 'contact' selection and

• Syncing Zoho Forms with Bigin - Embedding issue?

  Hello everyone, I created a Zoho Form for a page on my GoDaddy website to collect leads, which then transfers the data to Bigin. However, I'm facing an issue where it doesn't seem to work properly. I've integrated Zoho Forms with Bigin and tried embedding

• Can not add fields to a Section

  I feel like I'm missing something obvious: I can add new Sections to my form but I can not add fields to the Sections. I've tried fields already on the form as well as dragging and dropping new fields into the Section but nothing will go into it. What

• Record Logged in User while using CRM lookup field

  Is it possible, while using the Zoho CRM lookup field, to automatically use the user account logged into Zoho CRM in a hidden field? I was hoping to add employee accounts to my current plan. But would like a record on the Form submission of who submitted

• Form Rules for Suburb Categories to alternate landing pages or Making a Fields Contents ALL CAPS

  I need to send differentform submissions to two to three different thank-you URLs (for Meta/Google pixels) depending on which suburb a user selects in a form. I have ~400 suburbs split into two categories (A and B, based on business value). Current challenges:

• Collaps Notes

  There are times when long/large notes are added to a record i.e. Accounts or Deals etc. Currently, the full note is displayed in the notes related list section. It would be great if by default only 5 to 10 rows of the note are displayed when the note

• Zoho Down

  I have a drop in my Zoho One services.

• Runing RPA Agents on Headless Windows 11 Machines

  Has anyone tried this? Anything to be aware of regarding screen resolution?

• Problem for EU users connecting Zoho CRM through Google Ads for Enhanced conversions

  Has anyone else experienced this problem when trying to connect Zoho CRM through Google Ads interface to setup enhanced conversions? Did you guys get it fixed somehow? The Problem: The current Google Ads integration is hardcoded to use Zoho's US authentication

• Why am I getting event Pop-up Notification for events that have been cancelled?

  Why is Calendar Notification still popping up for events that have been cancelled or changed? Each time events are cancelled or changed, I have observed that I am still getting notifications for them. Below is a sample pop-up notification for one of the

• Create a draft in reply to an email via Emails API

  Hi, I’d like to use the outgoing webhook to automatically create a draft reply to incoming mail. How can I use the Emails API to create a draft reply that is linked to an existing email thread? I couldn’t find the relevant method in the documentation.

• India Tech Support

  Is there no phone tech support number for India? And no chat facility either?

• Billing Management: #1 Billing a Universal Business Routine

  Hello, As the saying goes, "Do the hardest job first." We started with the complex subject of finance and revenue management, which is considered the backbone of any business. Now, let's shift our focus and take a deep dive into this Billing Management,

• What is a a valid JavaScript Domain URI when creating a client-based application using the Zoho API console?

  No idea what this is. Can't see what it is explained anywhere.

• 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

  ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 諸事情につき、今月の開催回は中止となりました。 次回は10/31（金）14時からの開催を予定しています。 ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。 Zoho

• Workdrive 5.0 / API Documentation Workflows

  Hi Zoho, When will the API documentation of the workflows be published? We are interested in using it to trigger manual workflows from an external application. Greetings, Justin

• How many ZOHO-Sites does the ZOHO-One Suite allow for?

  The free version of ZOHO-Sites allows for two sites, but it seems that the professional version (which is included in the ZOHO-One Suite) only allows for two websites. Is that correct? How many sites can I have within one ZOHO-One account?

• Next Page