[Skip to content](#main)

[→](/)

[![Avunu](/brand/avunu-logo.svg)![Avunu](/brand/avunu-logo-light.svg)](/)[Services](/services/)[Consulting](/services/consulting/)[ERP](/services/erp/)[Odoo](/services/erp/odoo/)[ERPNext](/services/erp/erpnext/)[Custom software](/services/custom-software/)[Devices & IoT](/services/devices-iot/)[Websites](/services/websites/)[Infrastructure](/services/infrastructure/)[Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

[About Avunu](/about/)[Team](/about/team/)[Insights](/insights/)[Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

- [Services](/services/)[Consulting](/services/consulting/)
- [ERP](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)
- [Partners](/partners/)

[Work](/work/)[Open source](/open-source/)[Knowledge base](/kb/)[About](/about/)

- [About Avunu](/about/)
- [Team](/about/team/)
- [Insights](/insights/)
- [Contact](/contact/)

[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

[Knowledge base](/kb/)[Frappe](/kb/frappe/)Grandchild Table Fields

Search the knowledge basePress/

ESC

Jump to

[Browse the knowledge base](/kb/)[Frappe](/kb/frappe/)[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

↵select↑↓navigateescclose

Search the knowledge base

[Skip to the article](#kb-article)[Frappe](/kb/frappe/)20 articles

- [Overview](/kb/frappe/)
- [Bench Operations](/kb/frappe/bench-operations/)
- [Builder Page Scripts](/kb/frappe/builder-page-scripts/)
- [Client-Side Recipes](/kb/frappe/client-side-recipes/)
- [Common Query Patterns](/kb/frappe/common-query-patterns/)
- [Custom Field Controllers](/kb/frappe/custom-field-controllers/)
- [Custom Pages](/kb/frappe/custom-pages/)
- [Custom Views](/kb/frappe/custom-views/)
- [Customizations API](/kb/frappe/customizations-api/)
- [Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)
- [Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)
- [Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)
- [Portal Views](/kb/frappe/portal-views/)
- [Project Structure & Hooks](/kb/frappe/project-structure-hooks/)
- [Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)
- [Quick Entry Forms](/kb/frappe/quick-entry-forms/)
- [Script Reports](/kb/frappe/script-reports/)
- [Testing on Live Databases](/kb/frappe/testing-live-databases/)
- [Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)
- [Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)
- [Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

In Frappe: 20 articles

[Overview](/kb/frappe/)[Bench Operations](/kb/frappe/bench-operations/)[Builder Page Scripts](/kb/frappe/builder-page-scripts/)[Client-Side Recipes](/kb/frappe/client-side-recipes/)[Common Query Patterns](/kb/frappe/common-query-patterns/)[Custom Field Controllers](/kb/frappe/custom-field-controllers/)[Custom Pages](/kb/frappe/custom-pages/)[Custom Views](/kb/frappe/custom-views/)[Customizations API](/kb/frappe/customizations-api/)[Customizing Grid Columns for Child Tables](/kb/frappe/customizing-grid-columns-child-tables/)[Doctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)[Grandchild Table Fields](/kb/frappe/grandchild-table-fields/)[Portal Views](/kb/frappe/portal-views/)[Project Structure & Hooks](/kb/frappe/project-structure-hooks/)[Query Builder & PyPika Extensions](/kb/frappe/query-builder-pypika/)[Quick Entry Forms](/kb/frappe/quick-entry-forms/)[Script Reports](/kb/frappe/script-reports/)[Testing on Live Databases](/kb/frappe/testing-live-databases/)[Type Annotations & Controller Overrides](/kb/frappe/type-annotations-controller-overrides/)[Vite & TypeScript Compilation](/kb/frappe/vite-typescript-compilation/)[Web Forms](/kb/frappe/web-forms/)

Other sections[ERPNext](/kb/erpnext/)[Odoo](/kb/odoo/)[WordPress](/kb/wordpress/)[NixOS](/kb/nixos/)[Email](/kb/email/)[Linux](/kb/linux/)[Databases](/kb/databases/)[Containers](/kb/containers/)[Proxmox](/kb/proxmox/)[Git & Dev Tools](/kb/git-and-dev-tools/)

FrappeGrandchild Table Fields

Render editable tables inside child table rows by storing the grandchild data as JSON.

UpdatedMar 13, 2026

Tagsfrappechild-tablejavascriptjson

Reading time4 min

On this page[The Problem](#the-problem)[The Solution](#the-solution)[Doctype Setup](#doctype-setup)[Parent: Shipping Package](#parent-shipping-package)[Child: Shipping Package Item Capacity](#child-shipping-package-item-capacity)[JavaScript Implementation](#javascript-implementation)[How It Works](#how-it-works)[Data Flow](#data-flow)[Considerations](#considerations)

Frappe doesn't natively support tables within child table rows (grandchild tables). This pattern works around the limitation using JSON storage and virtual table rendering.

## The Problem

You have a parent document with a child table (e.g., Shipping Package → Item Capacity rows). Each child row needs its *own* editable sub-table of data (e.g., multiple UOM/quantity pairs per item capacity slot).

Frappe's child table (`Table` fieldtype) only supports one level of nesting.

## The Solution

Store grandchild data as **JSON** in a field on the child doctype

Render a **virtual editable table** when the child row's edit form opens

**Sync changes** back to the JSON field on edit

## Doctype Setup

### Parent: Shipping Package

Has a standard `Table` field:

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">{</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldname"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"item_capacity"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldtype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Table"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"options"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Shipping Package Item Capacity"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

### Child: Shipping Package Item Capacity

Has a `JSON` field for grandchild data and a `Data` field for display summary:

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">{</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fields"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldname"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"capacity_sets"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldtype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"JSON"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"label"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Capacity Sets"</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldname"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"description"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"fieldtype"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Data"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"label"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Description"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"in_list_view"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    ],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#7EE787;--shiki-light:#116329">"istable"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">}</span>
```

The `description` field shows a human-readable summary in the grid (e.g., "Pound × 5 | Ounce × 10").

## JavaScript Implementation

Hook into the child table's `form_render` event to replace the JSON field with a virtual table:

```
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">frappe.ui.form.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">on</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Shipping Package Item Capacity"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">form_render</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">function</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">frm</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">cdt</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">cdn</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> child_row </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> locals[cdt][cdn];</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> dialog </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frm.fields_dict.item_capacity.grid.open_grid_row;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">if</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (</span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">!</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">dialog) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">return</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Get the wrapper for the capacity_sets field</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> wrapper </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> dialog.fields_dict.capacity_sets.wrapper;</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        wrapper.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">replaceChildren</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">();</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Create an in-memory FieldGroup with a virtual Table field</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> field_group </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">new</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frappe.ui.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">FieldGroup</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">({</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            fields: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Table"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"capacity_table"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    in_place_edit: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">true</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    data: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">JSON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">parse</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(child_row.capacity_sets </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"[]"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">),</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    fields: [</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"uom"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            label: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"UOM"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Link"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            options: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"UOM"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            in_list_view: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            reqd: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            fieldname: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"qty"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            label: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Quantity"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            fieldtype: </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"Int"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            in_list_view: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                            reqd: </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">1</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                        },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    ],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    </span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">get_data</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">: () </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> field_group.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">get_value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"capacity_table"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">),</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            ],</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            body: wrapper,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        });</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        field_group.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">make</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">();</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Connect virtual grid to parent document</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// (required for Link fields to resolve properly)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        field_group.fields_dict.capacity_table.grid.doc </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> frm.doc;</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Sync changes back to the JSON field</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        field_group.fields_dict.capacity_table.grid.wrapper.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">on</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"change"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">,</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            () </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> {</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">let</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> field_group.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">get_value</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">"capacity_table"</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Sort for consistent display</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                data.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">sort</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">a</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">, </span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">b</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> (a.uom </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">""</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">).</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">localeCompare</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(b.uom </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">||</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">""</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">));</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Store as JSON</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                child_row.capacity_sets </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#79C0FF;--shiki-light:#0550AE">JSON</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">stringify</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(data);</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                </span><span style="--shiki-dark:#8B949E;--shiki-light:#6E7781">// Update the summary description for the grid view</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                child_row.description </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> data</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    .</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">filter</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row.qty </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">&&</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> row.uom)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    .</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">map</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">((</span><span style="--shiki-dark:#FFA657;--shiki-light:#953800">row</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">) </span><span style="--shiki-dark:#FF7B72;--shiki-light:#CF222E">=></span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328"> </span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">`${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">row</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">uom</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">} × ${</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">row</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">.</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">qty</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">}`</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">)</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                    .</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">join</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">(</span><span style="--shiki-dark:#A5D6FF;--shiki-light:#0A3069">" | "</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">);</span>

<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">                frm.</span><span style="--shiki-dark:#D2A8FF;--shiki-light:#8250DF">dirty</span><span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">();</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">            }</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">        );</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">    },</span>
<span style="--shiki-dark:#E6EDF3;--shiki-light:#1F2328">});</span>
```

## How It Works

**`form_render` event** fires when a child row's inline form opens (clicking the row or the expand button).

**Access the child row data** via `locals[cdt][cdn]` — this is the standard Frappe pattern for accessing child document data in form events.

**Get the grid dialog** via `frm.fields_dict.item_capacity.grid.open_grid_row` — this is the currently open row's form container.

**Replace the JSON field's wrapper** — `wrapper.replaceChildren()` clears the default JSON textarea.

**Create a `frappe.ui.FieldGroup`** with a `Table` fieldtype — this renders a full editable grid inside the child form. Key properties:

`in_place_edit: true` — Enables direct cell editing

`data` — Initial values parsed from the JSON field

`fields` — Column definitions (Link, Int, Float, etc.)

`get_data` — Callback for the grid to fetch current data

**Connect to parent document** — `field_group.fields_dict.capacity_table.grid.doc = frm.doc` ensures Link fields can access the parent document's context.

**Sync on change** — The grid wrapper's `change` event serializes data back to JSON, updates the display summary, and marks the form dirty.

## Data Flow

```text
Database:  capacity_sets = '[{"uom":"Pound","qty":5},{"uom":"Ounce","qty":10}]'
                ↓ parse
Virtual table: | UOM    | Qty |
               | Pound  | 5   |
               | Ounce  | 10  |
                ↓ serialize on change
JSON field: '[{"uom":"Ounce","qty":10},{"uom":"Pound","qty":5}]'  (sorted)
Summary:    "Ounce × 10 | Pound × 5"
```

## Considerations

**No server-side validation of grandchild structure** — The JSON field stores arbitrary data. Add Python-side validation in the parent's `validate()` method if needed.

**No query access** — You can't filter or search by grandchild data using Frappe's query builder. Use `JSON_EXTRACT` in raw SQL if needed.

**Performance** — This pattern works well for small amounts of grandchild data (< 50 rows). For larger datasets, consider a proper child doctype with a Link back to the parent's child row.

Need help with Frappe?

Our notes can take you a long way, but sometimes you'd rather have someone who's done it before.

[ERPNext implementation](/services/erp/erpnext/)

[← PreviousDoctype States & Status Fields](/kb/frappe/doctype-states-status-fields/)[Next →Portal Views](/kb/frappe/portal-views/)

CC0This article is in the public domain ([CC0 1.0](https://creativecommons.org/publicdomain/zero/1.0/)), code samples included. Use it however helps you.

On this page

- [The Problem](#the-problem)
- [The Solution](#the-solution)
- [Doctype Setup](#doctype-setup)
- [Parent: Shipping Package](#parent-shipping-package)
- [Child: Shipping Package Item Capacity](#child-shipping-package-item-capacity)
- [JavaScript Implementation](#javascript-implementation)
- [How It Works](#how-it-works)
- [Data Flow](#data-flow)
- [Considerations](#considerations)

[Back to top↑](#top)

Services

- [ERP implementation](/services/erp/)
- [Odoo](/services/erp/odoo/)
- [ERPNext](/services/erp/erpnext/)
- [Custom software](/services/custom-software/)
- [Devices & IoT](/services/devices-iot/)
- [Websites](/services/websites/)
- [Infrastructure](/services/infrastructure/)

Resources

- [Our work](/work/)
- [Open source](/open-source/)
- [Knowledge base](/kb/)
- [Insights](/insights/)

Company

- [About](/about/)
- [Team](/about/team/)
- [Partners](/partners/)
- [Contact](/contact/)

Clients

- [Project portal](https://erp.avunu.net/projects)
- [Invoices](https://erp.avunu.net/)
- [Support](https://erp.avunu.net/)

[![Avunu](/brand/avunu-logo-light.svg)](/)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M20.400 20.500h-3.600v-5.600c0-1.300 0-3-1.800-3s-2.100 1.400-2.100 2.900v5.700H9.400V9h3.400v1.600c.5-.9 1.600-1.900 3.400-1.900 3.600 0 4.300 2.400 4.300 5.500v6.300zM5.300 7.400a2.100 2.100 0 1 1 0-4.100 2.100 2.100 0 0 1 0 4.100zm1.800 13.100H3.600V9h3.500v11.500zM22.200 0H1.800C.8 0 0 .8 0 1.700v20.600c0 .9.800 1.700 1.800 1.700h20.400c1 0 1.800-.8 1.800-1.700V1.700C24 .8 23.200 0 22.200 0z">\</path>\</svg>\</av-icon>](https://www.linkedin.com/company/avunu)[\<av-icon data-jx-static>\<svg viewBox="0 0 24 24" width="20" height="20" fill="currentColor" stroke="none" stroke-width="1.6" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true" focusable="false">\<path d="M12 .3a12 12 0 0 0-3.8 23.4c.6.1.8-.3.8-.6v-2c-3.3.7-4-1.6-4-1.6-.6-1.4-1.4-1.8-1.4-1.8-1-.7.1-.7.1-.7 1.2.1 1.8 1.2 1.8 1.2 1 1.8 2.8 1.3 3.5 1 .1-.8.4-1.3.7-1.6-2.7-.3-5.5-1.3-5.5-5.9 0-1.3.5-2.4 1.2-3.2-.1-.3-.5-1.5.1-3.2 0 0 1-.3 3.3 1.2a11.500 11.500 0 0 1 6 0c2.300-1.500 3.300-1.200 3.300-1.200.6 1.700.2 2.900.1 3.200.8.8 1.200 1.900 1.200 3.200 0 4.600-2.800 5.600-5.500 5.900.4.400.8 1.100.8 2.200v3.300c0 .3.2.7.8.6A12 12 0 0 0 12 .3">\</path>\</svg>\</av-icon>](https://github.com/Avunu)[Client portal](https://erp.avunu.net/projects)[Start a project](/start/)

Avunu LLC · 948 East Philadelphia Street, York, PA 17403 · (717) 814-8540Knowledge base articles are in the public domain[Privacy](/privacy/)[Terms](/terms/)
