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, making the process time-consuming and inefficient.

To solve this, Zylker Techfix introduced a custom solution: a custom field that seamlessly syncs data between accounts and tickets. When a customer raises a ticket, the custom field in the ticket layout automatically fetches and updates values from the corresponding field in the account.

This integration has transformed their operations, enabling Zylker Techfix to map tickets to their respective accounts effortlessly. 

The result? Streamlined workflows and an improved customer service experience.

You can achieve better results in your ticketing operations, too! Here’s how to implement the custom function:

Prerequisites

1. Create a Custom Field

1.1 Go to Setup (S) >> Customization >> Layouts and Fields. Select Tickets under Layouts and the required Department. Access the active layout and add a custom field of your choice.  

1.1.1 Hover the mouse pointer over the custom field created, click on the Gear wheel icon >> Edit Properties. Note the API Name under the Edit Field. Click Update. Then, click Save and Close. 

1.2  Go to Setup (S) >> Customization >> Layouts and Fields. Select Accounts under Layouts, and in the Department drop-down, select the default department. Access the active layout and add a custom field of the same type as you have added in Tickets layout (1.1) .  

1.2.1 Hover the mouse pointer over the custom field created, click on the Gear wheel icon >> Edit Properties. Note the API Name under the Edit Field. Click Update. Then click Save and Close.     

2. Create a connection

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

      2.2 Click Create Connection.

      2.3 Select Zoho OAuth under Default Connection.

      2.4 Set the connection name as deskconnection.

      2.5 Under Scope, choose the below scope values:

             Desk.contacts.READ

             Desk.tickets.UPDATE

      2.6 Click Create and Connect.

      2.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 Tickets 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 Create.  

8. Click Next.

 

9. Leave the Criteria section blank and click Next. (Add a criteria if you require it.) 

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. In the script window, insert the Custom Function given below:

1. // ----<<<< User Inputs >>>>----
2. // -- Replace ".com" with appropriate domain extension based on customer's location/DC --- 
3. deskURL = "https://desk.zoho.com";
4. //place the corresponding API name of the custom fields from the Accounts and Tickets layout
5. accountTicketsFieldApiNameMapping = {"ACCOUNT_FIELD_API_NAME":"TICKET_FIELD_API_NAME"};
6. // ----<<<< Initial Configs >>>>----
7. logs = Map();
8. logs.insert("ticketId":ticketId);
9. updateTicketCFPayload = Map();
10. //---------------------------
11. try 
12. {
13. // ---- start your logic from here ----
14. if(accountId != null && !accountId.isEmpty())
15. {
16. primaryAccountDetail = invokeurl
17. [
18. url :deskURL + "/api/v1/accounts/" + accountId
19. type :GET
20. connection:"deskconnection"
21. ];
22. logs.insert("primaryAccountDetail":primaryAccountDetail);
23. if(primaryAccountDetail != null && primaryAccountDetail != "" && primaryAccountDetail.containsKey("cf") && primaryAccountDetail.get("cf") != null && !primaryAccountDetail.get("cf").isEmpty())
24. {
25. if(primaryAccountDetail.containsKey("cf") && primaryAccountDetail.get("cf") != null && !primaryAccountDetail.get("cf").isEmpty())
26. {
27. accountsCF = primaryAccountDetail.get("cf");
28. for each  customField in accountTicketsFieldApiNameMapping.keys()
29. {
30. if(accountsCF.containsKey(customField))
31. {
32. updateTicketCFPayload.put(accountTicketsFieldApiNameMapping.get(customField),accountsCF.get(customField));
33. }
34. }
35. logs.insert("updateTicketCFPayload":updateTicketCFPayload);
36. if(updateTicketCFPayload != null && !updateTicketCFPayload.isEmpty())
37. {
38. updateTicketPayload = {"cf":updateTicketCFPayload};
39. updateTicket = invokeurl
40. [
41. url :deskURL + "/api/v1/tickets/" + ticketId
42. type :PATCH
43. parameters:updateTicketPayload + ""
44. connection:"deskconnection"
45. ];
46. logs.insert("updateTicket":updateTicket);
47. }
48. }
49. }
50. }
51. }
52. catch (errorInfo)
53. {
54. logs.insert("errorInfo":errorInfo);
55. }
56. 
    
