Augmenting subform capabilities

Augmenting subform capabilities

Greetings, everyone!
 
Finally, the day has come for us to announce some of the most anticipated, requested, and exciting updates to subforms in Zoho Creator.
 
As you're aware, subforms are an integral part of Creator forms, as they help in establishing proper modelling of the app, collecting rows of data, and setting up users to enter data that has a parent-child relationship. With this new set of updates, we've bought in a paradigm shift to subforms, as they'll be getting an all-new look for an improved user experience, along with new capabilities for solving challenges. This post will give you a sneak peek into these new subform enhancements.
 
Do you find it difficult to scroll subforms horizontally? Do you wish you could drag and drop subform rows? Do you want to manipulate subform fields via Deluge script? Then your wait has come to an end—continue reading to learn more on how you can now do all of this in subforms.
 

Subform list and pop-up view

As announced in the March 2023 post, the List view type of subforms will display the subform as a pop-up, and the current method of displaying subforms has been christened Grid.
 
To further understand how this can be helpful, let's put ourselves in the shoes of a supply chain manager. Their job requires them to regularly keep track of inventory lists in their warehouses.
 
Let's assume there's a form collecting warehouse details, like name, location, and stock inventory. For collecting the stock inventory details, a subform is present with these fields—Item No, Name, Manufacturer, Description, Cost Per Item, Stock Quantity, Inventory Value, Units Sold, Reorder Quantity, Reorder Date, and Person In Charge.

Now, the default view type will tire you out from scrolling back and forth horizontally, and results in a frustrating time-consuming process. We all long for a new way to avoid this and make data entry swifter.
 
To achieve this, make use of the new List option under  Subform->Field Properties->View Type.
 
List view, which looks similar to our list report, is a table-like subform without inline inputs. When you try adding or updating data in each row, a pop-up will be displayed listing out the fields with vertical scrolling, thereby ensuring a vastly superior user experience and more effective space management.



Crucially, it also helps to load subform rows quickly while editing records, by reducing the loading time.
 


While using an existing form as a subform, the form's exact structure will be replicated in the pop-up, to ensure consistency in the look and feel of the form. To understand this better, let's assume our form has a two-column layout, with Section and Note fields. Now the same customizations will be displayed in the pop-up, too! 



And that's not all—the new List view type is being extended to mobile apps, too. When it's enabled, the subform will be opened in the next screen, where users can add their data. This data will then be added as a subform row.

Custom sorting

Currently, the only sorting option in subforms is  field-based sorting, where you can choose a field based on which rows are sorted, either in ascending or descending order. Though this works well for basic cases, the need may arise in some cases to sort the subform in random order. With the new custom sorting support, you can effortlessly drag and drop subform rows to rearrange them.
 
To understand how it works, let's consider a task manager working on a To-Do List form, to plan activities for a current project. For this, they have a main form collecting project details, date-time, and milestones, and a subform for maintaining the to-do list with the following fields: Task Name, Description, Category, Status, Deliverables, Priority, and Deadline. Here, before submitting the list, they want to rearrange some tasks based on their daily routine.
 
To achieve this, they use the Custom sorting option under Subform->Field Properties->Sort type.
 
Now, with custom sorting, all they need to do to reorder the row sequence—both while adding and editing records—is simply drag and drop them in the required position.




The same order will be retained in reports or while opening the form for updating the list.  
Note: Custom sorting can be used both in List and Grid-type subforms.
 
Custom sorting will also be available on the mobile apps and you can effortlessly rearrange fields in subforms.

Deluge tasks for row-level actions

You can use a combination of workflows and Deluge scripts to help your subforms handle complex business logic. With that in mind, we formulated the idea of bringing in actions that help you take control at the row level of subforms.
 
In the past, you may have come across business scenarios which required you to hide/show or enable/disable a particular field in a specific subform row. Now, with new dedicated Deluge tasks, you can bid adieu to shortcuts and workarounds.
 
Note: Deluge tasks can be used both in List and Grid-type subforms.
 
