CRM
I have a portal set up where a contact can see other contacts within an account automatically. When a contact in the portal enters a deal, how do I make sure that deal is assigned to the account so other contacts in the account can see the deal was generated?
Merge field support in Field Update
Hi, We have a use case that requires values of certain custom fields in Deals to be copied back to corresponding custom fields in Contacts module whenever those fields are changed in Deals. The field update action on Workflow rules doesn't allow specifying
Circuite fail because www.zohoapis.com:443 refuse conection
Is anyone else experiencing this issue? A few weeks ago, I started having issues with circuits failing due to www.zohoapis.com:443 refusing the connection. The error message is quite clear and points to a problem on Zoho's API server, rather than with
Custom Related List anchor tag with tel protocol
The following code worked great for about a year to create clickable tel and mailto links in a related list in the Deals module. Just this morning, it started displaying the HTML as text. For example: <a href='tel:8882490100'>8882490100</a> Zoho support
Kaizen #182 - Queries in Canvas List View
Hello everyone! Welcome to another week of Kaizen! We're back with another post in this series on Queries in Canvas List View. Queries in Zoho CRM allow you to dynamically retrieve data from CRM as well as third-party services directly within the CRM
Issue with Zoho CRM DELUGE Search – No Results Returned
Hi, I’m trying to run the following code, but it returns nothing. I have 4 records where the Next_Date field has the value "OK". I tried changing the date format to different types, like "2025-01-01", but I still get no results. Can you help me understand
Problem with currency field in Zoho CRM
Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
Levenshtein Distance in Zoho Deluge (Because Why Not?)
Ever wanted to run a Levenshtein Distance algorithm inside Zoho Deluge? No? Me neither, but I did it anyway. I built a fully functional fuzzy matching system inside Zoho, brute-forcing a dynamic programming solution using Maps and recursive list generation.
Difference between the 'field_read_only' and 'read_only' fields exposed by the Fields Meta Data API.
The API documentation describes the 'field_read_only' field to indicate that a field is read-only always, implying that no user can ever get the write access for this field. The 'read_only' field's description states that its value can change depending
ZOHO CRM API Python SDK Convert Quote to Sales Order
I can see footprints that this may be possible through Inventory Conversion. But I am unable to locate any specific details or samples on how to do this. I am using the most current Python SDK. Any support or even sample code would be much appreciated
Kaizen #181 - Mandating Subform Data for Blueprint Transitions using Widget
Hello Developers! Welcome back to another week of Kaizen! This time, we are tackling a common challenge on how to enforce subform data from a different module before allowing a blueprint transition in Zoho CRM Deals module. Many CRM workflows require
Client Script $Crm.user.role returning undefined
Hey all! I have a client script I'm trying to run based off of the user's role. I'm able to use the following: var fname = $Crm.user.first_name; To properly return a first name when logging in the console, but whenever I try the same with $Crm.user.role
brackets to be used in COQL's Where.
I use version 7 COQL to get Deals. It seems that I need to properly enclose the criteria in brackets in the Where, but I don't know the criteria to enclose them. I need to specify quite a few criteria in Where, so I would like a clear explanation. I am
Kaizen #2 - OAuth2.0 and Self Client #API
Hi everyone! Welcome back to another week of Kaizen! In this post, we will shed some light on the OAuth2.0 protocol and how you can use Zoho's Self Client option to authenticate your application and generate the tokens. What is OAuth2.0? OAuth 2.0 is an industry standard protocol specification that enables third-party applications (clients) to gain delegated access to protected resources in Zoho via an API. Why should we use OAuth2.0? Clients are not required to support password authentication or
Kaizen #91: Dynamic Lookup filters using Client Script
Hello everyone! Welcome back to another captivating Kaizen post. In this post, we will explore the process of implementing lookup filters using Client Script. What is a dynamic lookup filter? A dynamic lookup filter is a feature that allows you to specify
setVisibility() not working for Subform Fields with Client Script
I am currently working on a Zoho CRM Client Script involving a subform and encountered a limitation that hinders my ability to fully control the visibility of specific fields within subform rows. The setVisibility() method, which works perfectly fine
Does Client Script work on Zoho CRM Portal?
Hi ! I create a new module to use at customer portal. But Client Script looks not work. Please help me clarify, thank you!
Authorization Issue While Fetching Items from Zoho
I am facing an issue while retrieving items from Zoho. The error message states that we are not authorized to perform this operation. We have tested this with different domains as well as with different Data Centers, but the issue persists. Despite ensuring
Canvas Blueprint - Refresh/Reload Section
I have a blueprint on a Detail canvas in CRM. When one of the blueprint buttons is pressed, the blueprint actions take place as normal but the actual blueprint options on the canvas dont change until the screen is refreshed. This doesn't happen when in
View As <Profile Name> for development
It would be great if we could have the ability to view a CRM as a particular profile other than the one that's assigned to the user account. Unless this feature already exists, we could quickly switch between profiles to validate field and module permissions,
Kaizen #180: Automating Data Transfer from Zoho Sheets to Zoho CRM Subforms
Hello everyone! Welcome back to another exciting Kaizen post! This time, we will discuss the solution for a use case—leveraging Client Scripts and Functions to get the job done efficiently by integrating with Zoho Sheets. In this kaizen post, Handling
Meeting schedule proposal
We are currently working on creating meeting invites for Outlook through Zoho Deluge. However, we have encountered an issue when a client sends a proposal for a new meeting schedule. In this case, we are only receiving the status of whether the client
Form and CRM Email Template url processing and/or prefill broke
Hi All, I have an open ticket with Zoho support on this, but it's so urgent I hope I can get help here, too. Today something in the Form data collection url processing broke and there were zero changes made by yours truly that touched any part of the
Has Anyone Else Built a State Machine into a Function?
I'm in the process of building a state machine for lead lifecycle management within Zoho CRM, and I'm curious if anyone else has tried integrating a state machine into their Deluge functions, especially considering Zoho’s 12-function cap. I’ve managed
How would you improve this lead life cycle scheduled function?
void schedule.IntegratedLeadProcessing() { // STEP 1: Retrieve Leads from CRM leads = zoho.crm.getRecords("Leads",1,200); if(leads == null || leads.size() == 0) { return; } // STEP 2: Process Timeline Engagement & Update Lead Status currentDate = zoho.currentdate.toDate();
API method to convert a Quote into a SalesOrder ?
Hi, We need to convert a Quote into a SalesOrder using the Zoho CRM API but this action doesn't seem to be available ? (cf online doc). It's strange because the conversion from Lead to Account is available. Is there a convertQuote available ? If not,
Kaizen 179: Choosing between ZDK CLI and Web UI : When to Use Each
Hello everyone, Welcome back! ZDK CLI uses commands to manipulate with Zoho CRM metadata from a terminal. While Zoho CRM Web UI remains the primary tool for manipulating Zoho CRM metadata like creating modules, configuring fields/layouts etc., using ZDK
Issue with COQL Query for Retrieving Notes via Zoho CRM API V7
Hello, I am currently working on a COQL query to retrieve Notes associated with Deal records via the Zoho CRM API V7. However, I am not receiving any response. When I used the V6 API, I did receive a response. Below is the COQL query I am using to fetch
Deluge Converting issue in File Upload of Excel Format to Xlsx in Subfrom
Scenario: In the Lead module, there is a File Upload field and a Subform. When an Excel file in CSV format is uploaded to the File Upload field, a Deluge script runs to read the document and transfer the data to the Subform using a client script on the
Kaizen #161: Global Sets using Zoho CRM APIs
Hello all! In this week, we will see how to work on the Global Sets using our Zoho CRM APIs. Global Picklist APIs were introduced in Zoho CRM API version 6. In this post, we will cover the following Global Sets in Zoho CRM Advantages of the Global Sets
Kaizen #177: Duplicate Check Preferences API vs. Upsert API
Hello all!!! Welcome back to another week of Kaizen. Last week, we discussed Optimizing the Use of Record ID Variables in Zoho CRM Queries. This week, we will explore two important APIs for managing duplicate records in Zoho CRM - Duplicate Check Preferences
Fetch record based on last modified time in zoho crm
Hi I have created a script in php in which I get Account name from zoho and store in database. I have created one more field last_modified_time in database. It will keep current time stamp by default. It is updated automatically when any action is performed on database. I want to get only data from zoho whose modified time is greater than last_modified_time in database. So I used last Modified Time function to fetch the data but it is not working for me. In php, I have created a function getdatafromzoho()
Error due to - 'Internal Exception' when uploading Sign-generated PDF file to workdrive via Deluge in Zoho CRM
Hi I wasnt getting this error a few days ago and my code had not changed, so I'm wondering if there's a Zoho bug somewhere? I am downloading a PDF file from a Zoho Sign url using invokeurl and then uploading it to a Workdrive folder using zoho.workdrive.uploadFile.
Kaizen #99 - Render Widgets Using Client Script
Hello everyone! Welcome back to another interesting post. In this post, let us see how you can render Widgets using Client Script. Widgets are embeddable UI components that you can create and add to your Zoho CRM. You can use widgets to perform functions
Kaizen #178 - Filters & Criteria in Zoho CRM APIs
Hey everyone, and welcome back to another week of Kaizen! Ever felt overwhelmed by the sheer volume of data in your Zoho CRM? Sifting through countless records to find exactly what you need, or to operate on specific records that meet a certain criteria,
Client Script - onBeforeUpdate, how to get the new value of picklist
Basically, I have "Contact Type" field, and if a particular type is selected from within Canvas detail page, I want it to show a popup warning. I have all of this working, except that getvalue on the particular field in question shows the currently saved
ZDC Hackathon 2024 Category-wise Winners !
Zoho CRM Client Script Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho CRM Client Script – Product Category award for their outstanding innovations! Team 1:
Trying to copy Active Leads to a Custom Module called Dead Leads
Hi, I am trying to code when the "Active Lead Status" field is changed to "Dead", a copy of the record should be created in the "Dead Leads" module while keeping the original lead in "Active Leads." I am using the following code but I keep getting the
Mass Action Button Script
Hi all, I've been trying to search a lot of places for a solution on how to do a button placed at the "Mass Action Menu" and thus only updating multiple CHOSEN records at once. After finding no success whatsoever, I decided to just run and test whatever
Lookup Field Values In BulkRead
I am pulling cases from the Zoho Case module using the BulkRead API. However, I am receiving IDs (random numbers) as field values. I later discovered that if I include column_name.Name in the returned fields, I get the actual value. However, this approach
Next Page