Automation #11 - Auto Update Custom Fields with Values from Emails

This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips to optimize your customer support with the automation capabilities of Zoho Desk.

With the help of Custom fields in Zoho Desk you can extract context that is specific to your business. For example, a travel company might want their customers to enter PNR numbers while submitting their tickets. Or, a product manufacturing company may have a mandatory field for serial numbers in the add ticket form.

 

But when your customers send in emails with vital information like Order numbers and PNR numbers listed in the email content, extracting it to add it to the custom fields can be a challenge. Here's an automation designed to help you sidestep this challenge. It extracts specific context from the email content and updates the custom fields automatically.

 

Let's take the example of "Order Number" to understand how we can achieve this automation.

 

You may recall how we replaced Auth-tokens with Connections for all the existing custom functions. So the first step to making the most of ZohoDesk's automation capabilities is to create a connection to be used in the custom function later.

 

To create a  connection, carry out the following steps: 

1. Click on Setup > Developer Space > Connections 
   
2. Click Create Connection
   
3. In the Pick Your Service section, under Pre-Defined Services find and select Zoho OAuth
   
4. In the Connection Details section, add zohodesk as the Connection Name and Connection LinkName
   
5. In the Choose Scopes list, select all values that start with 'Desk.' and ending with '.ALL' and then include Desk.search.READ, Desk.products.READ
   
6. Click Create and Connect
   
7. In the page that appears, click Connect
   
8. If you have more than one portal associated, select the Portal to which this connection should be added and click Accept. 
   

Say you receive an email with the content: 

Order Number: 4345312

Contact Name: Sundar

To extract the value of the Order Number from the above email, proceed with these steps: 

1. Go to Setup, and 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 just create the rule now and activate it later, on the Rules page.
   
6. Click Next.
   In the Execute on section, perform the following steps:
7. Select the Create checkbox to execute this rule every time a new ticket is created. 
   
8. Click Next.
   In the Criteria section, do not select any criteria and move to the next section.
   In the Actions section, carry out the following steps:
9. Click the + icon and select Custom Functions > New
   
10. Click Edit Arguments
    
11. In the Name field type TicketID, and from the Value drop-down list select Ticket Id under Ticket Information.
    
12. In the script window, input the Custom Function you find below:
    orgId = "paste orgId here";
    fromWord = "Order Number:";
    toWord = "Contact Name:";
    lenfromWord = fromWord.length();
    T_Info = invokeurl
    [
    url :"https://desk.zoho.com/api/v1/tickets/" + TicketID + "/latestThread?include=plainText"
    type :GET
    connection:"zohodesk"
    ];
    plainText = T_Info.getJSON("plainText");
    orderNumber = plainText.subText(plainText.indexOf(fromWord) + lenfromWord ,plainText.indexOf(toWord));
    updateTicket = zoho.desk.update(orgId,"tickets",TicketID,{"cf":{"cf_order_number":orderNumber}});
    info updateTicket;

Once the steps are completed, the value will be updated in a custom field named Order Number and the API name of the field that is cf_order_number. For other business scenarios, you can replace "Order Number" with other keywords that describe the specific values you need to extract.

 

 

 

 

 

• Topic Participants

• Chinmayee Mishra

  

• matt.jantzi

• Ash | Zoho Desk

  

• Robert Darrow

• Nicole

• 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

• 6 time-saving tips for working with tables in Zoho Writer

  Tables have always been the best way to represent data. They help you structure and categorize information systematically and present them in a simpler way. While tables in Zoho Writer are easy to implement, some tasks might not be that obvious.  Here are some time-saving tips to help you work better with tables in Zoho Writer:    1. Insert Multiple Rows / Columns in a Table Adding more rows and columns is the most common action performed while working with tables. Instead of using the Table tab,

• Add Built-in "Partner Finder" / "Contractor Directory" Tab to Zoho Desk Help

  Hi Zoho Team, We hope you're doing well. We would like to request a new feature for the Zoho Desk Help Center: A built-in, configurable "Partner Finder" / "Contractor Directory" tab or section, similar in concept to your own Zoho Partner Finder at: 🔗