Enable/disable
The new enable and disable subform Deluge tasks can be used to enable and disable specific fields.
 
Syntax: enable row.subform_field
             disable row.subform_field
Events: On add row, On delete row, On user input of subform field
 
Let's assume a Vehicle form has fields like Customer Name, Vehicle Model, and Date of Booking, and a subform to collect payment details with the following fields: Payment Date, Payment Method, Credit Card Number, Bank Account Number, and Transaction Ref Number.
 
Now, there are two payment options—Card and Netbanking. If Card is chosen, then the Credit Card Number field should be enabled and the Bank Account Number field should be disabled. Similarly, when Netbanking is chosen, then the Bank Account Number field should be enabled and the Credit Card Number field disabled.

Code snippet:
if(Payment_details.Payment_method == "Card")
{
 enable row.Credit_card_number;
 disable row.Bank_account_number;
}
if(Payment_details.Payment_method == "Netbanking")
{
 enable row.Bank_account_number;
 disable row.Credit_card_number;
}



Hide/show
The new show and hide subform Deluge tasks can be used to show and hide specific fields.
 
Syntax: hide row.subform_field
             show row.subform_field
Events: On add row, On delete row, On user input of subform field
 
Let's use the example of a rental property manager who needs to keep track of a list of properties that are available in every locality. For this, a form is used for collecting information like Locality and No of Vacant Properties, and a subform will be used to list property details with the following fields: Property Name, Address, Square Feet, Rent, Advance, Category, and Contact Number.
 
When the category is Brokerage, we need to hide the contact number of the landlord. We can use the new Deluge tasks to achieve this.
 
Code snippet :
if(row.Category == "Brokerage")
{
 hide row.Phone_Number;
}
else
{
 show row.Phone_Number;
}
     
     
-----

That's it from us on our subform enhancements! We expect these updates to be rolled out in the upcoming weeks. Once done, we'll pop in a comment below and also update our Release Notes page.
 
Don't forget—your feedback helps us make Creator better and stronger. We'd love to hear what you think about these updates. Please use the space below or send your feedback to support@zohocreator.com.
 
