Client Script | Update - Introducing Subform Events and Actions

Client Script | Update - Introducing Subform Events and Actions

Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms?

We are thrilled to introduce one of the most anticipated Client Script Updates: Subform Events and Subform-specific Client APIs in Client Script!

 Subform events are triggered from 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. By leveraging Subform Events, you gain precise control over subform behavior.  

This empowers you to achieve advanced interactivity, streamline workflows, enhance user interactions, and deliver exceptional user experiences.

Subform Events

  • onCellChange 

  • onRowAdd

  • onRowDelete

  • beforeRowDelete

  • beforeRowUpdate (Applicable only for Detail Pages)

Supported Pages

  • Standard - Create/Edit/Clone Pages, Detail page

  • Canvas - Create/Edit/Clone Pages, Detail page

  • Wizard - Create/Edit Pages

 

Available Client APIs


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.
 

Scenario 1 : Apply row value based dynamic filters and display error and clear a cell in subform for invalid input

Organization: Zylker, a manufacturing company using Zoho CRM.

Subform Filtering: In the Quotes module, products in the subform are filtered based on the selected Product Category.

Stock Validation: When the quantity in the Quoted Items subform exceeds available Stock, an error message is displayed. The field is reset to null.

 

Click here to view the source code.

Scenario 2 : Secure subform rows with beforeRowDelete

  • Organization: Zylker ensures data integrity during key Deal stages in Zoho CRM.

  • Restricted Stages: Subform item deletion is restricted in the following stages:

    • Proposal/Price Quote

    • Negotiation/Review

    • Closed Won

    • Closed Lost

  • Enforcement: The beforeRowDelete event verifies the Deal stage and returns false to prevent deletion.

 

Click here to view the source code.

Scenario 3 : Auto-Fill values for new rows and clear subform based on custom conditionI

  • Module: Campaign module in Zoho CRM.

  • Auto-Population: When a new row is added to the subform:

    • The onRowAdd event uses setValue() to auto-populate:

      • "Status" field with "Planning".

      • "Allocated Budget" with $3000.

  • Region Change: When the "Region" field changes:

    • The onChange event triggers clear() to reset campaign details for region-specific data.

 

Click here to view the source code.

Scenario 4 : Tailor cell, row and column locks in subforms and manage field visibility with ease.

  • Module: Campaign subform in Zoho CRM.

  • Allocated Budget Field:

    • Editable only by admins.

    • Read-only for all other users.

  • Row Locking:

    • The setReadOnly() method, triggered by onLoad and onCellChange:

      • Locks the entire row when the Status is "Complete."

      • Restricts the Allocated Budget field unless the Status is "Planning."

  • Field Visibility:

    • The Type of Campaign column is managed with setVisibility():

      • Visible only when Parent Type is "others."

 

 

Click here to view the source code.

Scenario 5 : Dynamic data check on subform cell update

  • Validation: Ensure the Allocated Budget of all campaigns does not exceed the Total Budget Allocated.

  • Restriction:

    • If the budget exceeds the limit:

      • Prevent the row from being saved.

      • Display an error message.

 



Click here to view source the code.

Limitations :

1. The onRowAdd event is not supported during bulk row addition.

2. Subform methods and events do not work in line-item subforms present in Blueprint transition.
3. Row added in subforms using Guided selling  do not trigger the onRowAdd event
for now.
4. This update is not supported on mobile devices.

  

We hope you find this update useful!

