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 function that automates this process, ensuring a well-structured and easily searchable contact list.

​

Handling Existing Contacts

• On ticket creation for an existing contact, this custom function will scan the email and split the name stored in the "Last Name" field into "First Name" and "Last Name."
• To avoid unnecessary modifications, we introduce a checkbox in the contact layout. This allows you to mark contacts that have already been split, preventing duplicate actions.

Let's walk through the steps needed to ensure a smooth and error-free execution. 

I. Create a Checkbox Field in the Contacts Layout

a. Go to Setup >> Customization >> Layouts and Fields >> Select the Contacts module >> Select the layout >> Drag the checkbox field >> Give a desired name for the checkbox (e.g., Name Split).

b. Click on the gear icon of the checkbox field, select Edit Properties, and note the API name. This API name must be pasted into the custom function on line 4.

c. Uncheck the Enable by Default checkbox if it is marked.

II. Configure Custom Function within the Workflow Rule

Prerequisites

1. Create a connection

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

  1.2 Click Create Connection.

  1.3 Select Zoho OAuth under Default Connection.

  1.4 Set the connection name as deskcontact.

  1.5 Under Scope, choose the below scope values:

Desk.contacts.UPDATE

Desk.contacts.READ

  1.6 Click Create and Connect.

  1.7 Click Connect and click Accept.

Connection is created successfully.

2. Create a Workflow Rule

 2.1. Go to Setup, choose Workflows under Automation. 

 2.2 Under Workflows, click Rules >> Create Rule.

In the Basic Information section,

2.3. Select Tickets from the drop-down menu under Module.

2.4. Enter a Rule Name and Description for the rule.

2.5. If you want to activate the rule right away, select the Active checkbox. Else, create the rule and activate it later.

2.6. Click Next.

 

In the Execute on section, follow these steps:

2.7. Select Create.   

2.8. Click Next.

 

2.9. In the Criteria section, add criteria if required. click Next. 

2.10. In the Actions section, click the + icon and select New next to Custom Functions.

2.11. Enter a Name and Description for the custom function. Choose Tickets under Module.
2.12 Under Argument Mapping, give a desired Method Name. Map the arguments as below:       

         2.12.1 In the Argument Name field, type contactId and select Contact ID under the Contacts Section.                                     

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

1. //------------- User Input ----------
2. orgId = "60xxxxxxxx0"; //replace with your Org ID
3. operator = "."; 
4. checkBoxFieldAPIName = "enter_the_field_api_name"; //Enter API name of the checkbox
5. //---------------------------------
6. logs = Map();
7. try {
8. contacts = zoho.desk.getRecordById(orgId,"contacts",contactId, "deskcontact");
9. firstName = contacts.get("firstName");
10. lastName = contacts.get("lastName");
11. if(lastName.contains(operator))
12. {
13.        if(operator.contains(".")){
14.          lastName = lastName.subString(0,lastName.indexOf("@"));
15.        }
16.        firstName = lastName.subString(0,lastName.indexOf(operator)).trim();
17.        lastName = lastName.subString(lastName.indexOf(operator) + 1);
18.        updateContact = zoho.desk.update(orgId,"contacts",contactId,{"firstName":firstName,"lastName":lastName,"cf":{checkBoxFieldAPIName:true}},"deskcontact");
19.    }
20. }
21. catch (errorInfo)
22. {
23. logs.insert("errorInfo":errorInfo);
24. }
25. info "logs: \n" + logs;
26. 
    
27. if(logs.containKey("errorInfo"))
28. {
29. throws "Error happen in the CF execution";
30. }

NOTE

a. In Line 2, Enter your OrgId with  "  ". To access OrgId, go to Setup (S) >> Developer Space >> APIs >> API Authentication.

b. In Line 4, enter the API name of the check box created within the Contacts layout.  

Information

This custom function will split the contact name as First Name and Last Name based on the "." operator between the names in the email. 

2.14. Click Save to save the custom function.

2.15. Click Save again to save the workflow.

By implementing this custom function and workflow rule, you can automate the process of splitting contact names within Zoho Desk, ensuring a clean and organized database, which will enhance searchability. 

We hope this guide helps streamline your contact management! If you have any questions or need further assistance, feel free to share in the comments. Happy Organizing!

Best regards, 

Lydia |Zoho Desk

• Topic Participants

• Lydia | Zoho Desk

  

• info

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

• Using Equity Contributions To Fund Investments/Expenses?

  Hello! My partner and I just transferred over to Zoho Books and are trying to figure out how to adapt it to our business model.  We currently fund the company as individuals and utilize those funds to:  1) Cover OPEX 2) Invest in companies.  - I recorded

• Showing ALL missing data

  Hi, When I create a chart, I noticed that even when enabling the "show missing values" option, if, let's say, the current time period will not show as "0" on the chart if there's no data (rows) in the table. For example, I have this data: Week 1: 0 rows

