Kaizen #100 - A Special Q & A for Our 100th Post

Hello Everyone! 

Today marks a significant milestone – our 100th Kaizen post! We are beyond thrilled to have shared this journey with you!  Your engagement, feedback, and support have been pushing us forward. Thank you! 

We recently asked you for your feedback on our Kaizen series through this form, and we are so grateful for the thoughtful responses we received. We asked, and you answered! We are excited to share our answers to some of your questions in our 100th Kaizen post.

1. Please add a function to get the API Name of the field that caused the onChange in the page processing. For example, if I want to do an automatic string modification process, I cannot get the field name changed by the user, so I have to do the process for all fields, which is slow. That said, setting it up in "Item Processing" is difficult if there are a lot of items and is not very maintainable. 

To get the API Name of the field that cause onChange event in a page, you can simply use the field_name argument.

To get the API Name of the field that cause onChange event in a page, you can simply use the field_name argument.

In Client Script, based on the event that you configure, you can use the appropriate arguments while you code the script. Click here to know the arguments available for various event types. 

Now let us execute the above log script for create page of Leads module using the Run component.

In the below gif, you can see that for every field that the user enters data, the log statement will give the api name of the corresponding field updated by the user.

Note:

The field_name argument for onChange Page event is available for Create, Clone, Edit, Create(Wizard), Edit(Wizard), Detail Page(Canvas)

For a scenario where there are requirements for multiple fields present in the same page, let us see how to write a single Client Script efficiently. Check the Best Practices of Client Script documentation for more details.

At Zylker, a manufacturing company, consider that you want to achieve the following using Client Script. In the create page of Orders module, whenever the field Product is Ignition box, Category should get auto-populated as Ignition System. If the Product is Voltmeter then Category should get auto-populated as Gauges and meters.

Whenever the user edits or adds the Phone Number with length less than 10, display an error message near the field. If the field Country is India, the maximum number of digits that the user can enter the field Phone Number should be limited to 10. 

Instead of creating 3 separate Client Scripts with field event , you can create a single Client Script with onChange Page event.

You can use the "field_name" argument to check which field was changed by the user.

Here is the Script.

