Automation#28 Notify Agents on Article Expiry

Hello Everyone!

This week, we’re bringing you a feature that notifies your team when articles in the Knowledge Base are set to expire to keep your content relevant and helpful for customers.

The Zoho Desk's Knowledge Base is an asset for customers to gain knowledge and help themselves navigate through the product or process of the firm or industry. Zoho Desk allows you to set expiry dates for articles to maintain up-to-date information. However, once an article expires, it’s removed from the Help Center, and notifications are only sent to the article owner by default. 

But, what if they miss it?

This solution integrates with a scheduler to notify team members on the same day an article expires. 

Here’s how you can implement the custom function within the schedule to notify your team when an article expires.

Prerequisites

I. Create a connection

  1.1 Go to Setup(S) and choose Connections under Developer Space.

  1.2 Click Create Connection.

  1.3 Select Zoho Desk under Default Connection.

  1.4 Set the connection name as deskconnection.

  1.5 Under Scope, choose the below scope values:

Desk.articles.READ

  1.6 Click Create and Connect.

  1.7 Click Connect and click Accept.

Connection is created successfully.

II. Create a Schedule

1. Go to Setup, choose Schedules under Automation. 

2. Under Schedules, click New Schedule.

3. Under Add Schedule, enter a Schedule Name and Description for the rule.

4. In the Execute on tab, set the Date and Time for the schedule to begin execution. 

5. In the Repeat tab, select 'Every Day,' then choose 'Every [1] Days.' Select the days based on your preferences and set 'Ends' to 'Never'. Click Done.  This will ensure the schedule runs on the selected days. 

6. In the Functions section, click on Create Function.

7. Enter a Name and Description for the custom function.                                           

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

1. // ----<<<< User Inputs >>>>----
2. subjectOfNotificationEmail = "Zoho Desk - Article Expiry Notification"; // provide subject based on your preference
3. commaSeperatedToAddresses = "email address1, email address2";//provide email addreses of team members
4. currentDateString = zoho.currentdate.toString("yyyy-MM-dd");
5. //Expiring/Expired Today
6. fromString = currentDateString + "T00:00:00.000Z";
7. toString = currentDateString + "T23:59:59.999Z";
8. info "final url " + "https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString;  
9. //change .com based on your DC
10. getArticle = invokeurl
11. [
12. url :"https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString
13. //change .com based on your DC
14. type :GET
15. connection:"deskconnection"
16. ];
17. emailBody = "";
18. if(getArticle != null && getArticle != "" && getArticle.get("data").size() > 0)
19. {
20. articlesList = getArticle.get("data");
21. emailBody = emailBody + "<div> <b> List of articles expiring/expired today </b>";
22. for each  article in articlesList
23. {
24. webUrl = article.get("webUrl");
25. title = article.get("title");
26. emailBody = emailBody + "<div><br><a href='" + webUrl + "'>" + title + "</div>";
27. }
28. emailBody = emailBody + "</div> <br> <br>";
29. }
30. //Expiring Tomorrow
31. currentDateString = zoho.currentdate.addDay(1).toString("yyyy-MM-dd");
32. fromString = currentDateString + "T00:00:00.000Z";
33. toString = currentDateString + "T23:59:59.999Z";
34. info "final url " + "https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString;
35. //change .com based on your DC
36. getArticle = invokeurl
37. [
38. url:"https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString
39. //change .com based on your DC
40. type :GET
41. connection:"deskconnection"
42. ];
43. if(getArticle != null && getArticle != "" && getArticle.get("data").size() > 0)
44. {
45. articlesList = getArticle.get("data");
46. emailBody = emailBody + "<div> <b>List of articles expiring tomorrow </b>";
47. for each  article in articlesList
48. {
49. webUrl = article.get("webUrl");
50. title = article.get("title");
51. emailBody = emailBody + "<div><br><a href='" + webUrl + "'>" + title + "</div>";
52. }
53. emailBody = emailBody + "</div> <br> <br>";
54. }
55. //Expiring in 7 days
56. currentDateString = zoho.currentdate.addDay(7).toString("yyyy-MM-dd");
57. fromString = currentDateString + "T00:00:00.000Z";
58. toString = currentDateString + "T23:59:59.999Z";
59. info "final url " + "https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString;
60. //change .com based on your DC
61. getArticle = invokeurl
62. [
63. url :"https://desk.zoho.com/api/v1/articles?expiryTimeRange=" + fromString + "," + toString
64. //change .com based on your DC
65. type :GET
66. connection:"deskconnection"
67. ];    
68. if(getArticle != null && getArticle != "" && getArticle.get("data").size() > 0)
69. {
70. articlesList = getArticle.get("data");
71. emailBody = emailBody + "<div><b> List of articles expiring in 7 days </b> ";
72. for each  article in articlesList
73. {
74. webUrl = article.get("webUrl");
75. title = article.get("title");
76. emailBody = emailBody + "<div><br><a href='" + webUrl + "'>" + title + "</div>";
77. }
78. emailBody = emailBody + "</div> <br> <br>";
79. }
80. info "emailBody" + emailBody;
81. if(emailBody != "")
82. {
83. sendmail
84. [
85. from :zoho.adminuserid
86. to :commaSeperatedToAddresses
87. subject :subjectOfNotificationEmail
88. message :emailBody
89. ]
90. info "mail sent";
91. }

