Function for Emails tranfer from Lead to Deal
Hi
Due to the fact that my Deals conversion needs to be done in 2 ways - depending on the fact if those records already exists or not - resources in fields are different.
I am making function control conversation for Leads but I have problem with transferring email communication to Deal.
Here's a detailed explanation of the code and its functionality:
/**
* Function: LeadAktualizacjaKontaktFirmaPrzeniesienieDzialanNaDealaV1
* Purpose: Converts a Lead to a Deal and transfers all related emails to the new Deal
*
* Main operations:
* 1. Creates a new Deal from Lead data
* 2. Finds all emails related to the Lead
* 3. Updates email associations to point to the new Deal
*
* @param leadId - The ID of the Lead to be converted
*/
void automation.LeadAktualizacjaKontaktFirmaPrzeniesienieDzialanNaDealaV1(String leadId)
{
try
{
// Deklaracja wszystkich zmiennych
leadData = null;
kontakt = null;
firma = null;
dealName = null;
dealOwner = null;
leadOwner = null;
dealMap = Map();
newDeal = null;
dealId = null;
emailList = null;
emailIdVal = null;
updateMap = null;
updateResult = null;
eml = null;
// Pobranie danych leada
leadData = zoho.crm.getRecordById("Leads",leadId);
if(leadData.isEmpty())
{
info "BŁĄD: Lead o ID " + leadId + " nie został znaleziony.";
return;
}
kontakt = leadData.get("Kontakt_w_bazie");
firma = leadData.get("Firma_w_bazie");
dealName = leadData.get("Pods_Nazwa_Firmy");
dealOwner = leadData.get("Dla_Salesa");
leadOwner = leadData.get("Owner");
dealMap.put("Deal_Name",dealName);
dealMap.put("Account_Name",firma.get("id"));
dealMap.put("Contact_Name",kontakt.get("id"));
dealMap.put("Stage","Spotkania");
dealMap.put("Pipeline","Standard");
dealMap.put("Owner",dealOwner);
dealMap.put("Created_By",leadOwner);
dealMap.put("Lead_provided_by",leadOwner);
if(leadData.get("Lead_Source") != null)
{
dealMap.put("Lead_Source",leadData.get("Lead_Source"));
}
if(leadData.get("TTP_rezultat") != null)
{
dealMap.put("TTP_result",leadData.get("TTP_rezultat"));
}
if(leadData.get("Istniejaca_centrala") != null)
{
dealMap.put("Centrala",leadData.get("Istniejaca_centrala"));
}
if(leadData.get("E_hardware") != null)
{
dealMap.put("Wartosc_hardware",leadData.get("E_hardware"));
}
info "========= START TWORZENIA DEALA I PRZENOSZENIA MAILI =========";
info "Rozpoczęto dla leada: " + leadId;
info "Tworzę Deal z danymi: " + dealMap.toString();
newDeal = zoho.crm.createRecord("Deals",dealMap);
if(newDeal.get("id") == null)
{
info "BŁĄD: Nie udało się stworzyć Deala";
return;
}
dealId = newDeal.get("id");
info "✓ Utworzony Deal ID: " + dealId;
info "--- Przenoszenie emaili ---";
emailList = zoho.crm.searchRecords("Emails","(Lead_Id:equals:" + leadId + ")");
if(emailList != null && !emailList.isEmpty())
{
info "Debug: Liczba znalezionych emaili: " + emailList.size();
for each eml in emailList
{
try
{
if(eml != null)
{
info "Debug: Struktura emaila: " + eml.toString();
// Próbujemy pobrać ID bezpośrednio
emailIdVal = eml.get("id");
if(emailIdVal != null)
{
updateMap = Map();
updateMap.put("What_Id",dealId);
updateMap.put("$se_module","Deals");
info "Debug: Próba aktualizacji emaila o ID: " + emailIdVal;
updateResult = zoho.crm.updateRecord("Emails",emailIdVal,updateMap);
if(updateResult != null && updateResult.get("id") != null)
{
info "✓ Email " + emailIdVal + " przeniesiony";
}
else
{
info "Błąd: Nie udało się zaktualizować emaila " + emailIdVal;
}
}
else
{
info "Błąd: Nie znaleziono ID dla emaila";
}
}
}
catch(e)
{
info "BŁĄD przenoszenia emaila: " + e.toString();
info "Debug: Szczegóły emaila powodującego błąd: " + eml.toString();
}
}
}
else
{
info "Nie znaleziono żadnych emaili do przeniesienia";
}
info "========= ZAKOŃCZONO TWORZENIE DEALA I PRZENOSZENIE MAILI =========";
}
catch (ex)
{
info "Wystąpił błąd główny: " + ex.toString();
}
}
Here's what each part of the code does:
1. **Lead Data Retrieval and Deal Creation**:
- Retrieves Lead data using `zoho.crm.getRecordById("Leads", leadId)`
- Extracts important fields: Contact, Company, Deal Name, Deal Owner, etc.
- Creates a Deal Map with required fields:
```javascript
dealMap.put("Deal_Name", dealName);
dealMap.put("Account_Name", firma.get("id"));
dealMap.put("Contact_Name", kontakt.get("id"));
dealMap.put("Stage", "Spotkania");
dealMap.put("Pipeline", "Standard");
// ... other fields
```
- Creates a new Deal record using `zoho.crm.createRecord("Deals", dealMap)`
2. **Email Migration**:
- Searches for related emails using `searchRecords`:
```javascript
emailList = zoho.crm.searchRecords("Emails", "(Lead_Id:equals:" + leadId + ")");
```
- This search should return all emails associated with the Lead
3. **Email Association Update**:
- For each found email, attempts to:
- Get the email's ID
- Create an update map with new Deal association:
```javascript
updateMap.put("What_Id", dealId);
updateMap.put("$se_module", "Deals");
```
- Update the email record to point to the new Deal using `zoho.crm.updateRecord("Emails", emailIdVal, updateMap)`
**Current Issues**:
1. The email search returns records (4 emails found), but we're having trouble accessing the email ID field
2. The update operation fails due to data type issues with the email ID
**Requirements for Zoho Support**:
1. Need to confirm the correct field name for email ID in the search results
2. Need guidance on the correct way to update email associations when converting from Lead to Deal
3. Need to understand if there are any specific data type requirements for the email ID when updating records
**Test Results**:
========= START DEAL CREATION AND EMAIL TRANSFER =========
Started for lead: 751364000004048409
Creating Deal with data: {"Deal_Name":"Account Name","Account_Name":"751364000002639001","Contact_Name":"751364000004048395","Stage":"Meetings","Pipeline":"Standard","Owner":{"name":"Artur Sznek","id":"751364000000551001"},"Created_By":{"name":"Name","id":"751364000000416001","email":"k******.*****@*****.com"},"Lead_provided_by":{"name":"Name","id":"751364000000416001","email":"k******.*****@*****.com"},"TTP_result":232,"Central":"234","Hardware_value":72364}
✓ Created Deal ID: 751364000004185020
--- Email Transfer ---
Debug: Number of emails found: 4
ERROR transferring email: Error at line : 66
ERROR transferring email: Error at line : 69
========= DEAL CREATION AND EMAIL TRANSFER COMPLETED =========
Could you please help with:
1. The correct way to access email IDs from search results
2. The proper data type for email IDs when updating records
3. Any specific requirements for updating email associations in Zoho CRM
The code is functional for Deal creation but needs assistance with the email transfer portion.
Thank you in advance for help
kochnik
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Katarzyna
Pheranda Nongpiur
Sticky Posts
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 suchCustom Function : Automatically send the Quote to the related contact
Scenario: Automatically send the Quote to the related contact. We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please followFunction #50: Schedule Calls to records
Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRMFunction #37: Create a Purchase Order from a Quote
Welcome back everyone! Last week, we learnt how to calculate the total number of activities for a lead and further take note of the activity count for particular dates. For instance, from the period of Demo to Negotiation. This week, let's look at a function that lets you create a Purchase Order instantly from a Quote. Business scenario: In any form of business, one of the most important things to do is to document the transactions. Naturally, negotiation, signing an agreement, placing an order,Function-2: Round-Robin assignment of records
Welcome back folks! Last week, we saw how to update sales commission in quotes using a custom function. This week, let's see an interesting use case asked by many of you - auto-assignment records by round-robin method. Business scenario: Right now, the solution allows you to auto-assign leads from web form and imported lists. Let us look at a need where you want to auto-assign leads from in-bound calls in a round-robin method, across modules. Prerequisite: You must create a permanent record in the
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Subform edits don't appear in parent record timeline?
Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a userCRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive
Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage filesZoho Learn vs. Trainer Central
Hi, I'm currently using Zoho One with a WordPress-based website and WooCommerce to manage my online courses. I would like to know what is the difference between Zoho Learn and Trainer Central and if it's possible for these two platforms to replace WPHow to Display a Logo Image on a Public Form?
I would like to display a logo image in the header of a form. To achieve this, I added an Add Notes field to the form. The code below works perfectly for Zoho users accessing the form. However, when the form is made public, the image does not load properly:Clear String field based on the value of other field
Hello everyone, We would like to be able to clear a string field (delete whatever has been written and make it empty) when another field (picklist) is changed to a specific value. While I can empty other types of fields, I noticed that I can't do thisCreating a Zoho Online Meeting in a Blueprint
We are looking for an easy solution to schedule online meetings in a blueprint and ran into the same problem discussed in this topic: https://help.zoho.com/portal/en/community/topic/custom-function-to-set-meeting-to-online-meeting (After connecting ZohoEnabling 'From Number' and 'To Number' fields in the Calls module
Hello everyone, We've added "To Number" and "From Number" fields in the Calls module as part of our latest update to provide users with the option to enable or disable them through the Calls Preferences tab. When enabled, these fields will be displayedExciting Update: Multi WhatsApp Business Account (WABA) Support Now Available in SalesIQ!
We’re pleased to share an important update that will enhance the way you manage your WhatsApp Business accounts (WABAs) within SalesIQ. With the launch of Multi WABA support, you can now connect and manage multiple brands more effectively, each underRoute Optimizer
Does Zoho Inventory offer route optimization for our in-house deliveries? It will save us time to manually route our daily orders. Thank youCan documents attached to different ZohoForms automatically go to different OneDrive folders?
Hi there, I set a workflow to track and store applications coming in from our website. I created two different Zoho forms, one for unsolicited applications, one for applications to job postings. After any of the forms has been filled in, a new recordKaizen #126 - Circuits in Zoho CRM - Part 1
Hello everyone! Welcome back to another week of Kaizen! Today, we will discuss an exciting topic—Circuits in Zoho CRM. For starters, we will discuss what Circuits are, how beneficial they are for businesses, different views of a Circuit, and the differentMail is no longer populating CRM contacts
Hi! For the last few days, my mail hasn't been populating my CRM contacts. Even people I email multiple times per day. In fact, it keeps trying to send mail to myself. Notice, I started typing Amy and only got as far as, "Am" and it suggested myself.Custom field doesn't fill when converting sales order to invoice
Hi, When I convert a Sales Order to an Invoice one of the custom fields on a product line names "Subsidie" does not seem to fill in automatically. I manually have to select the product again by clicking on the product name in the order line en re-selectTeamInbox down?
Hi everyone, we are getting message "Sorry, this action cannot be performed due to an internal error. Please try again later. We are on the Canadian data centers. Can someone please confirm if the service is down? Thank you! FIncrease subscription prices for existing subscriptions
Hi, Does anyone know how we could achieve the ability to increase the subscription fee for our existing customers based on a % increase. We are not yet using Zoho Billing (Subscriptions) and I'm not sure if it is a good fit for us. But we would need toPurchase Requisition in Zoho Books
I want to understand if Zoho Books is having the following workflow: PR ( Purchase Requisition ) >> PO ( Purchase order) >> GRN/SRN ( Goods/Services receipt note) >> BillStop adding Default ID column to xls exports
When anything is exported to xls, Zoho adds a column with an ID. WE DO NOT WANT THIS COLUMN. We use an automated report to a team. We have our own tracking number. 1. This makes the report messy, it just pushes OUR data off to the right. 2. We haveConfirmation prompt before a custom button action is triggered
Have you ever created a custom button and just hoped that you/your users are prompted first to confirm the action? Well, Zoho knows this concept. For example, in blueprint, whenever we want to advance to the next state by clicking the transition, it isMarketer's Space: Streamline marketing and sales by integrating ZMA's Planner with Zoho CRM
In a competitive market, clear goal-setting and seamless campaign execution are crucial for marketing and sales alignment. When integrated with Zoho CRM, Zoho Marketing Automation's Planner enables marketers to create, manage, and measure campaigns effectivelyCustom emails for Portals not working
I changed the standard templates to custom email templates for all three options, but the invitation is still sending the original email layouts. Anyone know why this would be happening? I changed them 2 days ago.Switching scheduled webinars from Live to On-demand
Now that On-Demand webinars has been added as an option for webinar presenting, is there a way I can edit already scheduled webinars from Live to on-Demand? These scheduled webinars already have people registered. ThanksZoho CRM v2.1 deprecation or sunset plans ?
Hi Team Wanted to know if there is any plan to deprecate v2.1 CRM apis https://www.zoho.com/crm/developer/docs/api/v2.1/ and if yes by whenForex Bank Refund Entry
Hello, please advise how to enter refunds from our bank forex department. The refund was because we were on preferential rates but at the time of USD purchase were not given the preferential rate, therefore the bank calculated the excess that we paidAuto-Populating Custom Field
This is to request a feature enhancement for our invoicing system. We're currently creating invoices with a single item per invoice and have a custom field called "Related Vehicle." We would like the "Related Vehicle" field to be automatically populatedHow can i Customize Delivery Note?
I need to customize delivery note like change the tittle for language purposes and also include only the balance dueDelivery note template
We have some reasonable templates for sales docs but the delivery note one is very limited. It would be nice if we could have the same options as the sales form templates or even create our own by cloning an existing sales template, modifying (ie: removingINTERCOMPANIES INVOICING
Dears , I paid expenses on behalf of our sister company from my cash account , then month End i issued an invoice to the sister company , my question is how to put the expenses GL in the invoicesHow to Add Break line / Return on button click
I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work. i expected result something like this ali baba but got this ali \r\n <br> baba so, how can iZoho CRM Theme Color?
I've read multiple articles stating it's possible to change Zoho CRM theme colour (top menu bar) from personal settings menu, however, my zoho has no options for this at all and I've looked everywhere........has this feature been removed? I'm currentlyHow can i force the user to select a project when creating an invoice ?
Hello I tried all the ways that i know , but no way is able to stop creating an invoice without project.Sales
1/ How can I make a discount on invoice exmple : invoice 5,100 le , custmar pay 5000 and I need to make this 100 le as a discount , how can i make it ?! 2/ Is thare any report can make me match my company’s balance with the customer’s balance?Include Project Hours when Creating Estimates from Projects
Hi Currently, in Books, you can create estimates from Projects by inserting tasks that pull both the task and the hourly charge rate. But it doesn't pull the budgeted hours for the task, so you manually have to remember the number of hours for a givenacc
Regularly sending statements to customers is an imperative part of many business processes as it helps foster strong customer relationships and provides timely guidance on pay//South African Payment Gateways
Since the "Demise" of Wave many South African users have moved over to Zoho and yet for years users have been requesting Integration with a South African Payment Gateway to no avail. Payfast was the most commonly requested gateway as it supports recurringCalendly does not show scheduled Meetings
I use Calendly as my standard booking tool, but no matter what I am doing, Calendly shows any appointment as free (when in fact there already is an appointment in CRM Calendar or Zoho Calendar). Drives me nuts - cannot go away from Calendly due to variousCRM Implementation
I need to implement Zoho CRM. Is there a useful user manual available to guide me through the implementation?Automate data upload process like reports
I'll start with the end in mind. I want to basically keep certain creator tables updated with data that are in a sql database/tables in our office (employees, active jobs, employee positions) so I can reference that data and not have to duplicate it by hand every time someone adds a new job or employee in the office desktop software. Here are some thoughts I had about how to do this, but am unsure as to whether any of them are actually possible and how to go about it from there: Is there any wayZoho Creator Upcoming Updates - December 2024
Hi all, We're excited to be back with the latest updates and developments on the Creator platform. Here's what we're going over this month: Deluge AI assistance Rapid error messages in Deluge editor QR code & barcode generator Expandable RTF and multiZoho Social integration with Zoho Flow
Is there any plans for Zoho Social integration with Zoho Flow?Custom API - Need to create a string return value, not only MAP
@Support: When creating a Custom API it only allows a return from a function of MAP type. The service I'm using requires a string return, how can this be achieved?Next Page