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, data management, and organization. By default, contacts are created by extracting the customers' names from the email addresses and saving them in the "Last Name" field in the Customers' module. 

To create an organized directory, Zylker Techfix wanted to separate the first and last names from the email address using the (.) separator in the email ID. 
This custom function allowed them to achieve this with their contacts. Now, you can organize your contacts within Zoho Desk too.

Follow the steps below to configure the 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 Disable the toggle for User Credentials of Login User.

  1.6 Under Scope, choose the below scope values:

Desk.contacts.UPDATE

Desk.contacts.READ

  1.7 Click Create and Connect.

  1.8 Click Connect and click Accept.

Connection is created successfully.

Create a Workflow Rule

1. Go to Setup(S), choose Workflows under Automation. 

2. Under Workflows, click Create Rule.

In the Basic Information section,

3. Select Contacts 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. In the Criteria section, add criteria if required. click Next.
 

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

11. Under Basic Information, enter Name and Description for the custom function. Choose Contacts under Module.
12. Under Argument Mapping, give a desired Method Name. Map the arguments as below: 
       12.1 In the Argument Name field, type contactId and select Contact ID under the Contacts Section.                                

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

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

NOTE

a. In Line 2, Enter your OrgId with  "  ".

To access OrgId, go to Setup (S) >> Developer Space >> APIs >> API Authentication.

14. Click Save to save the custom function.

15. Click Save again to save the workflow.

Context

Once configured, this function splits the first and last names for incoming new contacts. This custom function applies to new contacts and new incoming tickets.

​

We hope this custom function helps you manage your contacts efficiently. Share your feedback and connect with us for more tips and insights. 

See you next week!

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

• Zoho Writer - Option to Export as .zdoc format

  I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become

• Is it possible for contacts to "Re-enter" a workflow in Zoho Campaign?

  We are currently working on a way to automatically add users to from one list to other lists based on specific criteria, but can't seem to find a native way of doing this so we are trying to use Workflows to do this. So, for example, if a user's status is set to "Active," then they should be added to the list "Active Users." If the same user's status is then set to "Paused," they should be added to the list "Paused Users" and removed from the list "Active Users." This works fine for the first go

• Bulk upload images and specifications to products

  Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.

• Out of Office for Just One of My Alias Email

  Can I set up the Out of Office Reply for Just One of my Alias Email Addresses?

• Can I map multiple Surveys into the CRM using the same fields?

  Hello, We are a healthcare practice that offers two distinct services (Nutrition and Primary Care). We use Zoho Survey for our lead generation form (Get Started Survey), which allows people to express interest in one of the two services and even allows

• Dealing with API responses where integers have more than 16 digits

  Hi there How do I deal with an api response contaning an int or float with more than 16 digits (before any decimal places for a float). I constantly receive the response "Unable to cast the 'BigInteger' value into a 'BIGINT' value because the input is

• Can't change form's original name in URL

  Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new

• Need Inactive accounts to be visible in Reports in Zoho Books

  I N=need Inactive accounts to be visible in Reports in Zoho Books to do recons of the accounts but when i see the same they are not visible in the Accountant - Account Transactions report

• unblock e-mail

  please unblock my e-mails info@meatnews.gr and myrtokaterini@meatnews.gr

• Add Zoho Mail for users who do not need Zoho One

  We have licenses for ZOho One for teams that need to use the suite of products that Zoho One offers.  We have 8 more people who only need email access and we would like to add just a Zoho Mail.  They do not need the Zoho One license.  We are currently

• ZML vs HTML Snippet - which is better?

  Are there certain use cases where one is better than the other?

• Auto CheckOut Based On Shift.

  This Deluge script runs on a scheduled basis to automatically set the 'Actual_Check_Out' time for employees who haven't manually checked out. If the current time is past their scheduled 'Shift_End_Time', the script updates the check-out time to match

• How to remove some users in zoho accounts

  How to remove some users in Zoho accounts.

• Infinite loop of account verification

  Hi I can't do anything on my zoho account.  I always get this message Hi Sheriffo Ceesay As a security measure, you need to link your phone number with this account and verify it to proceed further. When ever I supply the details, it displays that the number is associated with another account. I don't have any other account on zoho so this is really annoying. 

• Load PO_Date field (Purchase Order) with current date in Deluge

  Hi, I'm not a full time developer, just helping to customize our CRM, in the small company I work for. There must be something wrong with me, because I can't do something so simple as complete a field with the current date in a function using Deluge.

• Zoho CRM in Microsoft Power Automate Custom Connector

  Hi everyone, I’m building a Power Automate flow that integrates Microsoft Bookings with Zoho CRM. The goal is to automatically create a meeting (event) in Zoho CRM whenever a new appointment is booked via Microsoft Bookings. To achieve this, I created

• Spell check sucks

  Come on guys, it's 2024 and your spell check is completely retarded. You gotta fix it.

• How to include total km for multiple trips in expense report.

  Whenever I create a mileage report it only shows the total dollar amount to be reimbursed. The mileage for each individual trip is included but I also need to see the total distance for all trips in a report? How do I do this?

