Function-33: Create Accounts from Leads with all the data at the click of a button.

Welcome back everyone!

Last week, we learnt how to send mass emails to specific groups of leads or contacts . This week, let's look at a custom function that lets you create accounts from leads with all the data.

Business scenario:

Opportunities come in strange ways. One day there might be no good leads, but the next day you might bag a million dollar deal. Or there might be a lot of deals with smaller figures from different leads. Either way, there's a lotta work for you. And by that, I mean gathering lead details, following up with them, documenting your interactions with them and so on. If there are multiple leads, you can imagine what you're gonna go through.

At times, leads would just become contacts and there are also times where leads would be from other companies. Zoho CRM offers you the provisions to automatically create a contact from a lead, but not an account. Wouldn't it save a lot of your work and time if an Account (company) record is created with all the details, interactions and information from a lead record?

Although it is conventional process to get a lead, create a contact and then add an account for the said lead, there might arise a situation where contacts are a section that are not required. This week's function is for those scenarios.

It works in the same way as Lead to Contact conversion, but just that it's Lead to Account.

Getting started with the custom function:

1. Go to Setup > Customization > Modules > Deals > Links and buttons > Create new button.
   
2. Provide a name for the button. For example: "Create Account from Lead". Add a description(optional).
   
3. Select the placement of the button as View page.
   
4. Select the action to be performed as "Writing function".
   
5. Copy the code given below.
   
6. Click “Edit arguments”.
   
7. Enter the name as “leadId” and select the value as “Lead Id”.
   
8. Click Save&Execute Script.
   
9. Save the script.
   
10. Select the profiles who can view this button.
    
11. Click Save.
    

The script:

Code for Version 2.0 API:

leadDetails = zoho.crm.getRecordById("Leads", leadId.toLong());

accountmap = map();

accountmap.put(("Account_Name"), ifnull(leadDetails.get("Full_Name"),""));

accountmap.put("App_Out", ifnull(leadDetails.get("App Out"),""));

accountmap.put("Approved_Date", ifnull(leadDetails.get("Approved_Date"),""));

accountmap.put("Associated_MIDs", ifnull(leadDetails.get("Associated_MIDs"),""));

accountmap.put("Transaction_Fee", ifnull(leadDetails.get("Transaction_Fee"),""));

accountmap.put("Type_of_Ownership", ifnull(leadDetails.get("Type_of_Ownership"),""));

accountmap.put("Website", ifnull(leadDetails.get("Website"),""));

accountmap.put("Billing_Code", ifnull(leadDetails.get("Zip_Code"),""));

accountmap.put("Yelp", ifnull(leadDetails.get("Yelp"),""));

accountcreate = zoho.crm.create(("Accounts"), accountmap);

newacctId = (accountcreate).get("id");

RelNotes = zoho.crm.getRelatedRecords("Notes", "Leads", leadId.toLong());

for each ele in RelNotes

{

notemap = Map();

notemap.put("Parent_Id",newacctId);

notemap.put("Note_Content",note.get("Note_Content"));

notemap.put("se_module","Accounts");

notecreate = zoho.crm.create("Notes",notemap);

info notecreate;

}

TaskDetails = zoho.crm.getRelatedRecords("Tasks", "Leads", leadId.toLong());

for each ele1 in TaskDetails

{

taskMap = map();

taskMap.put("What_Id", newacctId);

taskMap.put("se_module","Accounts");

UpdateTask = zoho.crm.update("Tasks", ele1.get("id"), taskMap);

}

EventDetails = zoho.crm.getRelatedRecords("Events", "Leads", leadId.toLong());

for each ele2 in EventDetails

{

eventMap = map();

eventMap.put("What_Id", newacctId);

eventMap.put("se_module","Accounts");

UpdateEvent = zoho.crm.update("Events", ele2.get("id"), eventMap);

}

CallDetails = zoho.crm.getRelatedRecords("Calls", "Leads", leadId.toLong());

for each ele3 in CallDetails

{

callMap = map();

callMap.put("What_Id", newacctId);

callMap.put("se_module","Accounts");

UpdateCall = zoho.crm.update("Calls", ele3.get("id"), callMap);

}

return "Success";

Code for Version 1.0 API:

leadIdLong = input.leadId.toLong();

leadIdStr = input.leadId.toString();

leadDetails = zoho.crm.getRecordById("Leads", leadIdLong);

name = ((ifnull(leadDetails.get("First Name"),"")) + " ") + ifnull(leadDetails.get("Last Name"),"");

accountmap = map();