57. info "logs: \n" + logs;
58. 
    
59. if(logs.containKey("errorInfo"))
60. {
61.     throws "Error happen in the CF execution";
62. }

NOTE

a. In Line 2, Replace ".com" with the domain extension based on your Data Center.

b. In Line 5, add the API name of the custom field created within the Account and Tickets layout in this pattern {"cf_account_field":"cf_ticket_field"}

13. Click Edit Arguments and include the argument mapping as below: 

14.1 In the Name field, type ticketId and select TicketId under the Tickets Section, from the Value drop-down list.

14.2 Add another Name field, type accountId and select Account Id under the Accounts Section, from the Value drop-down list.

14. Click Done. 

15. Click Save to save the custom function.

16. Click Save again to save the workflow.

If you’d like to automate the updating of more custom fields between Accounts and Tickets, feel free to reach out to us at support@zohodesk.com. 

We’d love to hear how this solution works for you. Share your experience with us—your feedback inspires us to keep improving. Happy ticketing!

Until next week,

Warm regards,

Lydia | Zoho Desk 

• Topic Participants

• Lydia | Zoho Desk

  

• Sticky Posts

• Zoho Desk Virtual Meetup: US Central, October 5 - 7, 2021

  After the interactive Virtual Meetups in the other regions, we are starting with the US Central and Midwest regions from October 5 to October 7, 2021. The dates for other regions will be announced soon.  At this event, we will explore the topics which

• 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

• Ask the Experts 10: A 5-hour online Q&A on Zoho Desk Best Practices

  Welcome to Zoho Desk's Ask the Experts session! This is a monthly discussion on our  forums; wherein a panel of experts will take on questions  specific to topics related to Zoho Desk. The panel will be available for a 5-hour period and will answer any questions posted here.   Let's begin the year learning some best practices from our experts. In this month's ATE we are opening the floor to questions on how to use Zoho Desk the best way.  If you have a business use case but not sure if Workflow is

• 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. 

• Ask the Experts 7: A 5-hour online Q&A on Telephony and Call Module

  Welcome to Ask the Experts session! This is a monthly discussion in forums; each session, a panel of experts will take questions on specific topics related to Zoho Desk. The panel will be available for a 5-hour period and answer any questions posted here. In this month's Ask the Experts, we will take questions on everything related to Telephony and the Call Module in Zoho Desk. We will discuss the following aspects:  Integration with different Telephony vendors Routing calls to agents Converting

• Recent Topics

• Where are scheduled emails stored?

  After you schedule an email to go out through the CRM, how do you go about changing that scheduled email? Or even where can I see the list of emails scheduled to go out? They are not listed in my Zoho Mail account in Outbox which has been the only answer

• CRM Home Page Dashboard, how can i add zoho desk cases?

  How can i see which tickets are in my group as a dashboard component on the home tab in zoho crm? I don't see any way of adding this.

• Custom Module missing SDK function fetchRelatedRecords(...) in a Client Script

  Good day, We have added a new module with a Multi-Lookup relation to Contacts.  When we tried to use the fetchRelatedRecords(id, related_list_api_name) function to get Related Records it is missing for our new custom module. https://js.zohocdn.com/crm/5124797/documentation/DotSDK/Modules.html

• Assistance with Setting Default Values for Zoho Chat Custom Fields

  I am currently using the Zoho Chat JavaScript API to successfully add custom fields to the chat interface. While the implementation of these fields has been smooth, I am now looking to set default values for these custom fields. However, I couldn't find