• Can't get sender adress to work

  Hi, I am having some trouble getting the sender adress to work for responses on tickets. I would like to configure a sender adress that is different from the zohodesk emailadress that is normally used. These are the steps I have followed: 1. Add a new

• Question Regarding Deleted Reports in Zoho Desk Analytics

  Dear Zoho Desk Support Team, I hope this message finds you well. We have a question regarding the Analytics module in Zoho Desk, specifically related to deleted reports/dashboards. We would like to understand the following: Is there a recycle bin, recovery

• Add an option to start zobot when user clicks the Chat with Us button

  I would like to have an option to start the zobot when user clicks on "Chat with us" button when chat widget is maximized that way visitors could see first the homepage and decide which channel they would like to use to connect, or to see the quicke help

• Zoho Books - Feature Request - Provide "Show PDF View" toggle on Invoice records

  I have noticed it is possible to activate or deactivate the PDF preview on some records but not all. This would be very helpful on Invoices when a custom template is being used and the PDF preview does not represent the output file. Not available on:

• Incorrect Handling of XLSX data

  Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. format

• Disable Smart Filters By Default

  The smart filters "feature" is causing confusion for Zoho Mail users. New emails should be delivered to the inbox unless they have specifically opted to redirect them somewhere else. People don't understand that new emails might be waiting in a random

• Adding Columns to Reports

  Hi, Is it possible to choose fields to be added as columns in the reports? Thank you.

• How do I automatically assign the project owner for all tasks in Zoho Projects?

  I have been researching for days on how to automatically assign all the tasks to the project owner on creation of the project in Zoho Projects. I have been having to go in and manually change all the task owner from 'unassigned' to the owner of the project

• CRM Kiosk - Action for GetRecords

  I have a Kiosk screen with GetRecords and want to use the selected records in a custom function. My particular case is to set a lookup value on the selected records. Generally speaking though, I want to work with the selected records in a function. I

• Extract Archived Projects using Zoho Projects API

  In my organization we archive the projects when they are already completed, charged, invoiced, so that only those that are still pending process remain active. I need to access all projects (active and archived) from an external system, but the API v3

• Email for customer to provide payment information

  Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?

• Unable to display field label from a hidden Single Line Textbox in Description

  Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, and

• Lookup fields

  Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules

• Zoho Analytics - Bill Table

  Hi I am new to Zoho and mainly work in Books. Recently learned of Zoho Analytics and am exploring it to create reports that would be useful for me. For example, I want to create a bills cash forecast by week for cash flow planning. When I start to create

• Creating a tax - amount table in Analytics

  Hi everyone, I would like to create a report in Zoho Anayltics that creates the tax and amounts in a table. I have been able to create a report that shows me all the tax accounts, but I can't get it combined with the amounts of the accounts. Is there

• Is it possible to do custom domains on test accounts that use saml setups?

  In Zoho Billing, Is it possible to do custom domains on test accounts that use saml setups for the customer portal?

• I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API.

  Hi Zoho Team, I’m facing an issue while trying to upload a PDF file to a custom file upload field within the Leads module via the Zoho CRM API. I am able to manually upload a PDF into this field through the UI. I am also able to upload files as attachments

• No chat option

  Chat option is not available in Android app.

• How to add custom templates in zoho sheets mobile

  How can I add custom templates in Zoho spreadsheet mobile?

• Order Items

  Hi .. We have to implement orders with line but each line should have a separate record and not as a subform, does anyone have experience with that kind of solution what is the best practice for that kind of thing Thanks

• Trello: Invalid Client - Client ID passed does not exist

  Hello, I am trying to authorize the Zoho CRM power-up in Trello but always land on the following page: I tried adding a trello client to the Zoho API console but this generated a different client ID to the one in the link of the page in the above picture.