switch (field_name) {     case 'Product':         var product_name = ZDK.Page.getField('Product').getValue();         var category_field = ZDK.Page.getField('Category');         // requirement - 1         if (['Ignition box', 'Ignition coil', 'Spark plug'].includes(product_name)) {             // Populate value for picklist field 'Category' based on the condition             category_field.setValue("Ignition system");             ZDK.Page.getField('Number_of_Boxes').setMandatory(true); // requirement - 2         } else if (['Speedometer', 'Odometer', 'Voltmeter','].includes(product_name)) {             // Populate value for  picklist field 'Category' based on the condition             category_field.setValue('Gauges and meters');         }         break;   case 'Phone_Number':         var phone_field = ZDK.Page.getField('Phone_Number');         if (phone_field.getValue().length < 10) {             phone_field.showError('Enter a valid phone number'); // requirement - 4         }         break;  case 'Country':        ZDK.Page.getField('Phone_Number').setMaxLength(10);        break;     case 'Category':         if (ZDK.Page.getField('Category').getValue() === 'Ignition system') {             ZDK.Page.getField('Number_of_Boxes').setMandatory(true); // requirement - 2 when category is changed in ui         }         break; }

In the above script, based on the field updated by the user, execution will happen.

---

2. I would like to be able to retrieve sub-form records with COQL.

Subform is a data section embedded in the primary form to collect details related to the parent record. It  helps in maintaining multiple records under a single parent record. These subform records cannot be fetched via the parent module in the Query API. Since subforms are treated as individual modules, you should state their API names to access their records or fields. Consider a manufacturing company, Zylker, which uses Zoho CRM for effective maintenance of customer relationships. The suggestions and feedback from each of their clients are tracked with the help of a subform called Client Review in the Accounts module.

Consider a manufacturing company, Zylker, which uses Zoho CRM for effective maintenance of customer relationship. The suggestions and feedback of each of their clients is tracked with the help of a subform called Client Review in the Accounts module. 

Now the Manager wants to fetch the suggestions from all the Accounts. Let us see how he can achieve this using COQL API. 

Step 1: Make a GET Modules metadata API call to get the api_name of the subform.

Step 2: Using the api_name of the subform, make a GET Fields metadata API call to get the api_name of the fields in the subform. 

Step 3: Use the api_name of subform and subform fields to construct a query. 

{     "select_query": "select Suggestions from Client_Review where Suggestions is not null" }

Step 4: Use this query in the COQL API. 

Request URL: {api-domain}/crm/{version}/coql

Request Method: POST

Scope: To access COQL API, you need to pass two scopes - ZohoCRM.coql.READ and ZohoCRM.modules.all. You can also use ZohoCRM.modules.{module_name}.{operation_type} in the place of ZohoCRM.modules.all. 

Request Body : 

{     "select_query": "select Suggestions from Client_Review where Suggestions is not null" }

Response :

Using the parent record id, you can fetch the subform records related to a particular Account.  Following is the request body to fetch the subform details particular to a parent record, 

{     "select_query": "select Suggestions, Feedback from Client_Review where ((Parent_Id=5545974000003933016) and ((Suggestions is not null) and (Feedback is not null)))" }

This query will fetch all the subform records of the specified record whose Suggestions and Feedback fields are not null as shown below. 

---

3. I want to discuss Subform in Zoho CRM.  Can the user filter subform record in Deal or Lead?

We can filter the records that have subform fields in them using COQL. Consider the example of the above manufacturing company, Zylker. The manager wants to fetch the details of those records in the Accounts modules that have Client Review details. This can be achieved by the following COQL query.

{     "select_query":"select Parent_Id.Account_Name from Client_Review where id is not null  group by Parent_Id.Account_Name " }

Response : 

In case you missed out our newsletter and announcement and could not fill out the feedback form, it is not too late to do it now. We invite you to take a few minutes, fill out the feedback form and share your queries and thoughts. We will continue to reply to your questions in our upcoming Kaizen posts.

Cheers!

• Topic Participants

• Maadhari M

  

• SOUNDTEC

• Praveen Sankar

  

• Sticky Posts

• Kaizen #197: Frequently Asked Questions on GraphQL APIs

  🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Kaizen #198: Using Client Script for Custom Validation in Blueprint

  Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Celebrating 200 posts of Kaizen! Share your ideas for the milestone post

  Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs

• Kaizen #193: Creating different fields in Zoho CRM through API

  🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Client Script | Update - Introducing Commands in Client Script!

  Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands

• Recent Topics

• Celebrating Connections with Zoho Desk

  September 27 is a special day marking two great occasions: World Tourism Day and Google’s birthday. What do these two events have in common (besides the date)? It's something that Zoho Desk celebrates, too: making connections. The connect through tourism

• What is Resolution Time in Business Hours

  HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

• How use

  Good morning sir I tried Zoho Mail

• Adding Overlays to Live Stream

  Hello folks, The company I work for will host an online event through Zoho Webinar. I want to add an overlay (an image) at the bottom of the screen with all the sponsors' logos. Is it possible to add an image as an overlay during the live stream? If so,

• Email Sending Failed - SMTP Error: data not accepted. - WHMCS Not sending emails due to this error

  I have been trying to figure out a fix for about a week now and I haven't found one on my own so I am going to ask for help on here.  After checking all the settings and even resetting my password for the email used for WHMCS it still says: Email Sending Failed - SMTP Error: data not accepted.  I have no clue how to fix it at this point. Any insight would be lovely. 

• Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

  Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?

• Zoho Flow - Update record in Trackvia

  Hello, I have a Flow that executes correctly but I only want it to execute once when a particular field on a record is updated in TrackVia. I have the trigger filters setup correctly and I want to add an "update record" action at the end of the flow to

• Add Comprehensive Accessibility Features to Zoho Desk Help Center for End Users

  Hello Zoho Desk Team, We hope you're doing well. We’d like to submit a feature request to enhance the client-facing Help Center in Zoho Desk with comprehensive accessibility features, similar to those already available on the agent interface. 🎯 Current

• Rename Record Summary PDF in SendMail task

  So I've been tasked with renaming a record summary PDF to be sent as part of a sendmail task. Normally I would offer the manual solution, a user exports the PDF and uploads it to a file upload field, however this is not acceptable to the client in this

• in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Q

  in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Quantity Returned\ pls check the recording fetch_salesorder

• Estimates with options and sub-totals

  Hi It seems it would be great to be able to show multiple options in an estimate. For instance I have a core product to which I can add options, and maybe sub-options... It would be great to have subtotals and isolate the core from the not compulsory items. Thanks

• Optional Items Estimate

  How do you handle optional items within an estimate? In our case we have only options to choose with. (Like your software pricing, ...standard, professional, enterprise) How can we disable the total price? Working with Qty = 0 is unprofessional....

• Important Update : Zendesk Sell announced End of Life

  Hello Zendesk users, Zendesk has officially announced that Zendesk Sell will reach its End of Life (EOL) on August 31, 2027 (Learn more). In line with this deprecation, Zoho Analytics will retire its native Zendesk Sell connector effective October 1,

• Zoho Sheets

  Hi, I am trying to transition into Zoho sheets, I have attached the issues encountered. Server issues, file trying to upload for more than 30 mins, even once uploaded my data aren't loaded. Simple calculations are not working I have attached the sample.

• Zoho CRM + Zoho FSM : alignez vos équipes commerciales et techniques

  La vente est finalisée, mais le parcours client ne fait que commencer ! Dans les entreprises orientées service, conclure une vente représente seulement la première étape. Ce qui suit — installation, réparation ou maintenance régulière — influence grandement

• Top Bar Shifting issue still not fixed yet

  I mentioned in a previous ticket that on Android, the top bar shifts up when you view collections or when you're in the settings. That issue still hasn't been fixed yet. I don't wanna have to reinstall the app as I've noticed for some reason, reinstalling

• Power of Automation:: Automate the process of updating project status based on a specific task status.

  Hello Everyone, Today, I am pleased to showcase the capabilities of a custom function that is available in our Gallery. To explore the custom functions within the Gallery, please follow the steps below. Click Setup in the top right corner > Developer

• ZOHO SHEETS

  Where can I access desktop version of zoho sheets? It is important to do basic work If it is available, please guide me to the same

• Attention API Users: Upcoming Support for Renaming System Fields

  Hello all! We are excited to announce an upcoming enhancement in Zoho CRM: support for renaming system-defined fields! Current Behavior Currently, system-defined fields returned by the GET - Fields Metadata API have display_label and field_label properties

• Billing Management: #3 Billing Unbilled Charges Periodically

  We had a smooth sail into Prorated Billing, a practice that ensures fairness when customers join, upgrade, or downgrade a service at any point during the billing cycle. But what happens when a customer requests additional limits or features during the

• No bank feeds from First National Bank South Africa since 12 September

  I do not know how Zoho Books expects its customers to run a business like this. I have contacted Zoho books numerous times about this and the say it is solved - on email NO ONE ANSWERS THE SOUTH AFRICAN HELP LINE Come on Zoho Books, you cannot expect

• Citation Problem

  I had an previous ticket (#116148702) on this subject. The basic problem is this; the "Fetch Details" feature works fine on the first attempt but fails on every subsequent attempt, Back in July after having submitted information electronically and was

• Open Sans Font in Zoho Books is not Open Sans.

  Font choice in customising PDF Templates is very limited, we cannot upload custom fonts, and to make things worse, the font names are not accurate. I selected Open Sans, and thought the system was bugging, but no, Open Sans is not Open Sans. The real

• Failing to generate Access and Refresh Token

  Hello.  I have two problems: First one when generating Access and Refresh Token I get this response:  As per the guide here : https://www.zoho.com/books/api/v3/#oauth (using server based application) I'm following all the steps. I have managed to get

• Zeptomail 136.143.188.150 blocked by SpamCop

  Hi - it looks like this IP is being blocked, resulting in hard bounces unfortunately :( "Reason: uncategorized-bounceMessage: 5.7.1 Service unavailable; Client host [136.143.188.150] blocked using bl.spamcop.net; Blocked - see https://www.spamcop.net/bl.shtml?136.143.188.150

• Apply transaction rules to multiple banks

  Is there any way to make transaction rules for one bank apply to other banks? It seems cumbersome to have to re-enter the same date for every account.

• How to bulk update records with Data Enrichment by Zia

  Hi, I want to bulk update my records with Data Enrichment by Zia. How can I do this?

• Need Guidance on SPF Flattening for Zoho Mail Configuration

  Hi everyone, I'm hoping to get some advice on optimizing my SPF record for a Zoho Mail setup. I use Zoho Mail along with several other Zoho services, and as a result, my current SPF record has grown to include multiple include mechanisms. My Cloudflare

• How do I split a large CSV file into smaller parts for import into Zoho?

  Hi everyone, I’m trying to upload a CSV file into Zoho, but the file is very large (millions of rows), and Zoho keeps giving me errors or takes forever to process. I think the file size is too big for a single import. Manually breaking the CSV into smaller

• Client Script Payload Size Bug

  var createParams = { "data": [{ "Name": "PS for PR 4050082000024714556", "Price_Request": { "id": "4050082000024714556" }, "Account": { "id": "4050082000021345001" }, "Deal": { "id": "4050082000023972001" }, "Owner": { "id": "4050082000007223004" }, "Approval_Status":

• Sync Issue Between Zoho Notebook Web App on Firefox (PC) and Android App

  Hi Zoho Notebook Community, I'm facing a sync problem with Zoho Notebook. When I use the web version on Mozilla Firefox browser on my PC, I create and save new notes, and I've synced them successfully. However, these new notes aren't showing up in my

• Messages not displayed from personal LinkedIn profile

  Hello. I connected both our company profile and my personal profile to Zoho social. I do see all messages from our company page but none from my private page. not even the profile is being added on top to to switch between company or private profile,

• lead convert between modules

  Hello, The workflow we set up to automatically transfer leads registered via Zapier into the Patients module to the Leads module started to malfunction unexpectedly on September 25, 2025, at 11:00 AM. Under normal circumstances, all fields filled in the

• Flow Task Limits - How to Monitor, Understand Consumption?

  So, I got an email last night saying that I've exhausted 70% of my tasks for this month, and encouraging me to buy more tasks. I started to dig into this, and I cannot for the life of me figure out where to find any useful information for understanding,

• Cross References Do Not Update Correctly

  I am using cross references to reference Figures and current am just using the label and number, i.e. Figure #. As seen here: When I need to update the field, I use the update field button. But it will change the cross reference to no longer only including

• Manage control over Microsoft Office 365 integrations with profile-based sync permissions

  Greetings all, Previously, all users in Zoho CRM had access to enable Microsoft integrations (Calendar, Contacts, and Tasks) in their accounts, regardless of their profile type. Users with administrator profiles can now manage profile-based permissions

• How to Track and Manage Schedule Changes in Zoho Projects

  Keeping projects on track requires meticulous planning. However, unforeseen circumstances can cause changes to schedules, leading to delays. It becomes important to capture the reason for such changes to avoid them in the future. Zoho Projects acknowledges

• Is there a notification API when a new note is addeding

  Trying to push to Cliq, or email notification when there's a new note added in module. How to implement this?

• Zoho Sheet - Desktop App or Offline

  Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.

• Collaborate Feature doesn't work

  Hello Team. It seems that the collaborate section is broken? I can post something but it all appears in "Discussions". In there is no way how I would mark something as Draft, Approval, post or any of the other filter categories? Also if I draft a post

• Next Page