accountmap.put(("Account Name"), name);

accountmap.put("App Out", ifnull(leadDetails.get("App Out"),""));

accountmap.put("Approved Date", ifnull(leadDetails.get("Approved Date"),""));

accountmap.put("Associated MIDs", ifnull(leadDetails.get("Associated MIDs"),""));

accountmap.put("Average Monthly Processing", ifnull(leadDetails.get("Average Monthly Processing"),""));

accountmap.put("Processing", ifnull(leadDetails.get("Processing"),""));

accountmap.put("Processing Date", ifnull(leadDetails.get("Processing Date"),""));

accountmap.put("Rate Type", ifnull(leadDetails.get("Rate Type"),""));

accountmap.put("Type of Ownership", ifnull(leadDetails.get("Type of Ownership"),""));

accountmap.put("Website", ifnull(leadDetails.get("Website"),""));

accountmap.put("Billing Code", ifnull(leadDetails.get("Zip Code"),""));

accountmap.put("Yelp", ifnull(leadDetails.get("Yelp"),""));

accountcreate = zoho.crm.create(("Accounts"), accountmap);

newacctId = (accountcreate).get("Id");

RelNotes = zoho.crm.getRelatedRecords("Notes", "Leads", leadIdStr);

countVal = 0;

for each ele in RelNotes

{

countVal = (countVal + 1);

notemap = map();

notemap.put("entityId", newacctId);

notemap.put("Note Title", ifnull(ele.get("Title")," "));

notemap.put("Note Content", ifnull(ele.get("Note Content")," "));

notecreate = zoho.crm.create("Notes", notemap);

}

TaskDetails = zoho.crm.getRelatedRecords("Tasks", "Leads", leadIdStr);

for each ele1 in TaskDetails

{

TaskId = ele1.get("ACTIVITYID");

taskMap = map();

taskMap.put("SEID", newacctId);

taskMap.put("SEMODULE", ("Accounts"));

UpdateTask = zoho.crm.updateRecord("Tasks", TaskId, taskMap);

}

EventDetails = zoho.crm.getRelatedRecords("Events", "Leads", leadIdStr);

for each ele2 in EventDetails

{

eventId = ele2.get("ACTIVITYID");

eventMap = map();

eventMap.put("SEID", newacctId);

eventMap.put("SEMODULE", ("Accounts"));

UpdateEvent = zoho.crm.updateRecord("Events", eventId, eventMap);

}

CallDetails = zoho.crm.getRelatedRecords("Calls", "Leads", leadIdStr);

for each ele3 in CallDetails

{

callId = ele3.get("ACTIVITYID");

callMap = map();

callMap.put("SEID", newacctId);

callMap.put("SEMODULE", ("Accounts"));

UpdateCall = zoho.crm.updateRecord("Calls", callId, callMap);

}

}

return "Success";

----------------------------------------------------------------------------------------------------

Note:

• The code is zoho.crm._getRecordById for Version 1.0 of APIs.
  
• You can further customize by creating a custom field in leads module named "Account" or "Company". You can map this custom field to the Account name to create an account with the organization's name.
  

Found this useful? Try it out and let me know how it works! If you have questions, do not hesitate to ask! Share this with your team if you find it useful. Do check out other custom functions shared in this series here .

See you all next week with another interesting custom function. Ciao!

Update: As you must be aware, API V1.0 will be deprecated and support for version 1.0 API will be available only till Dec 31, 2018. Version 1.0 compatible Functions will continue to work until Dec 31, 2019. You're advised to migrated to API Version 2.0 at the earliest. Check this  announcement  for more. We've updated the post to include the Version 2.0 compatible Function.

• Topic Participants

• Kevin Flynn

  

• Frederic Lamoulie

  

• Sticky Posts

• How to reach the official Zoho Support channels and avoid fake ones.

  Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity.  We are happy and ready to help you use our services effectively. Understanding and avoiding fake support Just like using popular bank names and financial applications for phishing purposes, using Zoho and claiming to be providing Zoho Support or services with false numbers

• Function #35: Close all tasks associated with a lead and create a new task.

  Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is just

• Zoho CRM Webinar - Redesigning Daily User Experiences with Canvas

  <br> Your users across roles use the CRM for day-to-day tasks that are necessary. Whether they perform their tasks on time, the right way, or at all depends on a lot of factors, including User Experience. Many businesses struggle with rigid layouts,

• Join us at the Canada ZUG Meetup: What’s New in Zoho CRM

  Hello Zoho Community! Start your year with fresh insights into Zoho CRM’s latest updates and tools. Whether you're a CRM beginner or a experienced user, this meetup is crafted to help you optimise your processes and leverage new features. Explore practical

