Column Operations
Adding Columns (Choose Columns)ā
Click Data ā Choose Columns or press Ctrl+Shift+C.
The field picker modal shows all available fields for the current DocType. Use the search box to find fields quickly. Check/uncheck fields to add/remove them. Click Apply.
Your selection is saved server-side per DocType per user ā it persists across sessions and devices.
Child table fields do not appear here. Child table data is accessed via the expand arrow (ā¶) on each row.
Reordering Columnsā
Drag any column header left or right to reorder it. A blue indicator line shows where the column will land. Release to drop.
The new column order is saved automatically to your user settings.
Resizing Columnsā
Drag the right edge of a column header to resize. Double-click the right edge of a column header to auto-fit the column to its content.
Resize state is saved per DocType per user.
Hiding Columnsā
Right-click a column header ā Hide Column. The column disappears.
To show hidden columns: right-click any visible column header ā Show Hidden Columns.
Formula Columnsā
You can add a computed column that runs a HyperFormula formula across all rows:
- Right-click any column header ā Insert Formula Column
- Name the column
- Enter a formula (e.g.,
=C1*D1to multiply Qty Ć Rate)
Formula column cells update automatically when their source cells change. Formula columns are not saved back to Frappe ā they are display-only.
Smart Lookup Columnsā
Smart Lookup adds columns from a related DocType. See Smart Lookup for the full guide.
After a Smart Lookup is applied, the joined columns appear at the right of the grid with an italic header. They are read-only in the grid (the underlying source document can be opened via the ID link).
Column Pinning (Freeze)ā
To keep the leftmost N columns visible while scrolling right:
- Click View ā Freeze Columns
- Enter the number of columns to freeze (e.g.,
2)
The frozen columns get a thicker right border. To unfreeze: View ā Freeze Columns ā set to 0.
Column Header Right-Click Menuā
Right-click any column header for:
| Option | Effect |
|---|---|
| Sort Ascending | Sort grid by this column AāZ / 0ā9 |
| Sort Descending | Sort grid by this column ZāA / 9ā0 |
| Insert Formula Column | Add a computed column to the right |
| Hide Column | Hide this column |
| Show Hidden Columns | Show all hidden columns |
| Column Width | Set exact width in pixels |
| Reset Width | Reset to default width |