Regards,
Zoho Creator Team



    • Sticky Posts

    • Introducing Zoho Creator's 2025 Release Projection 2

      Hello Creators! I'm Prakash, from the Creator product management team, and today I'm delighted to unveil our next set of features as part of Release Projection 2 for 2025. With thoughtful analysis and planning, we've curated powerful new capabilities

    • Zoho Creator - 2023 Release Projection 1

      Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue

    • Zoho Creator User Group meetups in a city near you! - Oct - Nov, 2023

      Greetings from the Zoho Creator team! We're hosting a series of Zoho Creator meetups in various cities across the globe, and we'd love to meet you there! Our meetups are a great opportunity to network with industry peers, exchange ideas and best practices,

    • Zoho Creator - 2023 Release Projection 2

      Hello everyone! Time truly flies when you're having an incredible journey, and today we mark the completion of an eventful and action-packed six months. It feels like just yesterday when we embarked on this adventure together with the launch of our new

    • Upcoming Updates - August 2022

      Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. A

    • Recent Topics

    • BARCODE PICKLIST

      Hello! Does anyone know how the Picklist module works? I tried scanning the barcode using the UPC and EAN codes I added to the item, but it doesn’t work. Which barcode format does this module use for scanning?

    • Zoho Inventory - Allow Update of Marketplace Generated Sales Orders via API

      Hi Inventory Team, I was recently asked by a client to create an automation which updated a Zoho Inventory Sales Order if a Shopify Order was updated. I have created the script but I found that the request is blocked as the Sales Order was generated by

    • How do I create an update to the Cost Price from landed costs?

      Hi fellow Zoho Inventory battlers, I am new to Zoho inventory and was completely baffled to find that the cost price of products does not update when a new purchase order is received. The cost price is just made up numbers I start with when the product

    • 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

    • Zoho OAuth Connector Deprecation and Its Impact on Zoho Desk

      Hello everyone, Zoho believes in continuously refining its integrations to uphold the highest standards of security, reliability, and compliance. As part of this ongoing improvement, the Zoho OAuth default connector will be deprecated for all Zoho services

    • VoC in Zoho CRM is now data savvy: Explore response drilldown, summary components and participation in CRM criteria

      VoC has all the goods when it comes to customer intelligence—which is why we're constantly enhancing it. We recently added the following: A customer drilldown component that shows you the list of prospects and customers behind a chart's attribute Expanded

    • How do I bulk archive my projects in ZOHO projects

      Hi, I want to archive 50 Projects in one go. Can you please help me out , How can I do this? Thanks kapil

    • Error 0x800CCC0F Outlook

      Hello, i cannot send or receive email in outlook. can you please help. 'Sending' reported error (0x800CCC0F) : 'The connection to the server was interrupted. If this problem continues, contact your server administrator or Internet service provider (ISP).'

    • Passing the CRM

      Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine when

    • Can I add Conditional merge tags on my Templates?

      Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter

    • Zoho vault instal on windows

      I am trying to use Zoho Vault Desktop for Windows, but I am unable to complete the sign-in process. Problem description After logging in to my Zoho account and clicking Accept on the authorization page, nothing happens. The application does not proceed

    • Zoho Browser??

      hai guys, this sounds awkward but can v get a ZOHO BROWSER same as zoho writer, etc. where i can browse websites @ home and continue browsing the same websites @ my office, as v have the option in Firefox, once i save and close the browser and again when i open it i will be getting the same sites. If u people r not clear with my explanation, plz let me know. Thanks, Sandeep  

    • Let’s Talk Recruit: LinkedIn Cheatsheet

      Welcome to the first edition of Let’s Talk Recruit for 2026. We are kicking off the year by revisiting one of the most asked about topics in Zoho Recruit. How our LinkedIn integrations actually work and how recruiters can get the most value from them.

    • Zoho Forms API

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

    • Creating a Chart from a Report

      In Zoho Analytics, is it possible to create a chart from a Pivot View report? We are looking to use Zoho Analytics to replace Excel for Sales reports and would like to be able to show both the table and the chart together.

    • Ability to Set Client Name During Portal Invitation

      Hi Zoho Team, We would like to suggest an important enhancement to the Zoho Creator Client Portal functionality. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for creating

    • Move email between inboxes?

      Is it possible to move emails from one team inbox to another? We would like to be able to have a single "catch-all" inbox for incoming requests, and then move the email to the appropriate department inbox. I was hoping we would be able to accomplish this

    • PDF Attachment Option for Service Reports

      Hello Team, I would like to check with you all if there is an option to attach PDF documents to the service reports. When I try to attach a file, the system only allows the following formats: JPEG, JPG, and PNG. Could you please confirm whether PDF attachments

    • 【Zoho CRM】データ一覧画面でのメモのバッジ機能リリースのお知らせ

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。2026年度もゾーホーユーザーコミュニティをどうぞよろしくお願いいたします！ 今回は「Zoho CRM アップデート情報」の中から、新機能のデータ一覧画面でのメモのバッジ機能をご紹介します。 目次 概要　メモのバッジ機能について メモの作成について メモに関する様々な処理について 最近追加したメモについて メモのバッジの非表示について クライアントスクリプトの対応 概要　 メモのバッジ機能について 既存の活動バッジに加えて、すべてのタブのデータ一覧表示画面に、各データごとに利用できる「メモのバッジ」（キャプチャ内の赤枠部分）が新たに導入されました。

    • is it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?

      so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assign

    • Can’t find fsm in zoho one

      Every other app is available to me in Zoho one except fsm

    • Posibility to add Emoticons on the Email Subject of Templates

      Hi I´ve tried to add Emoticons on the Subject line of Email templates, the emoticon image does show up before saving the template or if I add the Emoticon while sending an Individual email and placing it manually on the subject line. Emoticons also show

    • Task Deletion Restriction & Strict Stage Control

      Hello Zoho Community, We have the following two issues currently pending and under testing, for which we require a workable and reliable solution: 1. Task Deletion Restriction We are testing ways to ensure that staff users are not able to delete tasks

    • Unable to mass update a picklist field

      Hello, I have the records within our Accounts module divided between two account types: Parent Accounts & Member Accounts. I am attempting to mass update accounts from one picklist value to the other (within other specific criteria in our custom fields)

    • Process checklist in CRM

      Hi We've created a new sales process that I'm mapping into the CRM - issue I have is that some of the tasks / milestones I would like to capture require very simple tick box responses but there are quite a few under a variety of sub categories so I don't

    • CRM project association via deluge

      I have created a workflow in my Zoho CRM for closing a deal. Part of this workflow leverages a deluge script to create a project for our delivery team. Creating the project works great however, after or during the project creation, I would like to associate

    • Holidays - Cannot Enter Two Holidays on Same Day

      I have a fairly common setup, where part-time employees receive 1/2 day's pay on a holiday and full-time employees receive a full day's pay. Historically, I've been able to accommodate this by entering two separate holidays, one that covers full-time

    • Where is the settings option in zoho writer?

      hi, my zoho writer on windows has menu fonts too large. where do i find the settings to change this option? my screen resolution is correct and other apps/softwares in windows have no issues. regards

    • File emails in Shared email folder

      Hi, I am unable to allow users to collaborate in Shared email folders: User 1 shares a folder let's say "SharedTopic" with full permissions Users 2 and 3 can see this folder but are unable to add emails to this folder or search in this folder. For example,

    • How create a draft via workflow?

      I wish to create a workflow rule for specific emails that creates a draft response - not an automatic email reply, but just a draft with a set response ready to be verified by an agent who can then manually select recipients. Alternatively, the workflow

    • This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

      Hi Team, when I,m trying to create a email account (imagixmidia.com.br) it's showing this error >>  This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details plz help me  thanks

    • How to manage task lists in Zoho Desk?

      Hello, I use Zoho Desk for IT customer support. I have a list of standard operating procedures (SOPs), including SOPs for onboarding new users, offboarding users, losing a device, etc. These are lists of tasks to be performed depending on the situation.

    • Zoho → ShipStation Integration – Sales Order–Driven Fulfilment Workflow

      Hello All, I’m reaching out to explore the best way to integrate a shipping tool into our inventory which will speed our process up. We are looking to integrate ShipStation into our existing order-to-fulfilment workflow, as we’re keen to standardise on

    • Business Day Logic Update: More Accurate Scheduling for Your Workflows

      Hello everyone, We’re improving how business-day calculations work in workflows, especially when triggers happen on weekends. This update ensures that offsets like +0, +1, and +2 business days behave exactly as intended, giving you clearer and more predictable

    • Convert Lead Automation Trigger

      Currently, there is only a convert lead action available in workflow rules and blueprints. Also, there is a Convert Lead button available but it doesn't trigger any automations. Once the lead is converted to a Contact/Account the dataset that can be fetched

    • Default Tagging on API-generated Transactions

      If one assigns tags to an Item or Customer, those tags get auto-populated in each line item of an Invoice or Sales Order when one creates those documents. However, if one creates the Sales Order or Invoice via the API (either directly coding or using

    • User

      If user is already part of manage engine endpoint central , what hapens when i try to add them to another Zoho org / directory? Are these users added as external users?

    • Adding a new section to the related details sidebar when creating a new ticket.

      Hello, I was wondering if you can add a new section to the related details sidebar when creating a new ticket. I was wanting to have it to where it also shows the account information related to the contact chosen as well. This is the section I am referring

    • Displaying only unread tickets in ticket view

      Hello, I was wondering if someone might be able to help me with this one. We use filters to display our ticket list, typically using a saved filter which displays the tickets which are overdue or due today. What I'd really like is another filter that

    • How to compare a subform lookup field that allows multiple entries when edited

      I have a form with a subform with multiple fields. One of the fields is a lookup field that allows a multi select. On edit validation, I want a workflow to execute only when the entries in that subform field has changed. The old. function is not working

    • Next Page