Automation #14: Capture Jira Issue Key/ID in a Ticket Custom Field

Automation #14: Capture Jira Issue Key/ID in a Ticket Custom Field

Hello Everyone!

This month's edition brings you a custom function to consolidate your records associated with Jira integration. Jira integration enables support engineers and R&D units to collaborate seamlessly on feature development, product improvement, and enhance support. Tracking tickets with Jira IDs helps support engineers communicate updates to customers effectively. This custom function will help you consolidate reports of the tickets associated with Jira IDs.

David, a developer, uses Jira to manage all projects related to Zylker products. Sarah is the support admin for Zylker products, leading a team of customer support engineers. For tickets requiring developer intervention, Sarah escalates them to David with a Jira ID. Although the process of resolving tickets is smooth, it becomes challenging for Sarah to get an overview of the tickets with Jira IDs handled each month. How can these tickets be consolidated in one place?

To ensure seamless integration, we propose capturing Jira issue keys using custom fields in the Tickets module. This function will fetch the bug key and update it in a custom field. Based on the Jira Bug Key, you can generate a custom report.

Prerequisites:

1. Create two custom fields:

1.1 A check-box field with your desired name to trigger the workflow.
1.2 A single field with the name "Jira Issue ID" to store the Jira Issue key/ID.
To add a custom field to the Tickets layout, navigate to "Setup >> Customization >> Layouts and Fields >> Layouts >> Access the layout." Here, you can add the custom fields.For reference, please see Adding custom fields.

2. Create a Connection

To create the connection, perform the following steps:
1. Go to Setup > Connections under Developer Space
2. Click "Create Connection."
3. Select "Zoho Desk" under "Default Services"
4. Give the connection name as "jirabugkey"
5. Under Scope below values, select
      Desk.tickets.READ
      Desk.tickets.UPDATE
6. Click "Create and Connect"
7. Click "Connect" and click "Accept"
Connection is created successfully.

To create a workflow rule and associate the custom function, perform the following steps:

1. Go to Setup, under Automation, click Workflows.
2. On the left panel, under Workflows, click Rules > Create Rule.
In the Basic Information section, carry out the following steps:
3. In the Module drop-down menu, select Tickets.
4. Enter a name and description for the rule.
5. If you want to activate the rule right away, select the Active checkbox. Else, you can create the rule and activate it later on the Rules page.
6. Click Next.
In the Execute on section, perform the following steps:
7. Select "Field Update". Under this, select the check-box field created in the prerequisite (1.1).
8. Click Next, under "Criteria", select the criteria as check-box field created is "Checked".
9. In the Actions section, carry out the following steps:
10. Click the + icon under "Action" and select "New" against Custom Functions
11. Enter a name and description for the custom function.
12. Under Argument Mapping, give a desired Method name. Map the argument as below.
    12.1 In the Argument Name field, type ticketID, and from the Value drop-down list select Ticket Id under Ticket Information.
13. In the script window, input the Custom Function you find below:
Custom Function Script:
  1. deskDomain = "https://desk.zoho.com";
  2. //Replace your zoho desk URL accordingly
  3. getTicketInfo = invokeurl
  4. [
  5. url :deskDomain + "/api/v1/tickets/" + ticketID + "/jiraIssue"
  6. type :GET
  7. connection:"jirabugkey"
  8. ];
  9. if(getTicketInfo != null && getTicketInfo != "")
  10. {
  11. jiraID = getTicketInfo.get("bugKey");
  12. jsonString = {"cf":{"cf_jira_issue_id":jiraID}};
  13. updateTicket = invokeurl
  14. [
  15. url :deskDomain + "/api/v1/tickets/" + ticketID
  16. type :PATCH
  17. parameters:jsonString + ""
  18. connection:"jirabugkey"
  19. ];
  20. }
14. Click "Save" to save the custom function
15. Click "Save" again to save the workflow.

How this Function works?

Once the agent files a new issue or links an existing Jira issue with the ticket, the agent should update the check-box field created. This will trigger the custom function, fetch the Jira issue ID, and update it in the custom field.