• Zoho Sprints - Q2 updates for 2025

  Hello everyone! We’re excited to share the latest updates from Zoho Sprints for Q2 2025! This quarter, we rolled out a few highly-requested features designed to enhance collaboration and time management across your projects. Here's a look back at the

• CRM Email Insights Not Working - Status not Changing

  I used to be able to see if a customer opened/read an email in CRM, but I no longer get those status changes inside their record. I have everything enabled and I am sending the email from CRM. The experience center has the status' enabled as well. Any

• The use of Ticket statuses

  When your support team mark a ticket "Closed" before I had a time to check what your team has done on the ticket - I have to consider this as you consider the ticket closed even if I dont consider it closed. Which automatically produce a negative sentiment.

• "Replace" an existing version of CRM

  Hi all, I have a question, I saw an article about this once, but I now cannot find it. I am working with a client who has had their CRM in Zoho One built and extensively modified. But it is non-functional now, and rather than try and unpick the system,

• Data Import From a private PostgreSQL RDS Instance

  Hello All, I feel like the problem I am experiencing has been seen before; however, I am having a difficult time finding any solutions. Hoping the community has some insights. I am trying to import data from a PostgreSQL RDS instance that is behind an

• Assistance Required: Authentication Error When Sending Credit Application Form

  Hi, I'm encountering an error message that states: "Authentication unsuccessful – the user credentials were incorrect." This occurs when I attempt to send the credit application form to our customers. I've attached the form I’m trying to send for your

• Missing Fields in Lead Conversion Mapping

  I’ve been using Zoho CRM since 2013 to manage leads and convert them into contacts and jobs. When I convert a lead to a customer, I create a new contact and a job. Previously, this process automatically transferred key information from the lead to the

• Allow selection of select inactive users in User data fields

  Hello, We sometimes need to select a previous employee that has an inactive account in the User data field. For example, when doing database cleanup and indicating actions are done by a certain employee that weren't filled out when they were part of the

• Connection to Zoho One

  My org has a Zoho One account, which includes Zoho Social. We are wanting to try linkthread. However, I want to make sure it is set up properly from an account perspective, as I have accidentally created Zoho accounts separate from Zoho One when I didn't

• Ticket Automatically Created from Closed Chat

  Is there a way to prevent a ticket being create for every chat.... or at the very least have it automatically closed.

• IMPORT INVOICES CSV

  Hi, Impossible to import invoices in Zoho books with a csv file. I have also tried with the template. My topic keeps getting closed but I did not get any answer Is there an issue with this fonctionnality ?

• Related Lists in Email Templates

  Hi Zoho team, I would love to see a feature where related list information can easily be added to an email template (instead of mail merge). I have a client who books flights for their customers. They do this through a Flights module so all booked flights

• Outlook plugin funktioniert nicht.

  DAs Outlook Plugin funktioniert nicht mehr. Ich werde aufgefordert, mich mit der App "OneAuth" anzumelden Intelligente Anmeldung per OneAuth funktioniert nicht zufreidenstellend. Nach erfolgreicher Anmeldungung mittels QR Code lande ich wieder beim QR

• iOS App Version 3.0 - Customer list gone?

  Not sure when this changed, but I seem to have been updated to 3.0 for the phone app (on iOS). I'm pretty sure that I used to have a Customers button that allowed me, for example, to see what appointments a customer has. Has this disappeared or am I just

• Zoho Signature, "For Demo Purpose Only Powered by Zoho Sign"

  How to disable this text on the documents for signature. "For Demo Purpose Only Powered by Zoho Sign"

• Add Resource variable to notification email customisation for Event Type

  The notification email customisation feature for Event Type does not include a variable for the Resource field. Without this field, Zoho Bookings cannot be used by any business for resource-based services or event types e.g. room bookings, equipment bookings.

• Can't find add role button, is iet st because I have the free subscription

  Trying to add my accountant in Zoho Books if I press the add accountant button, I get stuck as it says no such role exists, and won't let me continue, I can't find the add roles button, so I am stuck. Is it because I have the free subscription? Also can't

• Next Page