NOTE

In Line 2, Enter the Email Subject for the Notification.

In Line 3, Enter the email addresses of the team members you would like to notify. 

In Lines 8,12,34,38,59,63,  Replace ".com" with the domain extension based on your Data Center.

9. Click Save Script.  

10. Click Save to save the custom function.

11. Click Save again to save the Schedule.

By this, you can ensure quick updates and seamless publishing, keeping your Knowledge Base relevant and your customers updated with the latest resources. 

Stay tuned for more learnings on this forum. 

Regards,

Lydia | Zoho Desk 

• 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

• Weekly Tips :Instantly find what you need with Attachment Viewer

  Your inbox must be packed with project emails, shared notes, and scattered attachments. You are looking for one specific file—a presentation slide or maybe a media clip from a team update—but don’t want to dig through endless email threads or switch between

• Missing Zoho Desk integration option for form workflows

  According to the help page "Configure Zoho Desk integration in form workflows" we should be able to select Zoho Desk as an integration target but when I open the integrations list then Zoho Desk is not being listed in it. We are on the Premium plan which should already support Zoho Desk integrations.

• Gantt for 2 or more projects

  Hello, I'm trying the free version of your produtc. It is veryyy good!!!! I don't know if in the Standard plan, I can overview a Gantt Graph for 2 or more Projects Milestone. This would be very helpfull for managing teams and taking decisions about who I will assign a task to. In the paid plan Do I have this possibility? Thank you.

• Integrating a Zoho Project Gantt Chart into Reports

  Is is possible to integrate a Zoho Project Gantt Chart into a Zoho Report Dashboard. I am in the process of creating Project Status Dashboards for the projects that we track in Zoho Projects and I would like to incorporate the gantt chart within Reports.  Please let me know! Thanks

• ZOHO BOOKS - EXCESSIVELY SLOW TODAY

  Dear Zoho Books This is not the first time but it seems to be 3 times per week now that the system is extremely slow. I work on Zoho Books 95% of my day so this is very frustrating. Zoho you need to do something about this. I have had my IT guy check

• Displaying related quotes in sales order and back

  Hi, My colleague liked to see to which sales orders, the quote has been converted. Quote shows Invoices, but not SO. Same, they would like to see the quotes in the sales order, as they can see invoices, packages, shipment, How can we achieve this ? Thank

• Tip of the Week #71–Auto-move incoming messages to the right inboxes with keywords

  We all know that customer-facing teams, especially your sales and support teams, can’t afford to miss even a single customer conversation. But sometimes, sales queries or support requests can easily get lost in a crowded inbox or even end up in the wrong

