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

• help, 554 5.1.8 blocked

  got this blockade, i don't know why?

• Not Receiving Emails from Gmail, but Other Providers Work Fine

  Hello, I'm experiencing an issue where my Zoho Mail account does not receive any emails sent from Gmail addresses. However, I can successfully receive emails from other providers such as Hotmail and Yahoo. There are no problems with sending emails—I'm

• Basic String Search Not Possible in CRM Deluge – Feature Request or Workaround?

  Hi all, I’m trying to solve what should be a very basic automation task in Zoho CRM Deluge: Find the first 11-digit number anywhere in a string (specifically an email subject). In almost any programming language—even 1980s BASIC!—this is a trivial loop:

• Reencaminhamento de e-mails.

  Boa tarde, gostaria de saber se tem a possibilidade de realizar o reencaminhamento de um e-mail especifico. Ex. Eu recebo alguns e-mails de um remetente e gostaria que o meu amigo de trabalho também recebesse esse e-mail, somente deste destinatário, é

• Knowledge base articles is now available in the Zoho Desk mobile app!

  Hello all,   As a customer service agent, every day you might have to deal with many questions and issues reported by the users. With Knowledge Base, you can reduce the issue resolution life cycle for your organization.   We are delighted to announce that we have brought in support for 'Knowledge Base articles' in the Zoho Desk iOS mobile app.  This feature is already available for Android users.   KB articles are available to iOS users in the latest version of the app (v2.4.9). You can update the

• Set Default Payment Method & Default account

  Hi, I would like to know how to set the default payment method and default bank account when recording payments in zoho books. At present we have to change these fields everytime we record a payment, which leads to potential error and as we have a very

• More than one "Other" response in a Multiple Choice (Many Answers) question type?

  Is there a way to have more than one "Other (Please Specify)" with a short response as an option to a Multiple Choice (Many Answers) question? I understand there may be other ways, but I am looking for this way specifically as it would be best for the

• Zoho Surveys

  Dear Zoho Support Team, I hope this message finds you well. I am writing to inquire about the availability and documentation for the Zoho Survey API. Background: I am currently working on a project that requires programmatic access to survey data and

• Help Needed: Jira to Zoho Projects Migration — Tickets Imported as Unassigned & Comments Under Admin Name

  Hi Zoho Team and Community, We recently completed a migration from Jira to Zoho Projects using the official import method outlined in this Zoho Help Article. Issue Summary: We had already added all users to Zoho Projects before the migration, using the

• Zoho Finance Estimate to Deal Attachment

  Hi, I'm trying to fetch estimate pdf from zoho books and upload it as deal attachment without success. any tips how to achieve this?

• Journeys - how do i branch on contact call result

  Hi all. I want to branch based on the Call result field in contacts. Any idea how I can do this? Also what is the best way to have this condition checked at each step? Thanks!

• The 3.1 biggest problems with Kiosk right now

  I can see a lot of promise in Kiosk, but it currently has limited functionality that makes it a bit of an ugly duckling. It's great at some things, but woeful at others, meaning people must rely on multiple tools within CRM for their business processes.

• Perform custom actions from the Ticket interface using Buttons

  Hello everyone, We have introduced an option to add Buttons to the tickets, which will facilitate direct access to other applications, websites, allows execution of custom workflows, and more. Accessibility and visibility of buttons The buttons can be

• Inserting a video from library in microsite

  Hello, We have uploaded videos in our space library. We created a new event and want to use the videos in our main page our microsite. It's possible to selected image from the library, but no videos. Only URL are accepted, but videos in library have no

• UUIDs

  Has anyone coded a Universal Unique Identifier (UUID) generator in Deluge?

• Create Tasks in arbitrary Zoho Project triggered from CRM [Zoho Projects]

  Community, hello What I'm trying to do is to create a Zoho Project when a Deal is created in CRM and then to be able to add tasks to this Project also from Zoho CRM with the trigger (Blueprint/ Workflow). I succeeded in creating Project using Zoho Flow,

• Invalid Client - Client ID passed does not exist

  Hi, Daniel here. i try to generate an authorization code by following this page Authorization Request - Web Apps - OAuth | Zoho Accounts https://accounts.zoho.com/oauth/v2/auth?scope=ZohoCRM.users.ALL&client_id=1000.myclientid&response_type=code&access_type=offline&redirect_uri=https://localhost:7195/account/integrations/zoho/tokencallback

• Generate Token v2 api using c# sdk

  Hello I am trying to generate a access token using c# sdk but fails every time.is there any sample code so that i can implement that code to insertleads in crm.  my use case is i want to insert and update lead in zoho crm. when user signup in my website i insert the detail of that user in crm using API v1. but V2 api is more confusing that API v1 . so please can anyone provide me a sample code of c# sdk to generate token and insert lead in crm. Or is there any way to achieve this without using c#

• Upsert your missing data without affecting the historic logs

  Dear Customers, We hope you're well! Migrating your data from a legacy system to Zoho CRM is a critical operation as it deals with treasured data. In an unfortunate event, if you have missed to move your historical datasets, you have had to repeat the

• Dashboard won't save, nor allow me to do a "save as"

  For some reason, one of my dashboards won't let me make any modifications to it and save?  I get the "do you want to save before closing?' and I say yes and the dialogue box just stays there.  I try to do a "save as" right after I open that dashboard and I get the dialogue box that seems to let me name the new dashboard, but it won't let me save.  The dialogue box just stays there unless I hit cancel or no. Can you please help? Jamie

