Automation #16: Automate Ticket Reopening on Scheduled Timestamp

Hello Everyone!

This edition uncovers the option to schedule reopening a ticket automatically.

Zylker Finance tracks insurance policyholder activities through Zoho Desk. For policyholders who pay monthly premiums, tickets are closed upon payment completion. To efficiently follow up with its customers every month, Zylker Finance automatically reopens existing tickets on a specific date rather than creating new ones. This helps insurance agents ensure they do not miss any customer interactions.

Zylker Finance automates this process using a custom function in Schedules to ensure efficient tracking and operations management. Let's delve into the setup to understand the configurations.

Prerequisites

​

1. Create a custom date field in the Ticket layout.

Navigate to Setup >> Customization >> Layouts and Fields >> Choose the preferred department and select the layout to add a custom date field. Assign a Preferred Name to the Date Field.

Click on the gear icon of the custom date field and note the API name.

2. Fetch Department ID

To fetch department ID, go to Setup >> General >> Departments >> click on the preferred department. Go to the address bar and find the last number series in the URL; this is the department ID. Copy the ID appended in the URL and paste it into line 9 of the custom function for the departmentId value.  

3. Create a connection

3.1 Go to Setup >> Connections under Developer Space

3.2 Click Create Connection.
3.3 Select Zoho OAuth under Default Connection.
3.4 Give the connection name as deskconnection. 
3.5 Under Scope, include the below scopes

                  Desk.tickets.READ

                  Desk.search.READ

                  Desk.tickets.UPDATE

3.6 Click Create and Connect.
3.7 Click Connect and click Accept.

Connection is created successfully.

Create Schedules

1. Go to Setup >> Automation, choose Schedules.

2. Click on New Schedule in the top right corner. (Ensure that the correct department is selected.)

3. Give a preferred Name and Description for the Schedule.

4. Under Execute on, choose the preferred Date and Time for the schedule to begin execution. 

5. Under Repeat, choose the preferred frequency as Every Day. Under Ends, choose Never.

6. Under Functions, click on Create Function.

7. Give a Name and Description for the function. Paste the below custom function in the script window.

1. // ----<<<< User Inputs >>>>----
2. //Replace deskURL with the URL based on your DC
3. deskURL = "https://desk.zoho.com";
4.  
5. //Replace your custom date field's API Name
6. cfAPIName = "cf_action_date";
7.  
8. // Replace *********** with your department Id
9. departmentId = ***********;
10.  
11. // ----<<<< Initial Configs >>>>----
12. logs = Map();
13. ticketIdList = List();
14. currDate = now.toText("YYYY-MM-dd");
15.  
16. //---------------------------
17. try {
18.     // ---- start your logic from here ----
19. ticketSearch = invokeUrl
20. [
21. url : deskURL + "/api/v1/tickets/fieldSearch"
22. type : GET
23. parameters : { "from" : 0 , "limit" : 50 , "field1" : cfAPIName+":"+currDate,"departmentId":departmentId }
24. connection : "deskconnection"
25. ];
26. logs.insert("ticketSearch":ticketSearch);
27. 
    
28. if ( ticketSearch != null && ticketSearch != "" && ticketSearch.containsKey("data") && ticketSearch.get("data").size() > 0 )
29.     {
30. for each tkt in ticketSearch.get("data")
31.         {
32. ticketIdList.add(tkt.get("id"));
33.         }
34.     }
35. logs.insert("ticketIdList":ticketIdList);
36. if ( ticketIdList.size() > 0 )
37.     {
38. bulkUpdateTickets = invokeUrl
39. [
40. url : deskURL + "/api/v1/tickets/updateMany"
41. type : POST
42. parameters : { "ids" : ticketIdList , "fieldName" : "status" , "fieldValue" : "Open" } + ""
43. connection : "deskconnection"
44. ];
45. logs.insert("bulkUpdateTickets":bulkUpdateTickets);
46.     }
47. }
48. catch(errorInfo) {
49.     logs.insert("errorInfo": errorInfo);
50. }
51.  
52. info "logs: \n" + logs;

Note : In line 3, replace the URL with the Desk URL corresponding to your DC.