• Clearing Fields using MACROS?

  How would I go about clearing a follow-up field date from my deals? Currently I cannot set the new value as an empty box.

• Migrating a Zoho Forms form into Zoho Creator

  Hi, How can I migrate my Zoho Forms form into Zoho Creator? Thanks. Truly, Emad

• Is there any way to recall an email sent using Zoho CRM?

  If an email is sent using Zoho Mail, there is a recall option/functionality that is available to the sender. Is there any way to recall an email if it was sent using Zoho CRM? I can't seem to find that option. Any help would be appreciated.

• Problem with reports due to "Connected" items change - Yes this IS a problem

  Now that the change has been made to use "connected" items I can no longer run the reporting I need in CRM. I should be able to start with Deals as the parent, connect down to the Account (Account_Name) on the deal as the child, then to any child items

• Introducing notifications in the vendor portal

  Imagine this: You're a recruiter working with multiple vendors on a high-volume hiring project. You’ve just updated a job description after a last-minute change from the hiring manager. One of your vendors, however, is still working off the older version

• Analytics for notes created

  Is there a way I can see how many notes were created per day? Via reporting or analytics?

• Cannot update Recurring_Activity on Tasks – RRULE not accepted

  Hello, I am trying to update Tasks in Zoho CRM to make them recurring yearly, but I cannot find the correct recurrence pattern or way to update the Recurring_Activity field via API or Deluge. I have tried: Sending a string like "RRULE:FREQ=YEARLY;INTERVAL=1"

• Add image to report...

  Greetings, I send a weekly color coded report via Creator email. I would like to add the legend somewhere in the report. Header, footer where ever. I have the legend saved on Google Drive and can access it via shared link. Sure someone has wanted to add

• More controls for User Fields in CRM

  Dear All, We are here with a minor but crucial enhancement to the user fields—now set accessibility permissions to the records for user field. User field allows you to extend co-ownership of records to your peers. You can collaborate with them for certain

• Calls to accounts rather than leads or contacts?

  So..... We have a dilemma and I'm hoping someone has encountered this before and figured out a fix. We have just migrated to Zoho. It's great.....expect for how "Calls" are handled.... We are B2B. We do not use the leads module. A "Lead/Prospect" for

• Image Upload Field | Zoho Canvas

  I'm working on making a custom view for one of our team's modules. It's an image upload field (Placement Photo) that would allow our sales reps to upload a picture of the house their working on. However, I don't see that field as a opinion when building

• Power of Automation :: Automated 'Delayed & Closed' Status Update Based on Due Date

  Hello Everyone, 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

• Range names in Zoho Sheet are BROKEN!

  Hi - you've pushed an update that has broken range names. A previously working spreadsheet now returns errors because the range names are not updating the values correctly. I've shared a video with the support desk to illustrate the problem. This spreadsheet

• populate email address and name in zoho desk?

  Is it possible to populate the email address and name in the zoho desk widget? We only use it in the context of an authenticated user, so we already know the user's name and email. Thanks,

• Are there default/pre-built dashboards in Zoho Desk?

  Hi, I am looking for some pre-built dashboard templates in Zoho Desk, similar to what we can find in CRM/Projects, etc Thank you

• SAP S/4 HANA to CRM Integration - change the SAP Client ID

  Hi I am trying to push the business partners from SAP S/4 HANA to ZOHO CRM module. The SAP Client ID is 421 in my case....kindly let me know how do I specify the sap client because it's a dropdown with specific values as of now. Thanks Ravi Aswani

• Adding branded signature to tickets reply

  Hi, i am unable to figure out how to add signatures with logo to tickets reply. please advice .

• How to share ticket numbers across different ticket types

  I'm running an event and have three different ticket types. Add on Event + Main Event - Early bird Main Event only - Early bird Add on Event only - Early bird And Standard class - shown but not available until early bird finishes Add on Event + Main Event