We hope this custom function enhances your productivity towards customer support. Stay tuned  for regular updates and insights on our automation features in this space.
 


      • 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

        • Bring Zoho Shifts Capabilities into Zoho People Shift Module

          Hello Zoho People Product Team, After a deep review of the Zoho People Shift module and a direct comparison with Zoho Shifts, we would like to raise a feature request and serious concern regarding the current state of shift management in Zoho People.
        • Zoho Commerce - How To Change Blog Published Date and Author

          Hi Commerce Team, I'm discussing a project with a client who wants to move from Woo Commerce / Wordpress to Zoho Commerce. They have around 620 blog posts which will need to be migrated. I am now aware of the blog import feature and I have run some tests.
        • using the client script based on the look up filed i wnat to fetch the record details like service number , service rate

          based on selected service look up field iwant to fetch the service serial number in the serice form how i achive using client script also how i get the current date in the date field in the on load of the form
        • Quick Create needs Client Script support

          As per the title. We need client scripts to apply at a Quick Create level. We enforce logic on the form to ensure data quality, automate field values, etc. However, all this is lost when a user attempts a "Quick Create". It is disappointing because, from
        • How to block a WhatsApp user for sending spam

          Is there a way to block those whatsapp users that just come to play and annoy our service, they also spam us. We have a waba service with sales iq
        • Inquiry regarding auto-save behavior for Zoho Sign Embedded Sending

          Dear Zoho Support Team, I am currently integrating Zoho Sign's Embedded Sending functionality using iframes on my website. I would like to know if there is a way to ensure that the document state (including any added fields) is automatically saved as
        • Introducing Connected Records to bring business context to every aspect of your work in Zoho CRM for Everyone

          Hello Everyone, We are excited to unveil phase one of a powerful enhancement to CRM for Everyone - Connected Records, available only in CRM's Nextgen UI. With CRM for Everyone, businesses can onboard all customer-facing teams onto the CRM platform to
        • Automation#17: Auto-Create Tasks in Zoho Projects Upon Ticket Creation in Zoho Desk

          Hello Everyone, This edition delivers the solution to automatically create a task in Zoho Projects when a ticket is created in Zoho Desk. Zylker Resorts uses Zoho Desk for bookings and handling guest requests. Zylker resorts outsources cab bookings to
        • Automation#20 : Auto-Add Ticket Tags based on Keywords

          Hello Everyone! Welcome to unveiling custom functions on our Community series. This week's post lets you add tags to your tickets automatically based on the keywords in the ticket subject and the ticket thread. Discover how this custom function helps
        • 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
        • Email Integration - Zoho CRM - OAuth and IMAP

          Hello, We are attempting to integrate our Microsoft 365 email with Zoho CRM. We are using the documentation at Email Configuration for IMAP and POP3 (zoho.com) We use Microsoft 365 and per their recommendations (and requirements) for secure email we have
        • Uplifted homepage experience

          Hello everyone, Creating your homepage is now much easier, more visual, and more impactful. Until now, your homepage allowed you to display custom views, widgets, analytic components, and Kiosk. With the following improvements, the homepage is now a smarter,
        • Homepage not assignable to group

        • MS Teams for daily call operations

          Hello all, Our most anticipated and crucial update is finally here! Organizations using Microsoft Teams phone system can now integrate it effectively with Zoho CRM for tasks like dialling numbers and logging calls. We are enhancing our MS Teams functionality
        • Automation#22 Track Ticket Duration at Specific Status

          Hello Everyone! Welcome back to the Community Learning Series! Today, we explore how Zylker Techfix, a gadget servicing firm, boosted productivity by tracking the time spent at a particular ticket status in Zoho Desk. Zylker Techfix customized Zoho Desk’s
        • Automation#23: Automate Guided Conversations in Zoho Desk with Business Hours

          Hello Everyone, This week's edition introduces a custom function designed to automate Guided Conversations in Zoho Desk, based on your business hours. With this feature, you can align the bot's behavior with your business schedule, ensuring a smooth and
        • Address changes in quote form

          When entering a quote, the first piece of information required is the Account, which properly populates the billing and shipping address fields. Then I use the lookup function to select a contact, and when I do, the billing and shipping addresses are
        • Automation#24: Auto-Update custom field from Accounts to Tickets

          Hello Everyone! Welcome back to the Community Learning Series! This episode dives into how Zylker Techfix streamlines account-related ticket references. Previously, employees had to manually check account details to retrieve specific customer information,
        • Automation#31: Automate Splitting Names for New Contact Records

          Hello Everyone, This week, we present to you a custom function, which allows you to split the first and last names from the user's email ID based on the separator used in the ID. Having grown into a large firm, Zylker Techfix aims to optimize its processes,
        • The same Contact associated to multiple Companies - Deals

          Hi, I would like to know if there is an option to associate the same contact with multiple companies (two or more) deals, using the same contact details for all. This is because we have contacts who are linked to different companies or branches of the
        • local file csv import problem

          The issue occurs when I upload a CSV file via Databridge. In the preview, everything looks correct — the values are in the proper columns. However, after clicking Import, the first column becomes empty, and the values from that column appear in a new
        • Kaizen #227 : Client Script Support for List Page (Canvas)

          Hello everyone! Welcome to another week of Kaizen. In today's post lets see how Client Script can be used in Canvas List Page to mask sensitive information from specific roles and add colors to Canvas List Page records based on custom criteria.This use
        • Implement Date-Time-Based Triggers in Zoho Desk

          Dear Zoho Desk Support Team, We are writing to request a new feature that would allow for the creation of workflows triggered by specific date-time conditions. Currently, Zoho Desk does not provide native support for date-time-based triggers, limiting
        • Automation#25: Move Tickets to Unassigned When the Owner Is Offline

          Hello Everyone, Welcome to this week's Community Series! 'Tis the holiday season—a time when work often takes a brief pause. The holiday spirit is in full swing at Zylker Techfix too, with employees taking some well-deserved time off. During this period,
        • Automation#27: Retain Ticket Owner on Moved Tickets

          Hello Everyone! This week, we present to you a custom function that retains the ticket owner when a ticket is moved from one department to another. Here’s more to help you understand the custom function: At Zylker Techfix, Alex, the Support Engineer manages
        • 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
        • Automation#29 Retain ticket status on moved tickets

          Hello Everyone, Hear out Zylker Techfix’s Success Story on Smoother Ticket Transitions! Zylker Techfix, a gadget servicing firm committed to quick repairs and timely deliveries, faced a challenge when ticket statuses changed automatically while moving
        • encountering an error when attempting to associate an email with a Deal using the Zoho CRM extension in Zoho Mail.

          When I click "Yes, associate," the system displays an "Oops!! Something went wrong" error message. I have attached a screenshot of the issue for reference.
        • Automation#32:Auto Add New Portal Users to the Help Center User Groups

          Hello Everyone, Introducing a custom function that automates the process of adding new portal users to Help Center user groups, making user management effortless! By default, Zoho Desk allows you to assign new portal users to groups manually. But with
        • Using email "importance" as workflow-criteria

          I'd like to set up a workflow that triggers if an incoming email has been flagged as "high importance" but I'm not seeing any way to do that. Hopefully I'm just missing something obvious...?
        • Automation#34 : Automate Email threading for Ticket notification

          Hello Everyone, It's been a while since we've presented an automation. However, our community has been buzzing with ideas, use cases, and discussions with our community experts and Ask the Experts session. So, here we are again, presenting an automation
        • Automation#35 : Auto-Add Comments under the Owner's Name in Tickets via Macros

          Hello Everyone, This week's custom function provides simple steps to configure a Macro for adding comments to tickets with the name of the Comment owner. When managing tickets, you can use the Comment feature to communicate internally with your team and
        • Automation#36: Auto-create time-entry after performing the Blueprint transition

          Hello Everyone, This week’s edition focuses on configuring a custom function within Zoho Desk to streamline time tracking within the Blueprint. In this case, we create a custom field, and request the agent to enter the spending time within the single
        • Automation#33: Automate Splitting Names for Existing Contact Records

          An organized directory – who doesn't love one? Previously, we explored how to split contact names into First Name and Last Name for new contacts in Zoho Desk. But what about existing contacts already in your database? This week, we bring you a custom
        • About Meetings (Events module)

          I was working on an automation to cancel appointments in zoho flow , and in our case, we're using the Meetings module (which is called Events in API terms). But while working with it, I'm wondering what information I can display in the image where the
        • import data from Apollo.ai into zoho crm via zoho flow

          I might be asking this question in the wrong forum. We use Apollo.ai to find potential new leads for our business, there are around 10000 leads that we have initially found. We have an Apollo.ai account but just to do searches, we dont use it as a crm.
        • Fix the speed

          It takes ages to load on every step even though my dataset is quite small.
        • Workqueue

          I really like the idea of the Workqueue generally - it will be really useful. What it seems to lack however, is the ability to customise it properly. I want to be able to show a custom view rather than just "My Leads" and "Leads Assigned in Last 3 hours".
        • Webform & spam

          Hi, We set up 2 webform on our website, fowarding the content to Zoho CRM. Since it has been opened up, we are getting lot of spam message (for now about 20 a day). To lower the amount of false new leads we added the captcha field and new enquieries are
        • Zoho CRM Web form page URL

          Hi there, I am getting quite a bit of spam through my Zoho CRM Web form and want to restrict the URLs it is submittable from. I can see that I can add Location URLs but I need to be able to just add a domain so can I enter mydomain.com/* to cover all
        • Next Page