• Subform Client Script

  Good day,  I have a subform where users can subscribe to various magazines. I would like to prevent the user from selecting the same magazine twice when adding a new row. Is there a way to prevent the user from doing this? (Can it be done via a client

• Serious question: Are there actually "solo-preneurs"/small business owners who made Zoho-one work well for them?

  L.S. After already many years of continued struggle with Zoho-One, I am seriously wondering if there are actually solo-preneurs (one person small business owners - without a large, dedicated IT dept.) who got it (Zoho-One) to work well for their businesses.

• Calendar Bookings in Recruit

  Hi there, We have recently started using Zoho recruit and although it has some great functionality there are a few gaps that are causing real headaches. One of those being how interviews are scheduled. The majority of our hiring managers are field based

• Getting Error : Developer Tool Detected

  Hi Team, Getting the error during open the portal, error attached on the same ticket. Please check and help us to resolve the same.

• Send Zoho Creator Template by Email or sendemail

  Hello All Question:- How we can send the Zoho creator email template using the send email by the workflow or using the Function? by the Workflow sendmail [ from: zoho.adminuserid to: "zohodeveloper@yopmail.com" subject: "Test Template" message: "Test

• Upgraded to Zoho One but Zoho Meeting still says Free Plan

  I signed-up for the Zoho One plan. When exploring the applications included, I came across a problem with Zoho Meeting. It says it's the free plan. I emailed support but they sent me a link that doesn't work and, when I found the article on my own, it

• 新年のご挨拶、直近のイベントスケジュール

  🎍🐍謹賀新年🎍🐍 ユーザーの皆さま、明けましておめでとうございます！ コミュニティチームの中野です。 本年もよろしくお願い致します。 昨年のZoho Japanコミュニティでは、東京・大阪・名古屋・福岡 4都市でのユーザー交流会開催や、自社最大イベント「Zoholics Japan 2024」でZoho Championの皆さまとのパネルディスカッション、10月の東京ユーザー交流会では本社CRMプロダクトマネージャーを招きロードマップ解説セッションの実施、さらにZohoアンバサダープログラムのローンチ（近日公開予定）など、新たな取り組みに挑戦しました。

• Request to Customize Module Bar Placement in New Zoho CRM UI

  Hello Support and Zoho Community, I've been exploring the new UI of Zoho CRM "For Everyone" and have noticed a potential concern for my users. We are accustomed to having the module names displayed across the top, which made navigation more intuitive

• Client script: Can not choose a date field for an onChange field event

  Hi Zoho Team Why can't I choose one of my date fields to trigger an onChange event? Is this a client script limitation, or something wrong with my instance? If it is a limitation, is this mentioned in the documentation anywhere? Thanks. Marcus

• Upgrade User

  Hi Sir/Madame, I have 7 users in my organisation but I need upgrade more space only 2 users. Is it possibe? Thanks

• Dashboard Auto-refresh

  Why is there no Auto-refresh on the Dashboard? People have been asking for the last 6 years for this function from what I can see in my reasearch, it seems like a very simple intergration for Zoho to achieve. on Sept. 2, 2014, this was added: Support

• Console error with widget in View mode, not present in Edit Mode with ZOHO.CRM.API.updateRecord(config)

  hello i have that function to update an account records (from a widgets created with sigma) function handleCopyButtonCRMClick() { console.log('handleCopyButtonCRMClick'); /* * Fetch Information of Record passed in PageLoad * and insert the response into

• add meeting link

  i want to add A meeting link in the mail when the user book the appointment then with the conformation mail i want to add meeting link there

• Zoho One - White Label

  Releasing a white-label feature for Zoho One, or any software or service, can offer several advantages and benefits for both the company providing the software (Zoho in this case) and its users. Here are some key reasons for releasing a white-label feature

• Missing parameters in request, any way i can figure out what parameters i need to add?

  const url = "https://people.zoho.com/people/api/forms/json/P_Task/insertRecord"; const inputData = { "Status": "Open", "Description": "Task to set up and configure Zoho Mail on desktop application.", "CreatedTime": "01-Jan-2025 10:30 AM", "Due_Date":

• Running Total % in Pivot with filters

  Hi there, I have seen a few posts on this topic, but i cant seem to find one that will work when applyig filters to the data. I have Rows and Data in a pivot view I want to show the running total of revenue as a % of the total for the data set. If i add

• Included in Zoho One?

  Will LandingPage eventually be included in Zoho One?

• Add an "Impersonate" feature to Zoho Projects

  It would be nice to have an "impersonate" feature added to Zoho Projects that would allow administrators to impersonate employees to enable administrators to see for themselves what employees can and cannot see in the system. I am aware of all of the

• Select CRM Custom Module in Zoho Creator

  I have a custom module added in Zoho CRM that I would like to link in Zoho creator.  When I add the Zoho CRM field it does not show the new module.  Is this possible?  Do i need to change something in CRM to make it accesible in Creator?

• GROUPING OF CUSTOMER

  SIR PLEASE ADD GROUPING OF CUSTOMER IN ZOHO BOOKS

• Zoho LandingPage is integrated with Zoho One!

  Greetings to the Zoho One users out there! We're delighted to let you know that Zoho LandingPage is available in Zoho One too! With Zoho LandingPage, you can host custom-made landing pages, and persuade the visitors to dive deeper by making further clicks,

• 2024 Wrap: Rediscover these features and enhancements in Zoho CRM

  Hello everyone! I wish all of you a joyful and prosperous 2025! As we welcome 2025, I’m excited to share a recap of the year 2024 and highlight some of the coolest new features and enhancements we’ve added to the Zoho CRM platform. Last year, we announced

• A quicker way to provide accountants access to Zoho Books, similar to Xero and Quickbooks

  Hey guys, I'm finding the procedure to give access to an external accountant to Zoho Books less than ideal. Having to create an account by Zoho instead of myself, and then wait for it to be given a license to then pass to the accountant seems a bit time

• This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

  Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved.  Thank you

• Update Candidate Status Through Workflow in Blueprint

  Hi Team,  We have a blueprint built out with custom functions that update particular fields based on candidate actions. When particular fields are updated we need to move the candidate forward in the blueprint. We tried to do this through a workflow,

• Zoho Canned respond do have a huge lag issue.

  Previously the Zoho canned respond works perfectly ... on once server update and all the Canned respond enconter huge lag... in the end cause most of the canned respond just shown code with /xxx and not the sentence....

• ShipStation and Zoho Inventory

  Hello, I am looking to sync zoho inventory with shipstation ZOHO INVENTORY           SHIP STATION Sales Order  ==>  create ORDERS INVOICE  <==    Shipments What exactly does BETA mean on the Shipstation connector?  This is required for me to sign-on in the next month. Thanks in advance for your efforts

• Saving slide elements

  I have created grouped items including text and animation that I want to use in later slides. (Like an animated logo) Is there a way to save these grouped elements in my library?

• Are downloadable product available in Zoho Commerce

  Hi all. We're considering switching to Zoho Commerce for our shop, but we sell software and remote services. Is there a features for downloadable products? I can't find any information about this. Thank you very much Alice

• Function #10: Update item prices automatically based on the last transaction created

  In businesses, item prices are not always fixed and can fluctuate due to various factors. If you find yourself manually adjusting the item rates every time they change, we have the ideal time-saving solution for you. In today's post, we bring you custom

• Move site from WIX to ZOHO Sites

  I have a simple website on WIX.  I am wondering if someone is available to help me move this website - https://www.videothreezero.com/ to ZOHO.  Michael  Boston

• zoho calendar week view - "super compact by default"

  every time i go to my calendar i have to re-engage the "super-compact view" for the week view...is there a way to make "super-compact" a default view so I dont have to keep on setting it manually?

• Change work hours per day for employees

  Hello, Is there a way to modify the work hours per day for employees in Zoho projects? This would be helpful for resource allocation to more accurately see when an employee who works 35 hours a week vs 40 hours has a full schedule. Thanks.

• Zoho CRM Automation Help: Send Email When Fault is Marked as Done & Module Relationships

  Hi everyone, I have the following User-Created Modules in Zoho CRM: Clients Assets Faults Handymen Every client can have multiple assets. Every asset can have multiple faults. Every fault is assigned to one handyman. What I Want to Achieve: ✅ I want to

• Adding New Domain to Zoho mail

  Hi, I have one Zoho account already called for example "Awesome Animals". Under this account I have one domain already setup with zoho mail, example: - awesomecats.com I have another website as well which I want to add under this "Awesome Animals" account,

• I cannot receive emails.

  I need help, I've tried everything but I still can't receive emails from other people. I can send it but I can't receive emails, When I created the email it was all in order and suddenly I can't get emails from anyone anymore.

• Next Page