• Adding Social Media Buttons to Basic Campaigns

  Hi, I'm quote new to using Zoho Campaigns and I can't work out how to add Social Media Buttons into my basic campaign? In MailChimp there's a button that brings the icons into your campaign for you. I've tried adding the social media icons as 'buttons' in Zoho but it's not looking great. Can anyone help? Thanks!

• Hide Inactive Social Sign-In Providers from Login Screen

  Hello Zoho Team, We hope you are doing well. Currently, Zoho One allows admins to configure security policies and enable or disable Social Sign-In options for third-party providers such as Apple, Google, Microsoft, LinkedIn, Yahoo, Twitter, Facebook,

• [Free Webinar] AI Agents in Zoho Creator - Creator Tech Connect

  Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into

• Download All Attached Files

  It would be extremely useful to have "download-all" functionality for downloading files attached to a task, subtask, comment, forum post or hosted in the "Documents" section etc. We've instructed our users to zip multiple files prior to uploading, but of course they forget all the time. Having to download lots of files one-at-a-time off a comment or task wastes a lot of time.

• Ship via Carrier Not Working Since Commerce Update

  Since the recent update to the Commerce platform, I can no longer use the ship via carrier function. It will take me to the address screen and let me verify them but when I go to save and move tot he next screen it will not do anything. This is happening

• automations: Can I execute a step on a specific date?

  I have created a form in Zoho forms, and created a contacts list. I have also begun setting up an automation with the intention of sending the form to the contact list on a specific date every month (via email) for the entire year (essentially sending

• Zoho Expense - The ability to add detail to a Trip during booking

  As an admin, I would like the ability to add more detail to the approved Trips. At present a requestor can add flights, accommodation details and suggest their preferences. It would be great if the exact details of the trip could be added either by the

• Adding Folders in Android App

  Is it possible to create a new email folder within the Zoho Mail Android app?  Or can this only be done from the desktop version of Zoho Mail? Cheers!

• Schedule Exports for Regular Project Updates

  Tracking project data often means exporting data at regular intervals. Instead of manually exporting data every time, users can schedule exports for Phases, Tasks, and Tasks in Zoho Projects. These exports can be set to run once, daily, weekly, or monthly

• Question about custom fields using Pivot Tables.

  I have created a pivot table showing annual revenue of a client and how much payment that client is paying my company. Is there a way using pivot table to add an additional field that subtracts those to fields / shows me a percentage of that difference?

• Request for Light/Dark Mode

  Would love the ability to switch between Light and Dark mode similar to Zoho CRM. https://help.zoho.com/portal/en/community/topic/introducing-dark-mode-light-mode-a-new-look-for-your-crm

• Journey Email - Ignored Contacts

  I have a journey setup which simply sends a string of emails over time. For some reason I am getting large amounts of the contacts who enter the first email being ignored and I can't find anywhere in reports or audit logs why these contacts are not

• Involved account types are not applicable when create journals

  { "journal_date": "2016-01-31", "reference_number": "20160131", "notes": "SimplePay Payroll", "line_items": [{ "account_id": "538624000000035003", "description": "Net Pay", "amount": 26690.09, "debit_or_credit": "credit" }, { "account_id": "538624000000000403", "description": "Gross", "amount": 32000, "debit_or_credit": "debit" }, { "account_id": "538624000000000427", "description": "CPP", "amount": 1295.64, "debit_or_credit": "debit" }, { "account_id": "538624000000000376", "description":

• Zoho Books - Include Payment Terms as a Custom View filter

  It would be great if you could created a custom view based on Payment Terms. This would be really handy for seeing a list of customers who have credit terms. A workaround is not required. I could do something with a creditor checkbox, but it would be

• How to update changed purchase account of item in invoice

  I have selected the wrong purchase account for various articles and created invoices. I had to adjust the purchase account in the article afterwards, but the old purchase account is still posted in the transaction-journal of the invoice. To adjust the

• Next Page