[ Example: For US DC, the url will be https://desk.zoho.com

                         India DC, the url will be https://desk.zoho.in

                         EU DC, the url will be https://desk.zoho.eu]

In line 6, replace cf_action_date  with the your custom date field's API Name. In line 9, give the department ID.

8. Click Save to save the script.

9. Click Save again to save the created schedule.

 

Implementation

When the custom date field matches the Execute On date in the schedule, the ticket will move to the open state.

We hope our updates enhance your experience with Zoho Desk, enabling you to offer great customer support. Stay tuned for updates on features and functions in Zoho Desk. 

• Topic Participants

• Lydia | Zoho Desk

  

• sales

• Shivani | Zoho Desk

  

• voomgroup

• 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 CRM mobile: Support for rich text in multi-line fields, Image upload field, and more

  Hello everyone, We've made a few enhancements to the Zoho CRM mobile app to improve your experience. Here's what's new: Rich text support for multi-line fields (iOS) Image upload field support (iOS and Android) Tool tip markdown (iOS) Rich text support

• in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Q

  in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Quantity Returned\ pls check the recording fetch_salesorder

• Estimates with options and sub-totals

  Hi It seems it would be great to be able to show multiple options in an estimate. For instance I have a core product to which I can add options, and maybe sub-options... It would be great to have subtotals and isolate the core from the not compulsory items. Thanks

• Optional Items Estimate

  How do you handle optional items within an estimate? In our case we have only options to choose with. (Like your software pricing, ...standard, professional, enterprise) How can we disable the total price? Working with Qty = 0 is unprofessional....

• Important Update : Zendesk Sell announced End of Life

  Hello Zendesk users, Zendesk has officially announced that Zendesk Sell will reach its End of Life (EOL) on August 31, 2027 (Learn more). In line with this deprecation, Zoho Analytics will retire its native Zendesk Sell connector effective October 1,

• Zoho Sheets

  Hi, I am trying to transition into Zoho sheets, I have attached the issues encountered. Server issues, file trying to upload for more than 30 mins, even once uploaded my data aren't loaded. Simple calculations are not working I have attached the sample.

• Zoho CRM + Zoho FSM : alignez vos équipes commerciales et techniques

  La vente est finalisée, mais le parcours client ne fait que commencer ! Dans les entreprises orientées service, conclure une vente représente seulement la première étape. Ce qui suit — installation, réparation ou maintenance régulière — influence grandement

• Top Bar Shifting issue still not fixed yet

  I mentioned in a previous ticket that on Android, the top bar shifts up when you view collections or when you're in the settings. That issue still hasn't been fixed yet. I don't wanna have to reinstall the app as I've noticed for some reason, reinstalling

• Power of Automation:: Automate the process of updating project status based on a specific task status.

  Hello Everyone, Today, I am pleased to showcase the capabilities of a custom function that is available in our Gallery. To explore the custom functions within the Gallery, please follow the steps below. Click Setup in the top right corner > Developer

• Billing Management: #3 Billing Unbilled Charges Periodically

  We had a smooth sail into Prorated Billing, a practice that ensures fairness when customers join, upgrade, or downgrade a service at any point during the billing cycle. But what happens when a customer requests additional limits or features during the

• No bank feeds from First National Bank South Africa since 12 September

  I do not know how Zoho Books expects its customers to run a business like this. I have contacted Zoho books numerous times about this and the say it is solved - on email NO ONE ANSWERS THE SOUTH AFRICAN HELP LINE Come on Zoho Books, you cannot expect

• Citation Problem

  I had an previous ticket (#116148702) on this subject. The basic problem is this; the "Fetch Details" feature works fine on the first attempt but fails on every subsequent attempt, Back in July after having submitted information electronically and was

• Failing to generate Access and Refresh Token

  Hello.  I have two problems: First one when generating Access and Refresh Token I get this response:  As per the guide here : https://www.zoho.com/books/api/v3/#oauth (using server based application) I'm following all the steps. I have managed to get

• Auto-Forward All Incoming Mail

  I have setup the Zoho Business Mail to host my own domain's mail.  Is it possible to have all incoming email auto-forwarded to another email account?  What I would like to do is have all incoming emails forwarded to my Yahoo or Hotmail accounts until I can complete the migration to Zoho.  I can't seem to locate this setting anywhere.  I don't care whether the mail is kept on the Zoho server or not at this time.

• Zeptomail 136.143.188.150 blocked by SpamCop

  Hi - it looks like this IP is being blocked, resulting in hard bounces unfortunately :( "Reason: uncategorized-bounceMessage: 5.7.1 Service unavailable; Client host [136.143.188.150] blocked using bl.spamcop.net; Blocked - see https://www.spamcop.net/bl.shtml?136.143.188.150

• Apply transaction rules to multiple banks

  Is there any way to make transaction rules for one bank apply to other banks? It seems cumbersome to have to re-enter the same date for every account.

• How to bulk update records with Data Enrichment by Zia

  Hi, I want to bulk update my records with Data Enrichment by Zia. How can I do this?

• How do I split a large CSV file into smaller parts for import into Zoho?

  Hi everyone, I’m trying to upload a CSV file into Zoho, but the file is very large (millions of rows), and Zoho keeps giving me errors or takes forever to process. I think the file size is too big for a single import. Manually breaking the CSV into smaller

• Client Script Payload Size Bug

  var createParams = { "data": [{ "Name": "PS for PR 4050082000024714556", "Price_Request": { "id": "4050082000024714556" }, "Account": { "id": "4050082000021345001" }, "Deal": { "id": "4050082000023972001" }, "Owner": { "id": "4050082000007223004" }, "Approval_Status":

• lead convert between modules

  Hello, The workflow we set up to automatically transfer leads registered via Zapier into the Patients module to the Leads module started to malfunction unexpectedly on September 25, 2025, at 11:00 AM. Under normal circumstances, all fields filled in the

• Flow Task Limits - How to Monitor, Understand Consumption?

  So, I got an email last night saying that I've exhausted 70% of my tasks for this month, and encouraging me to buy more tasks. I started to dig into this, and I cannot for the life of me figure out where to find any useful information for understanding,

• Cross References Do Not Update Correctly

  I am using cross references to reference Figures and current am just using the label and number, i.e. Figure #. As seen here: When I need to update the field, I use the update field button. But it will change the cross reference to no longer only including

• Manage control over Microsoft Office 365 integrations with profile-based sync permissions

  Greetings all, Previously, all users in Zoho CRM had access to enable Microsoft integrations (Calendar, Contacts, and Tasks) in their accounts, regardless of their profile type. Users with administrator profiles can now manage profile-based permissions

• How to Track and Manage Schedule Changes in Zoho Projects

  Keeping projects on track requires meticulous planning. However, unforeseen circumstances can cause changes to schedules, leading to delays. It becomes important to capture the reason for such changes to avoid them in the future. Zoho Projects acknowledges

• Is there a notification API when a new note is addeding

  Trying to push to Cliq, or email notification when there's a new note added in module. How to implement this?

• Collaborate Feature doesn't work

  Hello Team. It seems that the collaborate section is broken? I can post something but it all appears in "Discussions". In there is no way how I would mark something as Draft, Approval, post or any of the other filter categories? Also if I draft a post

• Edit Permission during and after approval?

  When a record is sent for approval Can a user request for edit permission from the approver? We don't want to give edit permissions for all the records under approval Only on a case-by-case basis How can we achieve this?

• Zoho web and mobile application not workingn

  Both zoho forms web and mobile application aren't working. I have checked my network connections and they are fine.

• Bulk Moving Images into Folders in the Library

  I can't seem to select multiple images to move into a folder in order to clean up my image library and organize it. Instead, I have to move each individual image into the folder and sometimes it takes MULTIPLE tries to get it to go in there. Am I missing

• Latest updates in Zoho Meeting | Breakout rooms and End to end encryption

  Hello everyone, We’re excited to share a few updates for Zoho Meeting. Here's what we've been working on lately: Introducing Breakout Rooms for enhanced collaboration in your online meetings and End-to-end encryption to ensure that the data is encrypted

• Systematic SPF alignment issues with Zoho subdomains

  Analysis Period: August 19 - September 1, 2025 PROBLEM SUMMARY Multiple Zoho services are causing systematic SPF authentication failures in DMARC reports from major email providers (Google, Microsoft, Zoho). While emails are successfully delivered due

• Accidentally deleted a meeting recording -- can it be recovered?

  Hi, I accidentally deleted the recording for a meeting I had today. Is there a way I can recover it?

• How to access email templates using Desk API?

  Trying to send an email to the customer associated to the ticket for an after hours notification and can't find the API endpoint to grab the email template. Found an example stating it should be: "https://desk.zoho.com/api/v1/emailtemplates/" + templateID;

• Update Portal User Name using Deluge?

  Hey everyone. I have a basic intake form that gathers some general information. Our team then has a consultation with the person. If the person wants to move forward, the team pushes a CRM button that adds the user to a creator portal. That process is

• Unable to retrieve Contact_Name field contents using Web API in javascript function

  Hello, I've added a field in the Purchase Order form to select and associate a Sales Order (Orden_de_venta, lookup field). I've also created a client script to complete some fields from the Sales Order (and the Quote), when the user specifies the related

• Updating Woocommerce Variation Products Prices Via Zoho CRM

  I can update product prices with this flow: But I can't update variant products. I got a code from Zoho for this, but I couldn't get it to work. It needs to find the product in the CRM from the SKU field and update the variation with the price there.

• Emails Disappearing From Inbox

  I am experiencing the unnerving problem of having some of the messages in my inbox just disappear.  It seems to happen to messages that have been in there for longer than a certain amount of time (not sure how long exactly). They are usually messages that I have flagged and know I need to act on, but have not gotten around to doing so yet.  I leave them in my inbox so I will see them and be reminded that I still need to do something about them, but at least twice now I have opened my inbox and found

• Power of Automation :: Automatic removal of project users once the project status is changed.

  A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate complex tasks and

• Customizing Form Questions per Recipient Group in Zoho Campaigns/Forms

  Hello everyone, I would like to ask if it’s possible in Zoho Campaigns or Zoho Forms to send out a campaign where the form questions can be customized based on the group of recipients. Use case example: I have prepared 20 questionnaire questions. For

• Forms - Notification When Response Submitted

  How do I set it up to generate an email notification when a response (class request) is submitted?

• Next Page