Kaizen #186 : Client Script Support for Subforms

Kaizen #186 : Client Script Support for Subforms



Hello everyone!

Welcome back to another exciting Kaizen post on Client Script! 

In this edition, we’re taking a closer look at Client Script Support for Subforms with the help of the following scenario.

" Zylker, a manufacturing company, uses the "Orders" module to place Orders . They fill in a subform called "Product List". Now, the Admin wants to enforce the following restrictions on this subform in detail page:
  • Disable row deletion
  • Prevent cloning and adding rows
  • Make the "Unit Price" field read-only for salespersons "

In this post,

  1. What are Subform event
  2. Possible actions in Subform using Client Script
  3. Use Case
  4. Disable row deletion within the subform
  5. Prevent cloning and addition of rows in subform
  6. Make the "Unit Price" field read-only for salespersons
  7. Summary
  8. Related Links


1.What are Subform Events

Subform events are triggered by user actions, such as adding or deleting rows or updating data in subform. These events allow you to run Client scripts for validation, automation, or dynamic updates. Here is the list of subform events.
  • onCellChange – Triggered when a cell value is changed and the keyboard or mouse focus moves out of the subform cell.
  • onRowAdd – Fires immediately after a new row is added in a subform.
  • onRowDelete – Executes right after a row is deleted from a subform.
  • beforeRowDelete – Invoked before a subform row is deleted; can be used to prevent deletion.
  • beforeRowUpdate – Triggered before a subform row is updated on Detail pages; useful for validations or preventing changes.
Click here to know more about Subform Events.
These events are supported in the following Pages of Zoho CRM
  • Standard - Create/Edit/Clone Pages, Detail page
  • Canvas - Create/Edit/Clone Pages, Detail page
  • Wizard - Create/Edit Pages
2. Possible actions in Subform using Client Script




Click here to view the detailed documentation about the Client Script ZDKs related to Subform.

Notes
 Note :

The setValue() method for a subform row and cell on the Detail Pages will only work when the row is in edit mode.

3. Solution

To accomplish the solution for the use case (stated at the beginning of the post), you need to create the following Client Scripts in detail Page.

3.A. Disable row deletion within the subform

  • Go to Setup > Developer Space > Client Script. Click +New Script.
  • Specify the details to create a script. 
  • Click Next.


Script :

  1. ZDK.Client.showAlert("Deleting rows is not allowed here");
  2. return false
  • This script blocks row deletion and shows an alert message.

  • Here is the syntax of showAlert().


  • You can see that the Client Script Triggers an alert message and prevents the deletion of rows.



3.B. Disable adding and cloning of rows in subform
  • Go to Setup > Developer Space > Client Script. Click +New Script.
  • Specify the details to create a script. 
  • Click Next.


Script: 

  1. ZDK.Client.showAlert("Adding and cloning rows is not allowed in this subform")
  2. return false;
  • You can see that the Client Script Triggers an alert message and prevents the addition of a new row. 



3.C. Make the "Unit Price" field read-only for salespersons

  • Go to Setup > Developer Space > Client Script. Click +New Script.
  • Specify the details to create a script. 
  • Click Next.

Script:
  1.   var user = ZDK.Apps.CRM.Users.fetchById($Crm.user.id);
  2. if (user.profile.name == 'Salesperson') {
  3.     var field_obj = ZDK.Page.getSubform("Product_list").getField('Unit_Price');
  4.     field_obj.setReadOnly(true);
  5. }

  • Here, 
  • $Crm refers to the Client Script Constant.





  • Click here to know more about other ZDKs and functions related to Client Script.
  • Here is how Client Script works.




Summary

1. What are the events available for subforms
2. What are the supported actions in subforms
3. How to make a field read only in a subform for a particular profile
4. How to prevent adding rows to a subform.

Related Links

