Customizing Data Visibility in Child Tables
ERPNext provides an Editable Grid feature that allows users to add and edit records directly within a child table without opening a separate dialog box for each row. This makes data entry faster and more convenient.
1. Editable Grid
When the Editable Grid option is enabled for a child DocType, users can edit records directly from the table view.
By default, an editable grid displays a maximum of four columns in the child table.
2. Displaying Additional Columns
You can display additional fields as columns in the Editable Grid by configuring the child DocType.
For each field that should appear in the grid:
- Enter a value in the Column property.
- Enable the In List View option.
The value entered in the Column property determines the width allocated to that column in the grid.
Note: The combined value of all Column properties should not exceed 10.
3. Switching to an Uneditable Grid
If you want to display more information instead of editing records directly in the table, you can disable the Editable Grid.
To do this:
- Open Customize Form.
- Select the child DocType.
- Disable the Editable Grid option.
- Click Update.
When the Editable Grid is disabled, each row opens as a detailed form, allowing more fields to be displayed in the row preview.
4. Showing Fields in the Preview
To display a field in the preview of an uneditable child table:
- Open Customize Form for the child DocType.
- Enable the In List View property for the required fields.
- Save the changes.
Only fields marked with In List View are displayed in the child table preview.
5. Benefits
- Speeds up data entry with inline editing.
- Allows customization of visible columns.
- Provides flexibility between editable and detailed views.
- Improves readability by showing only relevant fields.
- Helps optimize child tables for different business requirements.