QuoteRelease Plan : We have begun rolling out the feature and will provide updates here as it becomes available in each DC.

 

 






      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ








                                ご検討中の方

                                  • Recent Topics

                                  • Working with Products that are non-tangible

                                    How does one create a 'service' in products? Is there a way to disable inventory functions for things like Sofware as a service? The services module doesn't look to be much help either. Not sure how to do this in CRM
                                  • OAuth integration issues

                                    I'm experiencing persistent OAuth errors when trying to connect Make with Zoho API. I've tried multiple approaches but keep encountering the following issues: First error: 'Invalid Redirect Uri - Redirect URI passed does not match with the one configured'
                                  • Custom module system name

                                    Is there a way to define custom module system name? Currently it's something like `CustomModuleX` This is different to API name or display name.
                                  • Homepage not assignable to group

                                  • How can I edit the Picklist History?

                                    I was working with some custom functions in CRM that inadvertently triggered unwanted changes in a picklist history for the Accounts module. It is absolutely essential for the business that I roll these changes in the subform back because they throw off
                                  • Multi-select pick list "Combo Box"

                                    I would like to suggest a new field type (or upgrade to existing type), the combo box. This is a single or multi-select pick list that includes the option to type your own entry into the field via a text field. This could be achieved by appending an "other" option to the field options; once this option is selected a text field would appear that allows you at enter your own option. This option would then be added to the select list once saved. This means standard users have the ability to add new
                                  • Bulk Delete Images

                                    How do I bulk Delete Images from Zoho Campaigns. We have been using the Zoho since 2019 and can still only see the option to delete images one by one and we have a lot of old Campaign imagery we don't need anymore. Thanks!
                                  • Workflow to auto close Open Deals after 7 days?

                                    I want to set up a Workflow to Automatically close Deals as Lost after 7 days from their created date, (Regardless of activity or not) I am new to Zoho however I read 2 different ways to do it. 1 required to create a custom Date field and the other looked
                                  • Restore Report in Zoho Creator After Changing Report Type

                                    I created a report in Zoho Creator and have been using it regularly. While editing, I accidentally changed the report type, and all the fields disappeared from the report. I am using the development version, but I don’t want to revert all the changes
                                  • Incident Report: Zoho Cliq Services Restored in the EU Region (March 19, 2025)

                                    We received a report that the Zoho Cliq service in the EU region was down. It's been restored now. Our team is actively monitoring the issue, analyzing the root cause, and will share updates. Incident details: Date and Time: Mar 19, 2025, 11:44:24 AM
                                  • Zoho Creator Upcoming Updates - March 2025

                                    Hello everyone, We hope you’ve had the chance to explore Release Projection 1 for 2025! This month, we’re keeping up the momentum by bringing even more powerful features and enhancements to Zoho Creator. Here's what you can expect in March: App menu builder
                                  • Zoho CRM Error message #2 : Fixing [Invalid Credentials] and [Authentication Fail] while configuring IMAP

                                    Hi Everyone! As a part of our Zoho CRM Error messages series, we're going to focus on couple of error messages that you might encounter while configuring IMAP and ways to resolve them. These are: [Invalid Credentials] [Authentication Fail] The annoying
                                  • Rejected Accounts still listed for Deal

                                    Hello guys I have a approval process thats validate the Accounts in CRM The issue is even when a account is rejected you can open a deal with it It's not supposed to appear in the lookup field or the approval process become pointless Can you guys help
                                  • I'm so confused by the new (?) look

                                    I've been off Notebook for a long time, neglecting the app and never visiting the website. I decided to renew my commitment to it. It looks completely different! When I logged on before (app or browser page) I'd see a very pretty display of my multiple
                                  • Dashboard tabs - last month relative

                                    Hello, On my dashboard, it has "last month relative" under some tabs such as deals created, for example, highlighting if it has increased or decreased from last month. Is it possible to add this feature onto the other tabs? There are a handful which don't
                                  • Zoho Creator Mobile app no Default Workspace

                                    When I use the Zoho Creator mobile app I do not get a default workspace. This is occurring for me and another new user. I believe this is an issue with Zoho One / Zoho Creator. I have tried working with support and it's been over a week of no solution
                                  • Dynamic Date Filtering for KPI Widgets – Need Help with Query Table

                                    Hello, I'm seeking help with setting up dynamic date filtering for my KPI widgets in Zoho Analytics. Below is an overview of my setup and the issues I'm facing: Why: I need my KPI widgets to update dynamically based on a date range selected via a dashboard
                                  • Connect to Zoho Reports via MS-SQL Server

                                    Hi there, I have a premises MS-SQL Server and we are trying to get all tables/fields information about our current subscription we have and I wondering how can I connect from my local DB to your ZOHO DB to begin extracting information and combining with different datasets to generate an internal analytic dashboard. What would be the best approach? Or is there any way that I can download report on a weekly basis, if so. How can I generate it? Thanks for your help
                                  • Why can't you make a layout rule based on a lookup field?

                                    Hello :) I am wanting to build a layout rule based on the selection of a lookup field. I have 3 fields that I want to hide for all options, but only show one if the lookup is one of the 3 options needing the extra field. It doesn't seem to give me the
                                  • What to do with Leads coming in from an existing Account

                                    Hello We have an integration with our webinar/content host and any new sign ups come as new leads in Zoho It's not impossible for these leads to be working for an existing account, just someone we have yet to interact with In this scenario, would we keep
                                  • We are being told that emails sent to us bounce back on first attempt, then go through upon the second attempt. How do we fix this?

                                    As the title suggests, when interacting with another business today (one that is also using their own domain emails) we were told that each time they sent an email to us, it would bounce back upon the first attempt, only to go through successfully upon
                                  • Kanban doesn't trigger workflows

                                    Hello, Im trying to use a Kanban view of my list, but i'm noticing that moving my objects on the kanban doesn''t trigger any workflow, anyone else having this problem? I have a form edited sucess workflow, and it doesn't work if i edit the "deal stage" trought the kanban view, only if i edit it.
                                  • Best way to handle email sharing in CRM for safety

                                    Hello :) We have CRM+ and are configuring email sharing. We have gone for the public sharing with blocked domains for our company emails, and other companies who may email with private information. We have some contacts in the business who have a normal
                                  • Apple Messages for Business in Omnichannel communications?

                                    Hello, Apple launched "Apple Messages for Business" but Zoho CRM or Zoho Desk don't appear in the list of possible integrators. Zoho already promotes https://www.zoho.com/crm/omnichannel.html Omni Channel integration, but Apple Messages does not yet appear.
                                  • TeamInbox Projects Integration?

                                    Are there plans for TeamInbox and Projects integration?
                                  • Access demo forms other than developers in Zoho Creator 6

                                    Can zoho creator 6 users other than developers test forms in the development/stage? just want to see the form view. The current condition of the form is being released, and want to make changes. But the user wants to see the changes first before publishing
                                  • Subform Lookup field showError doesn't clear in Client Script

                                    I have a lookup fields Deal, Account and Lead in Subform, I am checking if its null or not If its null It shows an error, but when I select some value for the Lookup Field it doesn't clear the error , for other fields such as single line or pickup etc.
                                  • Teaminbox whatsapp integration not working since saturday

                                    Hi, I dropped an email to support@zohoone.com and a web form. But I didn't get any responses. I checked the whatsapp link via the setup > Organization > Organization > Channels, and checked the whatsapp accounts in facebook business portfolio, it's all
                                  • Instantly refine your CRM dashboard using Filters and download underlying data – all in a few clicks!

                                    Hello everyone, Imagine you’re a sales manager overseeing multiple product lines across different regions. You're viewing your sales dashboard in Zoho CRM, which gives a powerful overview, but you often need to drill down to see how a specific product
                                  • Adding Default Module Image into mail merge field

                                    As with most people finding their way to these forums i have a specific requirement that doesn't seem to be supported by Zoho I have created 2 custom modules to suit my purpose 1 is an inventory type module that lists aluminium extrusions, and all relevant
                                  • Bulk Edit Issue

                                    Now the record Bulk Edit execute the Script On Edit --> On Success, But it was just update the selected field in Bulk Edit. Sample: If I want to update the Status field only to "Canceled" but the Status will be updated to "Completed". based on the script. Please advice about new Bulk Edit behavior. Omar
                                  • Zoho thrive Loyalty Program setup

                                    I have tried to set up my loyalty program with zoho thrive on my website but its not working kindly help me step by step how to set up it.
                                  • Client Script | Update - Client Script Support For Portals

                                    Dear All! We are excited to announce the highly anticipated feature: Client Script support for Portals. We understand that many of you have been eagerly awaiting this enhancement, and we are pleased to inform you that this support is now live for all
                                  • Client Script | Update - Introducing Subform Events and Actions

                                    Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce
                                  • Blocking / black listing customers

                                    Hi, We have a situation, we observed that certain customers are blocking multiple appointments with our advsiors but not showing up. Some of these are repeat offenders. This leads to those service hours getting blocked and not available for genuine customers.
                                  • One to many relationships

                                    Hello, I am not finding the tool for relating multiple contacts and/or multiple companies to one contact or company. e.g. Bob Jones (individual) Jones Company (company) as primary contact/company I want to be able relate Sarah Smith, Jane Doe, Steve Smith
                                  • How to bulk update lookup fields

                                    "I have a primary key named Product SKU in one form called Master SKU (which contains details like price, color, size, etc.). I also have another form called FBA, which has the same primary key, Product SKU, and contains stock quantity information for
                                  • Resource booking functionality questions

                                    I'm exploring the resource booking functionality in Zoho Bookings for my organisation's needs. I have a few questions about the available Zoho Bookings functionalities. Is it possible to force all users to sign up for an account before they book a resource?
                                  • ZohoDesk API to get conversations count of ticket

                                    Hi Team, I need information about ZohoDesk API that provides conversations count of ticket. Currently in ticket metrics api (https://desk.zoho.com/DeskAPIDocument#Tickets#Tickets_Getticketmetrics), it is providing only thread count, I need all conversations
                                  • How to Freeze Tasks

                                    Is there a way to freeze a task in the Gantt chart so it cannot move even when predecessors are moved?
                                  • Next Page