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

• Introducing Creator Simplified: An exclusive learning series to enhance your app development skills

  Hey Creators! Welcome to Zoho Creator's new learning series, Creator Simplified. In this series, we'll dive into real-world business use cases and explore how to translate your requirements into solutions in your Creator application. You can also expect

• [Product update] Updated Data Synchronization Process for QuickBooks - Zoho Analytics Integration.

  Dear QuickBooks integration users, We’re making an important update in the way data is currently synced in your QuickBooks integration within Analytics workspace. What’s changing: Previously, with every data synchronization, Zoho Analytics used to fetch

• Zoho CRM new calander format cannot strikethrough completed task

  Hi, Recently there is a new format for calendar within Zoho CRM However, found out that a completed task will not cross out or strikethrough like previous format. Without strikethrough, it will be difficult to identify which task is still in Open status.

• Employees not Users

  Hello, We are a construction company that has +180 employees and most of them are in remote location working onsite with no access to internet. Is it possible that we have data stored for all employees but have only 5-10 users who will be in charge of entering employees data? or do we have to pay for all +180 employees? even though they won't be using the system?

• Zoho people generatimg pdf

  Hello , now i want to make a customm button in zoho people that is inside a deduction module , that fetches all the records and generate a pdf with a template that i have done in the mail merges template , i was told that i have to upload template on

• zohorecruit.com career form postcode bug

  Dear, When I select a postcode from the drop down on a zohorecruit.com career form, the street text field is automatically filled with the name of the city, which should not happen. Any idea how I can fix this? Thanks, Bart

• Office-365-agenda and Microsoft Teams Integration

  Dear, I have a trial version of Zoho Recruit and trying to evaluate the Microsoft Teams Integration in Zoho Recruit. After registering with my Office 365 account and checking the result of the registration/sign-in at https://mysignins.microsoft.com/ (which

• How to add Connector in developer platform zoho?

  Hi, I am working on creating an Extension, and part of the development is to retrieve Email templates. In my CRM instance I can invokeURL by creating Zoho OAuth connection and get the template. But developer platform does not provide Zoho OAuth or any

• How to archive Lost/Junk Leads so sales reps don’t see them, but keep them for reporting?

  Hi everyone, In our Zoho CRM we have two Lead Status values: Lost Lead and Junk Lead. What I want to achieve is: When a lead is marked as Lost or Junk, it should disappear from my sales reps’ Lead views (so they only see active leads). At the same time,

• Zoho CRM Canvas Copy Original Layout

  Hello all, I want to use Canvas to make small changes to certain views, not to make huge changes. Is it possible to copy the original Zoho layout and set-up and start from there? I checked and all I can find are some templates which are far from the original

• Revenue Management: #5 Revenue Recognition in SaaS

  If you're building or running a SaaS business, you've probably encountered this. You get paid upfront for a subscription and a one-time onboarding fee, but you end up with confusion about when to consider it revenue. Can I book all of it now? Should I

• Zoho Learn Course Access Issue

  One of the learners in a specific course can't see any lessons. They are registered as both a user and learner for this course in Zoo Learn. What could be the reason?

• ZOHOLICS Japan 2025 開催のお知らせ（再投稿）

  【コミュニティユーザーの皆さまへお知らせ】 Zoho 最大のユーザーイベント「ZOHOLICS Japan 2025」を9月19日（金）に開催します。 AI活用に関する特別講演、ユーザー事例、Zoho 製品の活用例のご紹介など、Zoholicsならではのセッションをご用意しています。 Zoho コミュニティ開催のMeetupとはまた違った雰囲気のイベントです。 ご都合のつく方はお気軽にご参加ください✨ 詳細はこちら https://events.zoho.jp/zoholics2025#/?affl=forumpost2

• Phone Number format for Bulk Upload via csv for Zoho Sign

  What is the phone number format that we need to use for a bulk recipient upload via csv in zoho sign, should the country code be included for ex if its US should it be +18889007865 ior 18889007865 or without country code 8889007865? the sample csv provided

• Filter Page Elements By Selectable Date Range

  I have created a basic Page that will serve as a client dashboard with elements that will provide simple counts & sums of data in reports. There are no reports or forms added to the page, just elements. It currently functions as needed, but shows the

• Can’t Enter my Notebook is Locked

  I’ve been using Notebook for taking notes at my college for a month and I never signed in and I never established a password. Today I tried to enter the app after the update and it asked me for a password. I need to access to my notes urgently and I can’t

• Send Email Directly to Channel

  Hi, We are coming from Slack. In Slack each channel has a unique Email address that you can send emails too. I currently forward a specific type of email from my Gmail InBox directly do this channel for Verification Codes so my team doesn't have to ask

• Secure your external sharing process with OTP Authentication

  For any business, it's crucial to share files externally in a way that is both secure and controlled. Let's say you want to share confidential data with your partners and vendors. You must ensure that only your intended recipients can access the shared