• Using tickets to train Zia

  Hi Team, I would like to know if there is any way that Zia can also learn from previous tickets in addition to the articles from the knowledge base. Since we have most of our knowledge curerently in the tickets and that this is hard to combine into a

• How to automatically go to the bottom of a Zoho spreadsheet when opening the file

  Is there a way to open a Zoho spreadsheet and have it automatically go to the either the bottom row that contains any sort of text or formula?   It would work fine if it simply went to the "lowest" row for Column A that contains information.  I do see you can use the URL to go to a specific cell (and probably a named cell as well) but I haven't found a way to do what I'm asking.  The spreadsheets are fairly dynamic and information is added to them frequently.   Another thing that would work would

• Add more than 7 sender addresses in campaigns

  I need to add at least 15 sender email addresses but am currently limited to 7. Please can you increase. Thank you

• How to avoid outgoing emails from Zoho CRM from being treated as SPAM/Junk when arriving in an Outlook Inbox?

  I just upgraded to Zoho CRM paid version so I could use the Mass EMail feature using a simple email template I prepared. When testing this feature out, I sent emails to my Yahoo, GMail and to an Outlook EMail Inboxes. Yahoo & GMail received the messages

• Popup or Highlight on the Form based on a comparison

  I have a field for Engine Odometer, and a field for next oil change in KM. Is it possible to generate a popup, or highlight the form, if the Engine Odometer number is larger than the next oil change in KM number?

• to close auto payment system for renew my subscription. and get refund my deduct money.

  please consider and refund my money.

