Frequently Asked Questions on Subforms

Frequently Asked Questions on Subforms

Hello all!

Welcome back to another post in our Kaizen series.
In this post, we will address the most frequently asked questions about Zoho CRM Subforms from the Zoho CRM Developer Community Forum.

Subforms

Subforms allow users to capture multiple records related to a single record in a structured format. They represent one-to-many relationships, such as listing multiple products associated with a single quote.

1. Can subforms be marked as required?

Yes, subforms can be marked as required.



2. What happens if I mark a subform as required?

When you mark a subform as required, the subform must contain values in at least one row for the record to be saved. 

3. Can fields be marked as mandatory in subforms?

Yes, individual fields within a subform can be marked as mandatory.



4. What happens if I add data to a Subform that is not mandatory, but leave the mandatory fields empty?

Your subform will not be saved unless all the mandatory fields are populated. If you have data to add to a subform, you must fill in all mandatory fields in a row you populate. 

5. Are subform fields supported in the Blueprint transition?

System-defined subforms(Line Items) in the Inventory modules can be associated with the "During Transition" phase. These subform fields can be found under "Associated Items." To access them, go to During Transition > Add > Associated Items, where you can see the Inventory modules. Note that, by default, the line items will be marked as mandatory.



6. Can I use custom subform fields from the Inventory modules in the "During Transition" phase?

Only system-defined subform fields are supported in the "During Transition" phase. Custom subform fields cannot be used.

7. How many records (rows) can be added to system-defined subforms in Inventory modules such as Quotes, Invoices, Sales Orders, and Purchase Orders?

A maximum of 200 rows can be added to system-defined subforms in the Inventory modules.

8. What happens if I add a custom subform to an inventory module?

 By default, inventory modules have a total limit of 200 rows across all subforms in the module, including custom and system-defined subforms. If you add a custom subform with a row limit (e.g., 50 rows), you will need to reduce the row limit for the Line Item subform accordingly (e.g., to 150 rows). If the total limit is not within 200, you will get an error when you try to save the module.

You can update the row limits using the "Maximum row entries allowed" option. To do this, go to Setup > Customization > Modules and Fields > Select the module (e.g., Quotes) > Subform Section > Gear Icon > Edit Properties > Maximum row entries allowed.

9. How many subform rows can be created per subform in modules other than Inventory modules?

A maximum of 100 rows can be created per subform in modules other than Inventory modules.

10. How many columns can a subform support?

A subform can support up to 25 columns, meaning you can add a maximum of 25 fields.

11. How many subforms can be created per module?

The number of subforms that can be created per module depends on the edition:
  • Enterprise and Zoho One: 2 subforms.
  • CRM Plus and Ultimate: 5 subforms.

12. Can we create a custom subform in the Professional edition?

System-defined subforms are available in inventory modules like Quotes, Invoices, Sales Orders, and Purchase Orders. However, custom subforms can only be created in the Enterprise edition and above.

13. Can we trigger workflows based on changes to subform fields?  

As of September 2024, triggering workflows based on changes to subform fields is yet to be supported.

14. Can we use custom functions to manipulate subforms?

Yes! You can use custom functions to manipulate subforms through the parent record. 

15. How do I retrieve subform data in a module using the Search and COQL APIs?

To retrieve subform module data via the Search and COQL APIs, you need to use its corresponding subform module's API name instead of its parent module API name. For more details, refer to our Kaizen post: Kaizen #124 - Manipulating Subform using Zoho CRM APIs.

16. Can subforms be included in reports?

Yes, you can create reports based on subforms present in the module to analyze related data.

17. Can I import subform records when I import records in bulk to Zoho CRM using the Bulk Write API?