• Outgoing blocked: Unusual activity detected.

  I just made payment for my Zohomail Today and have been debited so i will like to be Unblocked because this is what it says (Outgoing blocked: Unusual activity detected) Thank you i await your swift responses

• Zoho One Login Issue - Unable to receive OTP

  Hi Support Team, I am experiencing a unique login issue with Zoho One. I am attempting to log in from India using Zoho Login credentials provided by a USA-based client. Their Zoho account is hosted on a US data center. After entering the username and

• Question Regarding Managing Sale Items in Zoho Books

  Good day, I was wondering about something. Right now, Zoho Books doesn’t seem to have a way to flag certain items as being on sale. For example, if I want a list of specific items to be on sale from October 1 to October 12, the user would have to export

• In the Zoho Creator Customer Payment form i Have customer field on select of the field Data want to fetch from the invoice from based on the customer name In the Customer Payment form i Have subf

  In the Zoho Creator Customer Payment form i Have customer field on select of the field Data want to fetch from the invoice from based on the customer name In the Customer Payment form i Have subform update Invoice , there i have date field,Invoice number

• Problem of Import Client Users From CRM and or Expense

  I am premium plan user on Projects. I have about 500 customers on Expense and CRM that integrated with each other. According to at below link, I am trying to import clients from CRM, system not allowed to select any customer. If I import from Expense,

• Unable to see free plan option

  Hello Zoho Support Team, I hope you are doing well. I am trying to sign up for Zoho Mail, but I am unable to see the option for the free plan. Could you please guide me on how I can access or activate the free plan? Thank you for your assistance.

• unblock my zoho mail account. outlines@zoho.com

  please unblock my zoho mail account, outlines@zoho.com

• domain not verified error

  Hi when i try to upload a video from zoho creator widget to zoho work drive iam getting domain not verified error.I don't know what to do .In zoho api console this is my home page url https://creatorapp.zoho.com/ and this is my redirect url:www.google.com.Iam

• equest to Disassociate Bigin from Zoho One and Migrate to Standalone (Upgrade to Bigin Premier – 3 Seats, Annual)

  Dear Zoho One Support Team, I’m writing to request your assistance to disassociate (remove) the Bigin application from our Zoho One organization while preserving all existing Bigin data. After the disconnection is successfully completed, we intend to

• SMTP email sending problem

  Hello, I've sent emails before, but you haven't responded. Please respond. My work is being disrupted. I can't send emails via SMTP. Initially, there were no problems, but now I'm constantly receiving 550 bounce errors. I can't use the service I paid

• billing

  hi, I am being billed $12/year, and I can't remember why. My User ID is 691273115 Thanks for your help, --Kitty Pearl

• How to add receipts

  How to add receipts

• Unable to enable tax checkboxes

  Hi Zoho Commerce Support, I'm writing to report an issue I'm having with the tax settings in my Zoho Commerce store. I've created several tax rates under Settings > Taxes, but all of them appear with the checkbox disabled. When I try to enable a checkbox,

• Zoho Commerce - Enable Company Name and Tax Number collection for B2B orders in Global Edition

  Please enable Company Name and Tax Details option on checkout settings in Zoho Commerce Global Edition. It is still important to collect Company Name and Tax Number for B2B sales in many countries. My business is based in Ireland (in the EU) and I have

• ZohoSign and ZohoBooks Integration/Workflow

  Hello All, We utilize ZohoSign for signatures on tax eFiles. We utilize Dynamic KBA. Additionally, we use ZohoBooks for invoicing for these services. Is there a way to accomplish the following: Send a copy of the Tax Return, Invoice and eFiles in one

• Manage monthly tasks with projectsf

  Hi All I run a finance and operations team where we need both teams to complete monthly tasks to ensure we hit our deadlines. Can Zoho projects be used for this. There many finance focused tools but we have Zoho one so want to explore Thanks Will

• Zoho Suite is very slow

  Since today Zoho is incredibly slow over all applications! What's going on?

• How can I track which zoho users are actively using Zoho CRM

  I have several licenses of Zoho CRM. We now need to add a new user. I could purchase a new license, but before I do, I would like to see if any of our existing users are not actively using the license assigned to them. How can I determine the activity

• Is anyone else having trouble saving a custom image in their email signature, or is it just me?

  When I try to save the image I get an error that says "Operation Failed" I opened a support ticket two weeks ago and received a response that it would be debugged, but it still isn’t working

• Combine and hide invoice lines

  In quickbooks we are able to create a invoice line that combines and hides invoices lines below. eg. Brochure design         $1000 (total of lines below, the client can see this line) Graphic Design           $600 (hidden but entered to reporting and

• Transaction Locking with the dynamic date

  Is it possible to dynamically update dates on transaction locking. We want to lock transaction x days from today

• Zoho Devops

  We have a Zoho one account which we have integrated with an SAS educational product, sold on a subscription model, using webhooks and API calls. We make some use of custom fields and cross module lookups and relationships. We utilize CRM, Books and billing

• Next Page