• Best way to automate quotes in CRM

  I am trying to take specific information from prospects/clients through Zoho Forms (contact info, square footage, surface area, etc.) and auto generate quotes based on the information submitted.  Ideally, the quote would be sent immediately after the form is submitted. I know Zoho has a few different ways to achieve this and wanted to know if there was a 'best practice' for automating the quotation function within CRM. Or if there was another app that can perform this functionality better (Zoho Commerce,

• Share passwords/secrets and folders/chambers with external users

  Currently you allow sharing passwords with internal users, internal user groups, and third parties. The third party feature gives temporary access of 30 minutes and it does not have any sign up. What we really need is to properly share secrets/passwords (and ideally folders/chambers) with Zoho Vault users that are not part of our organisation - even if they are on the free plan. If they accept the share, the password would be stored in their Zoho Vault as long as I maintain the share. If I revoke

• View Kanban tasks in "Status" layout for all projects

  Hi I'm testing Zoho Projects Express to see if it is suitable for my business. So far it looks great and seems to do everything we want (except critical path on the Gantt charts), but one thing I can't seem to figure out is this: If I go into a project, and choose "Kanban", I can select the "Status" layout which is great. I can see the status of all of the tasks in that project, and who is working on what. However, if I go to: Home > My Tasks > Kanban, then the "Status" layout isn't an option - only

• Save Draft in email bigin for desktop and mobile

  Hi any news to when we going to have the save draft for email in bigin desktop and mobile?

• Zoho Desk and Zoho Inventory

  I am hoping I am not the only one with this need but has anyone else notice the lack of integration between Zoho Desk and Zoho Inventory and eventual funneling into an Invoice in Zoho Books?  As an IT service provider we very often will sell parts (items) along with services for installing said item(s).  I have discovered that although you can integrate your Inventory Items into Desk as a "Product", it serves no real functionality.  In fact, I found the concept confusing compared to how many Service

• Including Field in email body based on answer

  I am making a form as a checklist of our mechanics. I have it setup with choice matrix. The choices are "Bad" and "Good". I would like to have only the "Bad" show up in the email body. I am not against changing how it is setup, thank you.

• Hide Zoho SalesIQ chat widget outside operating regions to optimize engagements

  Have you ever found yourself in a situation where you're receiving chat requests from locations where your business isn't operational? Having to set routing rules or manually delete chats from your logs can be tedious and time-consuming, hampering your

• Remove attachment from ticket

  Hello, When we receive e-mails from our customers, lots of those e-mails contain attachments with sensitive information, which we need to delete from the ticket after using it. It is forbidden for our company to store these attachments, due to security reasons.  Is there a possibility to delete an attachment from a ticket in any way? It is necessary for us that this possibility is available. Thanks in advance, Yorick

• CREATE REPORT USING TWO FORMS

  ONE FORM CONTAINS LIST OF ALL CLIENTS WHOSE RETURN IS FILED AND OTHER FORM CONTAINS LIST OF RETURNS FILED YEARWISE. NOW I REQUIRED A REPORT OF ALL CLIENTS WHOSE RETURN ARE PENDING FOR A PARTICULAR YEAR

• Make other sub fields mandatory, if first subfield is not empty

  I am not finding an option in the rules to make other sub fields mandatory if the first sub field is not empty. I am using the name field to collect parts info, with sub fields of Part Name, Part Number, and Quantity. But I don't want these mandatory

• Associating Multiple Work Orders with a Single Invoice in Zoho FSM

  Hello Everyone, Is it possible to associate multiple Work Orders with a single Invoice in Zoho FSM? Best Regards, Subhash Kumar

• [Webinar] Evolving BI & Analytics in the Age of AI

  Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations

• 請求書に添付されているファイルをAPI経由で取得する際の問題について

  Books APIリファレンス 現在、Books APIを利用して請求書内の添付ファイルを取得するメソッドを構築しています。以下のコードを参考にしているのですが、添付ファイルが複数アップロードされている場合、responseにおいて2つ目のファイルの情報しか取得できない現象が発生しています。 headers_data = Map(); headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");

• Zoho CRM and Books Integration

  Evening, I have started the integration with FSM from CRM and having difficulties with the mapping. In CRM we use "Unit Price" as our cost price and mark this up on a subform to create a "Sell Price" this markup can be different on each quote depending

• Zoho Flow to Azure Devops

  hi, i'm getting this when trying reauthorize the connection from Zoho Flow to Devops but when i look in Devops there is no service connection related to Zoho So i do not know where i have to renew the mentioned client secret..

• 533 Relaying disallowed

  When I try to send an email from my Zoho account, it gives me that error 533: relaying disallowed. What should I do? Please help.

• Sandbox - Your Secure Testing Space in Zoho Projects

  Managing projects often involves fine-tuning processes, setting up new automations, or making configuration changes. Making changes directly in a live environment can disrupt production as it does not leave room for trial and error. Sandbox in Zoho Projects

• Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

  Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such

• 553 relaying disallowed invalid domain

  Hi, I have read the previous article but i am still facing issue , I have added all these in my domain manager under dns settings. type : cname host: zb14521202 value / points to : validate.zoho.com Can you please tell me why i am still facing same issue

• Announcing new features in Trident for macOS (v.1.18.0)

  Hello everyone! Trident for macOS is here with interesting features and enhancements to elevate your workplace communication and productivity. Let's take a quick look at them. Retract sent emails. Whether you've missed adding an important attachment or

• Canvas View Change History

  We are trying to setup Canvas Views and it is really not a pleasant experience. It bugs a lot, some pages are just not accessible anymore and it shows that a view is just not editable because it shows a blank page, although when we open an actual record,

• Leadchain BUG

  Hello i have a problem with Facebook Leadchain. All of the information is populated correctly in the CRM, except the campaign. I want to add new leads to an existing campaign, but the lead is not added to the campaign even tough i have selected the campaign

• What is the use of the stage environment ?

  Salut, I am woundering what is the use of the stage environment. Usually, I do all the testing in developpement, and then go straight to production. The only thing I cannot test in developpement, is the result for portal users. Could the stage environment

• Workflow Automation Instant Action

  Hello All I need help to resolve this. I have created a few workflow 1. When Deal Stage is Submitted to Onboarding, it will create a record in my Onboarding Module 2. When Deal Stage is Live, It will copy $Deal.GOliveDate to $Onboarding.GoLiveDate For

• Live webinar: Transitioning from MS PowerPoint to Zoho Show

  What’s the first word that comes to mind when you think of presentations? For many, it’s PowerPoint. This has been the default for so many years that “PPT” has become a stand-in for “presentation.” But presentation needs are changing. And if you’re looking

• Assistance with Bulk Contact Import in Zoho Email Campaign

  I’m currently in the process of importing the Supermarkets customer list from Zoho Accounts into Zoho Email Campaigns. During the import, I’m being prompted to complete the "field mapping" section, but I’m unsure how to properly configure it to ensure

• Variables in Zoho Mail Signatures defined by Administrator

  Good afternoon, I'm looking at the Admin component of Zoho Mail, and I see we have the capability to define signatures for end users. We also have the ability to associate with multiple email addresses. Are we able to use any variables such as [FirstName}

• Sales Order automatic Convert to Invoice using boolean True or false

  It is possible to convert the Sales order to an invoice using a boolean field, true or false Example: I create a field in my Sales Order, I name it QBO Invoice, and the field type is Boolean, true or false. Let's say the default is false, so when I change

• Should I save dead quotes

  I work in vehicle transport, specializing in transporting vehicles for dealerships. My role involves collaborating with individuals at each dealership to facilitate the transport of their vehicles to customers and from auctions. My question is whether

• Create Full-data sandbox now in Zoho CRM

  Full-data Sandbox feature is being released in a phased manner, and is currently accessible to users of the CN (China Region) data center. Full-data Sandbox is now available for JP (Japan) DC. Full-data Sandbox is now available for SA DC. Latest Update:

• [Free introductory session] Get to know Zoho Bookings

  Hi everyone! Whether you’re just getting started or have been using Zoho Bookings for a while, there’s always something new to learn. That’s why our product experts are hosting a free live training session to help you optimize appointment scheduling for

• Free online training for Zoho Bookings

  Hi everyone! Whether you’re just getting started or have been using Zoho Bookings for a while, there’s always something new to learn. That’s why our product experts are hosting a free live training session to help you optimize appointment scheduling for

• Next Page