• Items attribute questions

  Many of my items have attributes, such as size and color. How can I add new fields to the "New Items" screen to capture that in my Purchase Orders, Items, and Sales Order pages? I only see these attribute fields when adding an Item Group. Also, on the

• Is there a way to search mail for items you haven't yet responded to?

  I'm trying to create a search to show emails that haven't been responded to and that have also been assigned a tag or label. Is there a way to search for the inverse of replied?

• Subtotals per Header

  Hey, we would like to display subtotals per header in our invoices:

• upgrade storage

  how to upgrade my storage

• Linking items from books and subscription

  Linking books and subscription It is a pity that it is not possible to associate with a product an article present in ZohoBooks This would make it possible to manage products composed of a nomenclature of articles of books

• Add the ability to view number of hours planned for a workorder while in the Dispatch Console

  Hi Zoho, When dispatching a work order through the Dispatch Console, there's currently no way to view the number of planned hours for the service tasks associated with that specific work order. Having to click into the details each time to check planned

• Uploading Files from uploads api

  I tried uploading the image from the API call but its giving me unauthorized error even i have given valid token in header. After uploading i need that id to pass in create ticket api uploads but its not uploading that file. Please help me out in th

• Change format of quantity format

  Hi,  I would like to change the qunatity format from 1,00 to 1.  Is this possible?   thanks!

• square up and Zoho books

  Since we set up the app connection between square up and Zoho books we have realised that when the amounts are getting transferred Zoho is adding VAT again making the numbers 20% more than they should be. We have checked our settings and they VAT/ Tax

• How to provide Access rights to specific Bank accounts

  We have several bank accounts. I want to provide certain members access to only 2-3 accounts. It appears that when I give permissions, they are for ALL bank accounts. How do I do that?

• Errors Getting a Bank Transaction

  Using Postman(for testing), I am receiving errors when attempting to get a single bank transaction. I am able to receive the list of bank transactions with https://www.zohoapis.com/books/v3/banktransactions/?organization_id={org_id} but when I try to

• Subscriptions Plans and CRM Products Integration?

  Is there any way to set up plans and pricing in Zoho Subscriptions and have those available as Products in the CRM? We are trying to set up the CRM and the Products seem to be more geared toward selling products that are not subscription based.  So if we sell annual or monthly contracts which are $10/seat/month, I can set this up as a plan in Subscriptions, but how can I set the same thing up in the CRM for the salespeople to sell/quote? What is the best practice for setting up the CRM Products to

• Mapping Zoho Subscription Plans and Products to CRM and Books

  We have products that are one time products and subscription products.   1) We would like to have the ability to create an opportunity in CRM that includes both one-time charge products and subscription products.  Currently the only way of creating a subscription product is by defining a "Product->Plan" hierarchy in Zoho Subscription.  It appears that the only SYNC between Subscription and CRM is around contacts and the Product->Plan hierarchy doesn't sync to CRM, thus, you would need a duplicate

• Bulk update fields based on date

  Hi! I need all the quotes with "Quote Stage" set to "Next Year" to update to "Draft" every January 8 (every year). Can you help?

• Target for a campaign

  Hi, Hope you can help me. I need to create a report (for a marketing campaign) that combines Deals and Contacts to export all the contacts with closed deals. I can easily do that, what I cannot do is to remove from the target the contacts that have more

• Zoho Desk + Jira integration - Email notifications and comments posted by administrator instead of real user

  Dear All, I set up the integration under my admin account, and now when users leave comments in Jira (to created tickets in Zoho Desk), the email notifications show that the ‘Administrator’ left a comment, not a real user. The same happens in the ticket

• Celebrating the power of visuals

  On World Photography Day, we would like to highlight the power of visuals in customer service. Visuals promote learning and understanding in less time. A photograph can rekindle a memory, convey more than words, and give a fresh perspective. How does

• Blocking / black listing customers

  Hi, We have a situation, we observed that certain customers are blocking multiple appointments with our advsiors but not showing up. Some of these are repeat offenders. This leads to those service hours getting blocked and not available for genuine customers.

• Feature Request: Email Templates for notifications accross all services

  Currently in Zoho Bookings, email notifications (such as booking confirmations, reminders, and cancellations) must be customized individually for each service. This becomes time-consuming and error-prone when managing multiple services that require consistent

• Approval-based booking with Zoho Creator and Zoho Bookings

  Hi community members, We have developed a workaround for approval-based booking using Zoho Creator and Zoho Bookings! This provides a temporary solution as we work on the native feature, and it's useful for anyone needing an approval workflow when confirming

• Member Accounts in Related List

  Hi Team, Currently, when a parent account is associated with an account in FSM, there is no related list displaying the associated member accounts under the parent account’s related list section. To view member accounts, I have to manually search using

• how do i remove a specific Zoho Service from my account

  I no longer need Zoho CRM, ZRM Assist nor ZRM BugTracker. How do I remove them from the list of apps for my account?

• Next Page