Disclosure: Skyfall Labs is an official Zoho Partner. This is a cross-post of our guide; the original, with sources, is at https://www.skyfallhq.net/resources/zoho-crm-subforms-vs-related-modules

Short answer: a subform is a table of line items inside one record. It suits small, fixed-shape lists such as order lines. If the child data needs its own searching, filtering, workflows or ownership, Zoho's help suggests it will not work well in a subform, because several features do not reach subform fields. Zoho's pages also disagree on which editions allow custom subforms, so check your own account first.

What a subform is, per Zoho

Zoho describes a subform as a secondary form or table that lets you add multiple line items to a primary record, creating a one-to-many relationship. There are two types, Standard and Static, and the type cannot be changed after the subform is added to a layout. Standard lets users add rows with predefined fields as columns, with the maximum rows set between 1 and 100. Static has a fixed number of rows with predefined values for some fields, capped at 25 per subform per layout.

Source: Zoho Help: Subforms

Limits worth knowing before you build

  • Columns: Zoho's help says a subform allows a maximum of 25 fields per layout; the Kaizen FAQ says up to 25 columns per subform.
  • Rows: up to 100 per subform outside inventory modules. Inventory modules (Quotes, Invoices, Sales Orders, Purchase Orders) allow up to 200 rows, and that 200 is a combined cap across all subforms in the module, custom and system-defined.
  • Subforms are not available for Tasks, Calls, Meetings or Pricebooks.
  • Subforms and their fields are specific to each layout.
  • Fields from a lookup module can be shown in a subform but are not synced with the source module, and are not populated during lead conversion, quote conversion, API updates, data migration or import.

Source: Zoho Help: Subforms, Zoho Community: Kaizen #155 - Frequently Asked Questions on Subforms

Where Zoho says subform fields do not work

This is the list that usually decides the question. Per Zoho's subform help page, subform fields do not appear in custom view columns, advanced filters, layout rules, Blueprint validation, web forms, import, global search, template merge fields, validation rules, or workflow field update and criteria. The Kaizen FAQ adds that triggering workflows on subform field changes was not supported as of September 2024 and may have changed since.

What does work: Zoho says subforms can be selected as related modules in reports, so you can build summary reports and dashboards from them, and subforms can be added to mail merge templates. Aggregate fields (SUM, AVG, MAX, MIN or formula-based) can total the rows on the parent record.

Source: Zoho Help: Subforms, Zoho Community: Kaizen #155 - Frequently Asked Questions on Subforms

Which editions allow custom subforms (Zoho's pages conflict)

Zoho's subform help page says subforms are available in Professional and above, with 1 subform per module in Professional, 2 in Enterprise and 5 in Ultimate. Zoho's Kaizen FAQ says Professional has no custom subforms (only system-defined ones in inventory modules), Enterprise and Zoho One get 2, and CRM Plus and Ultimate get 5, and that custom subforms need Enterprise or higher.

We cannot tell you which is current. Advice: check the Feature Availability page and your own Setup before designing around a subform, because the answer changes whether a Professional account can use this approach at all.

Source: Zoho Help: Subforms, Zoho Community: Kaizen #155 - Frequently Asked Questions on Subforms

A practical decision guide (advice, not vendor documentation)

  • Use a subform when the rows only make sense inside one parent record, are few, and mostly need totals: order lines, a list of attendees, simple specification rows.
  • Use a related or custom module when you need to filter or search the rows, put them in custom views, trigger workflows on them, validate them with validation rules, import them, or give them their own owner and permissions. Our custom modules guide covers that choice.
  • If you are unsure, list the five questions people will ask of that data. If most start with "show me all the rows where...", a subform will frustrate you given the exclusions above.

Existing setup that does not behave? Typical causes

Per Zoho, if a subform is required it must have values in at least one row before the record saves, and if a row contains any data, all mandatory fields in that row must be filled. Users who describe a record that "will not save" with no visible error often hit this. Bulk addition of rows via lookup is, per Zoho, being released in phases, so what you see may differ from a colleague's account.

Skyfall Labs reviews Zoho CRM data models and can restructure a subform into a related module, or the reverse, with data migration. Because we are a Zoho Partner, treat our view with the interest we have disclosed.

Source: Zoho Help: Subforms, Zoho Community: Kaizen #155 - Frequently Asked Questions on Subforms

Frequently asked questions

What is the difference between a subform and a related module in Zoho CRM?

Per Zoho, a subform is a table of line items inside a primary record. Zoho's help lists many features that do not reach subform fields, including custom views, advanced filters, global search, import and workflow criteria, so child data that needs those usually belongs in its own module.

How many rows can a Zoho CRM subform have?

Per Zoho's Kaizen FAQ, up to 100 rows per subform outside inventory modules, and up to 200 in inventory modules as a combined cap across all subforms. Static subforms are capped at 25 rows per layout.

Can I use workflows on subform fields?

Zoho's help lists workflow field update and criteria among the places subform fields do not appear, and its Kaizen FAQ said triggering workflows on subform changes was unsupported as of September 2024. Check current behaviour in your account.

Which Zoho CRM editions include custom subforms?

Zoho's pages conflict. One says Professional and above with 1 subform in Professional; another says custom subforms need Enterprise or higher. Confirm on Zoho's feature availability page.

Can I import subform data?

Zoho's subform help page lists import among the places subform fields do not appear. The Kaizen FAQ says the Bulk Write API can insert subform records together with their parent record.

Can I report on subform data?

Yes. Per Zoho, subforms can be selected as related modules in reports, and you can build summary reports and dashboards from them.

Sources

Need hands-on help? Skyfall Labs offers Zoho consulting, implementation and customization. Original guide: https://www.skyfallhq.net/resources/zoho-crm-subforms-vs-related-modules