• CRM Hack #2: Automate sending of birthday greetings to your customers.

    Hello everyone! What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel,

• Recent Topics

• Incorrect “correct” password on email client apple mail

  I have troubleshot this account several times. I have deleted and re added account. It keeps saying incorrect password. Can you check that it is not locked on your end?

• Is it possible to lock editing subform rows?

  Ideally editing would only be locked after the form has been updated but I still want them to be able to add new subform records at any time and they should be able to delete rows from the subform. It is a named subform if that's relevant however the

• "Spreadsheet Mode" for Fast Bulk Edits

  One of the challenges with using Zoho Inventory is when bulk edits need to be done via the UI, and each value that needs to be changed is different. A very common use case here is price changes. Often, a price increase will need to be implemented, and

• What is the maximum file size of a video upload in Zoho chat?

  Can I upload a 20 mb video file and share it with my colleagues? 

• The Social Wall: September 2025

  Hello everyone, As we step into the fall season, some major updates are on the horizon. Meanwhile, here are the exciting updates we rolled out this September. Approvals in iOS Managing approvals just got more seamless on mobile. With this update, the

• Update a field in ALL all calls under a contact

  HI guys! I have written some deluge code to update a field in my calls after i have comepleted the call, i need this field to update in all my scheduled calls as well that are comeing up. I just cant seem to get it to work, i have put teh code below,

• MS Teams Meeting to Zoho CRM

  Has anyone figured out a good way to push MS Teams meeting info on a trigger of "meeting end" to Zoho CRM? We're looking for a way to take attendees of a meeting and meeting duration and push it into Zoho CRM after the meeting has ended. If I can just

• In place field editing for candidates

  Wondering about any insight/best practices for efficiently updating candidate records while reviewing them in a Job Opening pipeline. We can do in-field editing (e.g. update job title or City) only when we have the full candidate record open, however

• Automatic Matching from Bank Statements / Feeds

  Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these

• Verifying Zoho Mail Functionality After Switching DNS from Cloudflare to Hosting Provider

  I initially configured my domain's (https://roblaxmod.com/) email with Zoho Mail while using Cloudflare to manage my DNS records (MX, SPF, etc.). All services were working correctly. Recently, I have removed my site from Cloudflare and switched my domain's

• Fat Download of Ulaa Browser

  I just observed that Ulaa Browser is offering an one-capsule big download. These days it is a custom to offer a small bootstrap downloader and based on user customization options an appropriate download completes. And this is particularly common with

• Cancelled Transfer order problem

  Hello, We've canceled a transfer order, and we can't add the related items to a new Transfer Order. The system tells us that the bin doesn't have the required quantity, but when we check the item, it indicates that there are 2 units in the bin. It also

• Zoho Creator customer portal limitation | Zoho One

  I'm asking you all for any feedback as to the logic or reasoning behind drastically limiting portal users when Zoho already meters based on number of records. I'm a single-seat, Zoho One Enterprise license holder. If my portal users are going to add records, wouldn't that increase revenue for Zoho as that is how Creator is monetized? Why limit my customer portal to only THREE external users when more users would equate to more records being entered into the database?!? (See help ticket reply below.)

• Changing the Default Search Criteria for Finding Duplicates

  Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.

• Billing Management: #8 Usage Billing in Logistics & Delivery Services

  The logistics and delivery industry thrives on movement and precision. Every delivery completed, every kilometre driven, and every ton transported is a measurable activity. However, billing often lags behind. Many logistics companies still rely on fixed-rate

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

• Zoho sheet for desktop

  Hi is zoho sheets available for desktop version for windows

• Tags for New Tickets

  Hi there, When creating a new ticket, there is currently no way to choose a tag you would like to associate with the new ticket. Being able to associate a tag while creating a new ticket will be very beneficial as it will save time and flow well with

• Default Sorting on Related Lists

  Is it possible to set the default sorting options on the related lists. For example on the Contact Details view I have related lists for activities, emails, products cases, notes etc... currently: Activities 'created date' newest first Emails - 'created

• Experience effortless record management in CRM For Everyone with the all-new Grid View!

  Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and

• Zoho Desk: No Incoming email

  Is Zoho Desk services down? No incoming email reflect to desk tickets.

• Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

  Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

• Zoho CRM - Widgets | Update #3 : Introducing SDK V1.5 along with new ZDK Methods and ZRC Support

  Hello everyone! Widgets in Zoho CRM just got a big upgrade! With the release of SDK v1.5, developers can now create more immersive widget experiences. This update elevates Widget development with new ZDK methods for easier interactivity and ZRC support

