Zoho CRM subforms vs related modules: which should you use?

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