Yes, you can insert subform records along with the parent record using the Bulk Write API. For more details, refer to our Kaizen post: Kaizen #131 - Bulk Write for parent-child records using Scala SDK.





    Access your files securely from anywhere







                        Zoho Developer Community





                                              Use cases

                                              Make the most of Zoho Desk with the use cases.

                                               
                                                

                                              eBooks

                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                               
                                                

                                              Videos

                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                               
                                                

                                              Webinar

                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                               
                                                
                                              • Desk Community Learning Series


                                              • Meetups


                                              • Ask the Experts


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                                        • Sticky Posts

                                                        • 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 #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.
                                                        • 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


                                                        Manage your brands on social media



                                                              Zoho TeamInbox Resources



                                                                  Zoho CRM Plus Resources

                                                                    Zoho Books Resources


                                                                      Zoho Subscriptions Resources

                                                                        Zoho Projects Resources


                                                                          Zoho Sprints Resources


                                                                            Qntrl Resources


                                                                              Zoho Creator Resources



                                                                                  Zoho CRM Resources

                                                                                  • CRM Community Learning Series

                                                                                    CRM Community Learning Series


                                                                                  • Kaizen

                                                                                    Kaizen

                                                                                  • Functions

                                                                                    Functions

                                                                                  • Meetups

                                                                                    Meetups

                                                                                  • Kbase

                                                                                    Kbase

                                                                                  • Resources

                                                                                    Resources

                                                                                  • Digest

                                                                                    Digest

                                                                                  • CRM Marketplace

                                                                                    CRM Marketplace

                                                                                  • MVP Corner

                                                                                    MVP Corner







                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now


                                                                                        Zoho Show Resources


                                                                                          Zoho Writer Writer

                                                                                          Get Started. Write Away!

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

                                                                                            Zoho CRM コンテンツ






                                                                                              Nederlandse Hulpbronnen


                                                                                                  ご検討中の方




                                                                                                        • Recent Topics

                                                                                                        • MS Teams for daily call operations

                                                                                                          Hello all, Our most anticipated and crucial update is finally here! Organizations using Microsoft Teams phone system can now integrate it effectively with Zoho CRM for tasks like dialling numbers and logging calls. We are enhancing our MS Teams functionality
                                                                                                        • Assistance Required: Authentication Error When Sending Credit Application Form

                                                                                                          Hi, I'm encountering an error message that states: "Authentication unsuccessful – the user credentials were incorrect." This occurs when I attempt to send the credit application form to our customers. I've attached the form I’m trying to send for your
                                                                                                        • Can zoho sign collect data feeding Zoho Sign?

                                                                                                          I m sending contracts to client who are not in my zoho CRM database yet. Can the data they enter in Zoho sign contract I send them, (that includes...) official company name address first name second name etc, ...Create or update a contact / account
                                                                                                        • Sync desktop folders instantly with WorkDrive TrueSync (Beta)

                                                                                                          Keeping your important files backed up and accessible has never been easier! With WorkDrive desktop app (TrueSync), you can now automatically sync specific desktop folders to WorkDrive Web, ensuring seamless, real-time updates across devices. Important:
                                                                                                        • 6 time-saving tips for working with tables in Zoho Writer

                                                                                                          Tables have always been the best way to represent data. They help you structure and categorize information systematically and present them in a simpler way. While tables in Zoho Writer are easy to implement, some tasks might not be that obvious.  Here are some time-saving tips to help you work better with tables in Zoho Writer:    1. Insert Multiple Rows / Columns in a Table Adding more rows and columns is the most common action performed while working with tables. Instead of using the Table tab,
                                                                                                        • Modified approved time log

                                                                                                          I can’t seem to find a way to make change to approve time log entry. The case is the following. We pay the employees every 2 weeks, so employe A enter is time for the 2 weeks and then submit his timesheet. Now is superior approve the time he worked via
                                                                                                        • Question Regarding Deleted Reports in Zoho Desk Analytics

                                                                                                          Dear Zoho Desk Support Team, I hope this message finds you well. We have a question regarding the Analytics module in Zoho Desk, specifically related to deleted reports/dashboards. We would like to understand the following: Is there a recycle bin, recovery
                                                                                                        • Making money out of Zoho Sheets - How?

                                                                                                          Hello, Suppose I come up with a brilliant Zoho Sheet that I want to sell to other people, can I do this? How? Thanks.
                                                                                                        • Adding Columns to Reports

                                                                                                          Hi, Is it possible to choose fields to be added as columns in the reports? Thank you.
                                                                                                        • Sudden Layout Issue After Last CSS Update for ZML (Temporary Fix Inside)

                                                                                                          Hi, Our clients have noticed today that every section laid out with ZML suddenly shows an unwanted top padding/blank space that interrupts the user screens. It appears that Zoho has changed the default CSS for the .zcp-col.zcp-panel-rowtype-auto element.
                                                                                                        • What are people using to send Service based emails?

                                                                                                          Zoho Campaigns is for marketing. Users can unsubscribe from these emails. Service based emails need to be delivered and can without the worry of Can-spam act. What are people using to send service based emails? My mailing list is derived from a database
                                                                                                        • Client Script also planned for Zoho Desk?

                                                                                                          Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field
                                                                                                        • Introducing Zoho Commerce 2.0 — It's more than just selling!

                                                                                                          Hello! We are proud to launch Zoho Commerce 2.0, a reimagination of how online businesses look, feel, and function. This launch is both timely and symbolic, as we reaffirm our commitment to empowering small and medium enterprises with powerful, yet simple-to-use
                                                                                                        • Kits: Option to Hide Associate Items on Documents

                                                                                                          The new Kit type of Composite Item is very helpful, and we're already using it in several different ways. One problem is that there seems to be no way to hide the components on some documents, including Package Slips. There is an option given in settings
                                                                                                        • Unable to display field label from a hidden Single Line Textbox in Description

                                                                                                          Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, and
                                                                                                        • An Exclusive Session for Zoho Desk Users: AI in Zoho Desk

                                                                                                          A Zoho Community Learning Initiative Hello everyone! This is an announcement for Zoho Desk users and anyone exploring Zoho Desk. With every nook and corner buzzing, "AI's here, AI's there," it's the right time for us to take a closer look at how the AI
                                                                                                        • Email for customer to provide payment information

                                                                                                          Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?
                                                                                                        • Ticket Automatically Created from Closed Chat

                                                                                                          Is there a way to prevent a ticket being create for every chat.... or at the very least have it automatically closed.
                                                                                                        • I want to Show the product list based on the drop Down

                                                                                                          in quotation app , amc form form i have Department drop down field and in subform i have loop up field item description taken from the anothe app PRO I want to show the product list look up based on the deparment selected example if they selected deparment
                                                                                                        • Bad User: Authenticated but not connected

                                                                                                          Zoho CRM cannot send/receive emails and it appears as if it may be an api configuration change either via Zoho or MS. Does anyone have information on how to fix this error message? I am admin on all my accounts. Zoho and MS are blaming each other.
                                                                                                        • Zoho + ERP (SAP)

                                                                                                          First of all: I'm using Zoho CRM and I have complete right that it's a brilliant solution for sales force. But, in my new job, doesn't exist a CRM system and I want propose Zoho CRM. In the company, we're using a ERP (SAP), a few time ago. I would like to know about integration between Zoho CRM and ERP (SAP), as possible? How I can do that? Regards, Renato Lima
                                                                                                        • Lookup fields

                                                                                                          Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules
                                                                                                        • Sort data in Pivot Table

                                                                                                          Is it possible to sort by a data field. I can gruop and filter, but I culdn't find how to sort the results. Tank You.
                                                                                                        • Inventory Barcode Creation - Add Picture of Item

                                                                                                          Hi I am trying to set up bar code labels and include a picture of the item on the label - any idea on how to add that field to the barcode generator?
                                                                                                        • Shared Snippets Everyone

                                                                                                          Hi, Now that the Shared Snippets have been released and I think will be the most used feature implemented in 2023 :) Creating and Using Snippets in Ticket Responses - Online Help | Zoho Desk Maintain consistency in ticket responses with shared snippets
                                                                                                        • Please Enable Snippets for Agents Adding Comments

                                                                                                          Snippets and templates are currently enabled for agents when they use the reply functionality. There is currently no way to add a template or snippets when an agent comments. This is really weird. Our agents don't use the reply functionality, only the
                                                                                                        • Topics assigned to Contacts in Campaigns

                                                                                                          I have yet to find an efficient way to assign topics to contacts in campaigns with the new system in place.  We have daily contacts added to our system through various forms and we have to manually go in and add topics to contacts before each email campaign
                                                                                                        • CRM Email Insights Not Working - Status not Changing

                                                                                                          I used to be able to see if a customer opened/read an email in CRM, but I no longer get those status changes inside their record. I have everything enabled and I am sending the email from CRM. The experience center has the status' enabled as well. Any
                                                                                                        • Product and Service

                                                                                                          Hi guys, there is a difference between layout of product and service if Long Description field have some kind of text. Please see screenshot 1 for Service here: https://prnt.sc/7xWwPKd29nWP for Product here: https://prnt.sc/LGmtVd_U6H7q As you can see
                                                                                                        • The Urgent Need for Native Brazilian Payment Integrations: PIX and Direct Bank Connections

                                                                                                          Hello Zoho Team, I am writing to emphasize a critical functionality gap for Zoho Books in the Brazilian market: the lack of modern, native payment gateway integrations. The current options are insufficient. The Mercado Pago integration, for instance,
                                                                                                        • Better implementation of Item Category on Invoices and Estimates

                                                                                                          1) I have added Item Category as a custom field. Honestly, this should be a native part of the item itself, and either required, optional, or not used.  2) When entering an item on an invoice, you have to enter the first character(s) of the item, otherwise
                                                                                                        • Try CRM for everyone button in the way of workflow

                                                                                                          Please consider using the bottom bar for offers. Using the top bar for offers like "Try CRM for everyone" really gets in the way of my day to day workflow.
                                                                                                        • Zoho Signature, "For Demo Purpose Only Powered by Zoho Sign"

                                                                                                          How to disable this text on the documents for signature. "For Demo Purpose Only Powered by Zoho Sign"
                                                                                                        • Zoho CRM email formatting issues

                                                                                                          I have been having a hard time with formatting email templates. It feels like Zoho email is "fighting my edits." It refuses to change size, font, etc. Sometimes, the template looks great, then when the email gets sent, it looks completely different- some
                                                                                                        • Weekly Tips : Seamlessly collaborate with Share Drafts in Zoho Mail

                                                                                                          Ever found yourself stuck wondering how to get input on an important email draft without actually sending it? Maybe you want a teammate’s feedback or approval from your manager—without exposing sensitive info. Or perhaps you are working across different
                                                                                                        • How to Share a workdrive folder outside organization ?

                                                                                                          Hi, Earlier we were using Google Suite and were able to share the google drive folders with external organization ( Auditors , marketing collaterals ) as most of them had a personal gmail account they were able to access it without any issue. How can
                                                                                                        • Zoho CRM Account Duplication via Credit Application Form

                                                                                                          Hi, We send a credit application link to our customers via email, which is managed through Zoho Campaigns. When a customer submits the form, it automatically creates a new account in Zoho CRM. We would like to know how to stop this from creating duplicate
                                                                                                        • Multi file upload

                                                                                                          Hi, I just wonder if one could upload multiple files in one shot, say between one and three files, without adding multiple File Upload fields? Thanks, Alalbany
                                                                                                        • Flexible Milestone Invoicing

                                                                                                          If your Zoho Projects portal is integrated with Zoho Invoice/Books, you can now create an invoice for your milestones. You can enable it under Integration Preference and invoice milestones regardless of the project's billing type. For instance, consider
                                                                                                        • The get records i am getting produts that show in the show in the sub form item list field

                                                                                                          The get records i am getting produts that show in the show in the sub form item list field if(input.Department != null) { // Get filtered records once creator_ptid = zoho.creator.getRecords("harshadgroup","item-master","All_Products","Department == \""
                                                                                                        • Next Page