Documentation
Getting Started
Modeling
Business Rules
Approvals
Users, Roles & Security
Administration
Integration & API
Installation
Migrating from MDS
Architecture
Documentation/Data Grid/Selection & Bulk Operations

Selection & Bulk Operations

The grid has two independent selections: checked rows, which drive the toolbar buttons, and selected cells, which drive the clipboard. The status bar always says which one is active.

Check rows

The leftmost column holds a checkbox per row.

  • Click a checkbox to check or uncheck one row
  • Use the header checkbox to check or uncheck every row on the current page
  • A row locked by a pending approval shows a padlock instead of a checkbox

Checking rows reveals Bulk edit (N) and Delete (N) in the toolbar, and changes Export to Export (N) — only the checked rows are written to the file.

The header checkbox covers the page you are on, not every row the filter matched. Raise Rows per page before checking all, or filter down first.

Select cells

Cell selection is rectangular, like a spreadsheet.

  • Click a cell to select it
  • Click and drag across cells to select a rectangle
  • Shift + Arrow extends the selection from the keyboard

The status bar shows N cells selected and the keys that apply: Ctrl+C copy, Del clear, Ctrl+Z undo, Enter edit.

Fill handle

When a cell is focused and you may edit it, a small square appears at its bottom-right corner. Drag that handle up or down to copy the value into every cell you drag over.

  • The fill runs down one column. It never spreads sideways
  • Filled cells become pending changes and turn yellow
  • A toast confirms Filled N cells
  • Ctrl+Z reverses the whole fill in one step

Bulk edit

Bulk edit sets one field to one value across every checked row.

  1. Check the rows you want to change.
  2. Click Bulk edit (N). The dialog header names the count, for example Bulk Edit — 12 branches.
  3. Pick the field from Field to change. Every column except Code and Name is offered; derived columns are not, because they are read-only.
  4. Enter the new value. The input follows the field: a list for a reference column, Active/Inactive for the status column, a text box for everything else.
  5. Click Apply.
The bulk edit dialog with a field selected and a new value entered
The bulk edit dialog with a field selected and a new value entered(click to enlarge)

The change lands as pending changes on every checked row, exactly as if you had typed each cell. Nothing is written until you click Save, so you can review the result first — and Undo in the header discards the whole bulk edit.

To set different values on different rows, paste a column instead. See Adding, Deleting & Pasting.

Resize a column

Drag the divider at the right edge of a column header. The width is kept while you stay in the grid.

Ready to get started?

Start managing your master data with Primentra today.

View Pricing
Selection & Bulk Operations | Data Grid | Docs | Primentra