• Copying Files Between Modules

  Hi, I'm creating a Deluge script and I've hit a roadblock. I'm trying to copy files from one module (let’s call it Module A) into another one (Module B). Here’s what I’m doing: record = zoho.crm.getRecordById("Module_A", record_id); files_toCopy = record.get("Files_From_A");

• Problem with scheduled report sending in Zoho Analytics

  Problem with scheduled report sending in Zoho Analytics. Reports are not sent due to size. How can I increase it?

• 【Zohocreator】ログについて

  ワークフローのDelugeスクリプトのinfo関数が出力するログはどこから見れますか？

• US military addresses

  When we have a client with a US military address having them fill in a form is a problem Zoho forms doesnt acommodate them correctly. It doesn't make sense for me to have to create a secondary data model for military addresses. I have placed some links

• Introduction of Robotics Process Automation in Zoho products

  It will be great if Zoho can start advancing from automation to robotics process automation. For a start, it can be started with smart document understanding. Provide OCR engines Google cloud, Microsoft Azure Computer vision OCR, Microsoft OCR, Omnipage

• 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

• Zoho Sigma and Catalyst IPs for Whitelist

  Hi there, We are developing a series of integrations between Zoho CRM and Zoho Desk with an on-premises system for a customer and they have firewall rules to access their server, so they are requesting the list of IPs addresses for our backend calls,

• 【開催報告】大阪 ユーザー交流会 2025/6/5 Zoho サービスを活用して業務をアップデート

  皆さま、こんにちは。コミュニティチームの中野です。 6/5（木）に、大阪 ユーザー交流会 を開催しました。本投稿では、その様子をお届けします。 当日の登壇資料などもこちらに共有しますので、参加できなかった皆さまもご参照ください。 （Zoho社員セッションの登壇資料については、8月に開催する福岡 ユーザー交流会の開催報告で共有予定です。） 今年初の開催となる大阪 ユーザー交流会では、akippa株式会社 内藤さんによるZoho CRM / Forms の事例セッションのほか、 「見込み客・顧客データの管理/活用方法」をテーマに、参加者同士でZohoサービス

• Moving forward, can we change our reports to send record ID's by default?

  With the new policy of not including record ID's in reports, is there a way to default to including them in my reports as they used to be?

• WhatsApp integration isn't very useful at all (no workflow support)

  We have set up WhatsApp through Business Messaging. It works, but there appears to be no workflow support for messages that are sent/received! Without being able to trigger a workflow when an inbound message is received, my colleagues would have to manually

• Zoho CRM 差し込み文書テンプレート if文

  Zoho CRM の差し込み文書のテンプレートを作成しています。 フッターにページが 2ページになる場合は、「次葉へ」と言う文字を表示したいのですが、ページ数による判断はできないのでしょうか？ 現在はサブフォームの行数で判断しているのですが、複数サブフォームを差し込んでいるので、合計何行で2ページ目になるのか把握が難しく、ページ数で判断できればうれしいなと思い、質問させていただきます。 ※行総数はワークフローでレコード保存時にカスタム関数でサブフォームの行数をカウントして数値を保存しています。

• Record payment: Payment Mode vs. Deposit To and how to "connect" them!?

  How do we set up that when we choose:  "Payment Mode"= Cash, then "Deposit to" is automatically set to Petty Cash, and if we choose  "Payment Mode"= Check, then "Deposit to" is automatically set to Undeposited Checks, and if we choose  "Payment Mode"=

• Allow split times for business hours feature

  It would be great to be able to set business hours multiple times during the same day. For example: Monday from 9am - 1pm, and then from 2pm - 5pm This would allow calls to be sent straight to voicemail during 1pm-2pm during lunch break.

• Add Knowledge Base KB Articles to multiple categories

  Greetings, Love you help center system. One item that would be incredibly helpful to many of us would be able to add a single Knowledge Base KB article to multiple categories in our system. It seems it could be quite easy to use a checkbox form, instead

• Peppol integration zoho invoicefu

  Hi, Belgium will require Peppol invoicing as of 2026. I found that this is being prepared for Zoho books, to be released in Sep 2025. Will Zoho Invoice get this functionality too? I like the Invoice app for my part-time side business as bike mechanic

• Error in formula

  Can someone PLEASE tell me what is wrong with this formula? Formula return type, I have tried string and decimal fn.Year(fn.Now())-fn.Year(${cf_purchase_date}) I keep getting the following error. Incorrect argument type passed for function Year Thanks

• Sync “Display Author Info” Setting from Zoho Desk to Zoho SalesIQ

  Dear Zoho SalesIQ Team, We’d like to suggest a refinement to how Zoho SalesIQ displays knowledge base articles that are synced from Zoho Desk. Current Behavior Zoho Desk allows us to control whether author information (name, profile picture, etc.) is

• Respect Help Center Visibility Settings for Knowledge Base Sync Between Zoho

  Dear Zoho SalesIQ Team, We’d like to suggest an important improvement to the integration between Zoho Desk and Zoho SalesIQ with regard to the knowledge base synchronization. Current Behavior SalesIQ offers excellent functionality by allowing us to sync

• Enhancing Answer Bot's Capabilities

  Wouldn't it be amazing if the answer bot could directly search for answers in our database, FAQs, articles, etc., without needing to display the entire article? without relying on external tools like ChatGPT This way, it could provide concise and relevant

• Centralize and Streamline Zobot and Flow Control Settings in Zoho SalesIQ

  Dear Zoho SalesIQ Team, We would like to suggest a crucial improvement to the current setup and configuration experience within SalesIQ. Problem Statement Zoho SalesIQ currently offers three primary mechanisms for handling customer chats: Answer Bot –

• Next Page