Idea
Previous Post: Kaizen 185 - Subqueries in COQL AP |  Kaizen Collection: Home


    • Sticky Posts

    • Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!

      We are introducing a new zoho-crm skill to make working with Zoho CRM Developer tools (like APIs, functions, widgets, client scripts, queries etc) easier and faster, with the help of AI in your preferred AI harness like Claude Code, Codex, Cursor, VSCode
    • Kaizen #261 : Using Zoho CRM Skill to generate complex COQL queries

      Hello everyone, In the previous Kaizen posts, we introduced the zoho-crm SKILL.md and discussed how it can help you when you are working with Zoho CRM APIs and Client Script. In this Kaizen, we will focus on using the Zoho CRM `SKILL.md` with GitHub Copilot
    • Kaizen #256 - Build an Arrival Readiness Web Tab in Zoho CRM

      Hi everyone! Welcome back to the Kaizen series! In the post, we discuss a use case in hospitality industry: how an Arrival Readiness web tab widget can be used to let reception staff identify and resolve issues before arrival of guests. Use case In the
    • 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.
    • Kaizen #226: Using ZRC in Client Script

      Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this
    • Recent Topics

    • Deal Activity Tracking - By Time

      Hello, I am trying to figure out a way to implement a time tracking ability within the CRP that will provide a line item on the final invoice in books. Would the Cases module be of good to use in this scenario? Want to integrate into Books as well. I
    • time tracking on zoho crm cases

      Is there a time tracking feature in zoho crm cases? I need calculate time spent in calls, tasks and events Thanks in Advance  
    • Time Card Tracking For Employees

      Does ZOHO have an add-on or app that my employees can use to clock in & out on a daily basis. In the past we had used a third party solution, but it was hard to use and pricey. We would really like to use your time tracking feature if you have one......if
    • Logging time within Time Tracking

      At the moment I use the call logging feature of CRM to log time spent on clients work. Its nice to be able to start, stop and pause the timer and record how many hours I need to bill the client. Any chance of implementing this in Zoho Invoice's time tracking feature The same interface as CRM would be great or a simple start/stop/pause/restart timer.
    • 3rd Party/Easy Time Tracking Integration with Zoho

      We are new customers using Zoho One with Zoho Project/CRM/Desk being the 3 big applications we will use. The majority of our work is done in the field and we need accurate and easy time tracking for our workers on mobile phones. aka TSheets type functionality. but tied to Zoho. Zoho is outstanding overall so I am surprised at how laborious, inefficient and disconnected time tracking is mobile devices. Adding time to a project task on a mobile phone can be a 10+ click task and that's not an exaggeration!
    • TrueSync for Windows 5.16+ breaks Excel save in "Shared with Me" (temp file writes fail) – workaround: pin 5.15.1

      Hi all, After TrueSync for Windows auto-updated past 5.15.1, some of our users can no longer save Excel files that live under "Shared with Me". We isolated it to a client-side regression and found a workaround. Sharing in case it saves someone a few hours
    • Introducing PRM: Build, manage, and scale your partner ecosystem

      Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
    • Purchase 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) >> Bill
    • Enhancement Request: Preserve Canceled Zoho Bookings Meetings in CRM

      I recently worked with Zoho Support on ticket 170383788 regarding what happens in Zoho CRM when an appointment is canceled in Zoho Bookings. Support confirmed that the current behavior is intentional: when a Bookings appointment is canceled, the corresponding
    • Introducing the Markdown editor in Zoho Learn

      Hello everyone, We're excited to announce the release of the Markdown editor in Zoho Learn. With Markdown editor, you can create and import articles as Markdown. You can write content using simple Markdown syntax and see how it looks with the built-in
    • When will Bigin's latest AI features be available in Europe?

      Hi, As I previously raised this question in the post “Introducing Bigin's latest AI features, built for the way you work!”, but received no response, I am bringing it up again here. It has now been five months since the announcement, and these AI features
    • Function #50: Send Mass emails to your customers

      Hello everyone, and welcome back to our series! We have reached a milestone of 50 Functions, which means that we have automated 50 different tasks in Zoho Books. Every Friday, we have shared a nifty function aimed at either automating a task or streamlining
    • Time tracking

      Hi there We are looking for a simple, intuitive but powerful time track application. We bill our clients by the time we spend, and so need to link Clients<>Projects<>Tasks or Activities<> Time spent. Is there an app in Zoho we could use? Many thanks.. Morri
    • Staff Tracking in

      Hi , I would like to see what activity my staff does over Zoho CRM and over Zoho Mail . I need to know which deals in CRM haven't been touched or had an activity on by a particular staff member . Basically need to establish what work.gets done by WFH
    • Zoho Projects connector with Zoho CRM (Related List module) features

      Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
    • Report: avg time to visit each lead

      We are on zoho one. our sales team visits leads using the ZohoCRM app. They track their hours using the zoho books timer. So the results in zoho books look like this: -total hours worked: 8 In ZohoCRM we have a custom date/time field in each lead record
    • Creating a Stop Start Timer for Custom Moduel

      Hello, I am trying to track Maintenance of internal Assets through Zoho CRM (I have tried the FSM, Projects, Inventory apps nothing is working the way I need it to). I have it all built in the CRM where I have internal work orders where i can keep track
    • Logging time to a Sales Lead in CRM

      Hi, Is there a way to log time against a Sales Lead / Deal in CRM before it is won and becomes a project? Our employees often do work for sales opportunities and need to log time against them at any point of the sales cycle, before it is won. Thanks, Atif
    • Hourly Billing in Zoho CRM Deals, Books, and Projects?

      We bill on an hourly basis and need that time added into a client's invoice in Books. A client might have multiple deals open with us that we are working on, and billing separately, and thus need separate invoices for each. The functionality of Projects
    • Time taken on a task

      I notice that you can record the length of a call, but not an event or a task. When a potential progresses from beginning to end it is just a series of tasks/calls/events in a process.  I have most of it automated depending on the type of sale and triggered by updating the sales cycle field. It follows that you should be able monitor the time of each of them so that you actually know how much time you spend on each potential. This gives an idea of profitability of each potential. I would think this
    • Timesheets from Deals

      Hi Guys, new Zoho One customer here with only a few employees. I run a small software company and currently our small number of employees are creating manual timesheets in excel. There is a column for a job number (that relates to a Zoho Deal) and they just put in the time taken to perform the work. As an example, they might spend 1 hour running some barcodes for a particular client (and deal). Then they may do a support all for another client and that takes 2 hours (This client would have a yearly
    • Timesheet option in zoho crm

      Recording a timesheet against a job is very crucial for every business because it will help them in billing the client accordingly and also it keeps a track on how much time a user is exactly taking in marking the job as cloed. Currently in crm there
    • Portal access is now available in the Zoho CRM mobile app

      Hello everyone, Zoho CRM Portals provide a secure space for sharing selected records with people outside your organization. These portal users can include customers, vendors, partners, or anyone who needs access to specific CRM data. Previously, portal
    • Field of Lookup - 5 Field Association Limit.

      This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
    • Zoho Forms API

      Is there any way to get all form entry list using API? Looking forward to hear from you
    • Multiple locations

      I have many customers (accounts) that have multiple locations, like bank branches. How can I manage them under one account?
    • Calendar won't load

      I run into this problem about once a week, where I try to open my Zoho calendar in a web browser, and it just gets stuck, waiting forever to load (see attached screenshot). I'm usually using Edge or Duck-Duck-Go browser. Sometimes it loads just fine,
    • Feature Request: Enhance Zoho Books Customer Approvals with WhatsApp, Multiple Approvers, Automated Reminders, and Workflow Automation

      Product: Zoho Books Module: Time Tracking → Customer Approvals Category: Feature Enhancement / Workflow Automation / Omnichannel Communication Description I would like to suggest several improvements to the Customer Approvals module in Zoho Books, particularly
    • Feature Request: Extend Zoho Books Customer Approvals API and MCP Support

      Product: Zoho Books Category: API Enhancement / OAuth Scopes / MCP Integration Feature: Customer Approvals (Timesheet Approvals) Description I would like to suggest an enhancement to the integration and automation capabilities of Zoho Books, specifically
    • Tip: #14 Save words and phrases in Writer for faster writing!

      As you start working with more documents everyday, you'd find yourself using certain words and phrases across documents quite often. In this week's tip, let's discuss two easy ways to train Writer to remember your commonly used words—equipping you to
    • Zoho ERP | Product updates | October 2026

      Hello users, A new month, a fresh set of updates in Zoho ERP. This month brings Netting, enhancements across our verticals, and more updates to help streamline your everyday work. Explore this month’s updates and see what’s new. Compliance with Revised
    • Zoho Forms - Feature Request - Embed iFrame or Dynaic URLs in Description fields

      Hi Zoho Forms team, I'm working with a client who uses Zoho Forms internally to collect information over the phone from potential work placement candidates. At the end of the form, the candidate needs to be booked in for an induction, which we've configured
    • BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

      As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?
    • Digest Octobre - Un résumé de ce qui s'est passé le mois dernier sur Community

      Bonjour chers utilisateurs, Bienvenue dans ce nouveau digest de la communauté Zoho France ! Vous y trouverez les discussions marquantes, les nouveautés produits, les conseils pratiques partagés et bien sûr les événements à venir. Le mois dernier, nous
    • Bank feeds - still a problem

      I'm really frustrated that the bank feeds only "sometimes" work.  I raised this problem once before and was advised that Zoho used Yodlee and feeds were only updated once a day.  That's fine but it only "sometimes" seems to work.  Eventually transactions appear but they sometimes seem to take days.  I know of other programs (Xero) that another business I am involved with uses Yodlee and they do not have this issue. My bank feeds are active,  I tried to manually refresh however Zoho tells me that
    • this is getting ridiculous

      My checking account bank feeds haven't worked since 6/4/21.  Multiple emails to Zoho since 6/10, and all they tell me is they have re-escalated my problem to their banking service provider team.  14 days and nothing is fixed. I'm just about ready to bail
    • No feedback from Zoho Books regarding Yodlee feeds for Investec

      I reported on 6 Feb 2025 that the Bank Feeds for Investec bank via Yodlee are not working. To date there has been no resolution. You are charging us for a suite of products where the functionality does not work. Please advise how you will refund me for
    • ongoing bank sync problems

      My bank feed broke May 14th 2021 Since then I just get an endless stream of we are working on it, "Kindly bear with us for sometime" from support Multiple times I have asked to speak to managers and half the time they don't call at all. If they do call
    • We must admit - Yodlee is an unreliable partner!

      Hello Zoho, Our Yes Bank account intergration is messed up since the beginning and the problem has not been addressed yet. With bad synchronization, poor categorization of transactions, duplicate/unknown copies of accounts, no support, geared at income/expenses,
    • Make your PDFs clearer with shapes

      Sometimes the best way to mark up a PDF is to point at it directly. Zoho PDF Editor includes shape tools that let you add circle, check and cross marks anywhere in your PDF, so you can flag content for review without extra comments. Here's what you can
    • Next Page