• How to update "Lead Status" to more than 100 records

  Hello Zoho CRM, How do I update "Lead Status" to more than 100 records at once? To give you a background, these leads were uploaded or Imported at once but the lead status record was incorrectly chosen. So since there was a way to quickly add records in the system no matter how many they are, we are also wondering if there is a quicker way to update these records to the correct "Lead Status". I hope our concern makes sense and that there will be a fix for it. All the best, Jonathan

• Unusual activity detected, account blocked

  I am unable to send emails and am getting the error "Outgoing blocked: Unusual activity detected. To unblock your account, please and submit a request. Learn more.". I am unsure as to why this is happening since all my activity is legitimate, mainly confirmation

• Unlock agreement intelligence with Zoho Sign's latest AI updates

  Hello! If you've been struggling with long, complex agreements and spending way too much time on them, here's exactly what you'll want to hear: Zoho Sign now integrates with OpenAI's ChatGPT to make agreement management smarter and simpler. Acting like

• Unable to Send Emails – Outgoing Mail Blocked (Error 554 5.1.8)

  Description: Hello Zoho Support Team, I am facing an issue with my Zoho Mail account ( admin@osamarahmani.tech ). Whenever I try to send an email, I get the following error: 554 5.1.8 Email Outgoing Blocked I would like to clarify that I have not done

• Issue connecting Zoho Mail to Thunderbird (IMAP/SMTP authentication error)

  Dear Zoho Support, I am trying to configure my Zoho Mail account on Thunderbird, but I keep getting authentication errors. Account: info@baktradingtn.com Domain: baktradingtn.com Settings used: IMAP: imap.zoho.com, Port 993, SSL/TLS, Normal Password SMTP:

• Payment issue with Mail Lite plan – personal NIF not accepted as payment info

  Hello, I have already contacted Zoho Support by email regarding this, but since I haven’t received any reply yet, I’m sharing it here as well to see if the community can help. I’m facing a payment issue for my Mail Lite plan. I have a personal account

• Customer payment alerts in Zoho Cliq

  For businesses that depend on cash flow, payment updates are essential for operational decision-making and go beyond simple accounting entries. The sales team needs to be notified when invoices are cleared so that upcoming orders can be released. In contrast,

• {"code":1038,"message":"JSON is not well formed"}

  Today this began failing: sales_order_data = zoho.books.createRecord("salesorders",books_organization_ID,order_data); with this error message. {"code":1038,"message":"JSON is not well formed"} This code has been running for two years. Here is the input

• In arattai received message can't be deleted

  The issue has been noticed in following: arattai app (Android) arattai app (Window) arattai web While the message posted by me may be deleted, the ones received from others can't be. The item <Delete> change to <Report> when the message is a received

• Zoho Editor

  Zoho PDf Editor is not working I am clicking on EDIT PDf then it again bringing me back to the same page. again and again.

• Figma in Zoho Creator

  Hi Team, I’m creating a form using Figma and would like to know how to add workflows like scheduling, custom validation, and other logic to it. Can anyone help me understand how to set this up for a Figma-based Creator UI form?

• How to Delete Personal Account Linked with My Mobile Number in past or by someone else

  How to Delete Account Created with My Mobile Number in past or by someone else This is creating issues in making or sync with my credentials mobile and email address..

• Enable / show scroll bar when Mega Menu is opened

  Hey there I am using the mega menu add-on and experience a "flicker" whenever the mega menu opens. The reason is, that the scrollbar, which has a width of a few pixels, stops showing when the mega menu opens. As the scrollbar disappears the whole page

• Restore lost Invoice!

  Some time ago I tried to Upgrade from Invoice to Books. I not upgraded and staid n Invoice. Now i tried again and first i deleted the old trial of books. But now all is gone, PLEASE HELP!! i have no backup and i have to have at least 7 years data retention by law. 

• Zoho Desk Down

  Not loading

• lookup and integrated forms

  I might be misunderstanding things but I wanted to integrate our zoho crm contacts into creator. I imagined that when I used the integration it would mirror into creator. It did brilliant. BUT We have a ticket form in creator that we want to use a lookup

• Partially receive PO without partial Bill?

  Most of our inventory is pre-paid. Let's say we purchase 30 pieces of 3 different items for a total of 90 pieces. It is common for our supplier to send us the items as they are ready. So we will receive 30 pieces at a time. How can I partially receive

• Next Page