Documentation
Getting Started
Installation
Data Grid
Approvals
Administration
Account & Security
Integration & Staging
Architecture
Documentation/Data Grid/Adding, Deleting & Pasting

Adding, Deleting & Pasting

Adding & Deleting Rows

Adding rows: Click the New button in the toolbar to add an empty row at the bottom of the grid. The new row gets:

  • An auto-generated Code value (if auto-generate is enabled for the entity)
  • Active set to true by default
  • All other fields empty
  • A purple left border to indicate it's a new, unsaved row

Incomplete rows (where all required fields are empty) are automatically removed when you navigate away. Partially filled rows — where some required fields have values but others don't — are kept and show red validation borders.

Deleting rows: Select rows using checkboxes, then click Delete (N):

  • A confirmation dialog shows a list of records that will be deleted
  • Click Delete permanently to confirm
  • Deletions cannot be undone via the undo stack

Copy & Paste

Copy (Ctrl+C / Cmd+C):

  • Select one or more cells and press Ctrl+C
  • A toast confirms the number of copied cells
  • Domain fields are copied in {CODE} Name format

Paste (Ctrl+V / Cmd+V):

  • Focus a target cell and press Ctrl+V
  • Single value pastes into all selected cells
  • Multiple lines paste downward starting from the focused cell (one line per row)
  • Domain field paste is validated — invalid values show an error toast with suggestions
  • Boolean field paste: always use 1 (true) or 0 (false), regardless of the display format configured (Yes/No, True/False, or custom labels)

Clear cells (Delete / Backspace):

  • Select cells and press Delete or Backspace to clear their values
  • Works on optional text fields
  • Cannot clear required fields or domain references

Paste Rows

Paste tab-separated data from Excel via the Paste rows button in the toolbar.

  1. Click Paste rows to open the paste modal
  2. Paste your data (Ctrl+V) into the text area
  3. The system auto-detects headers: if the first row matches field labels or column names, it's used as a header row
  4. Without headers, columns are mapped positionally to entity fields
  5. Domain fields (e.g., Zone, Area) are automatically resolved from display text to internal IDs
  6. Boolean fields: paste 1 for true or 0 for false — display labels (e.g. Yes/No or custom labels) are not accepted
  7. Preview shows up to 50 parsed rows with resolved values
  8. Click Confirm to add all rows at once

Each pasted row gets a new unique ID and is added as a pending change.

Ready to get started?

Start managing your master data with Primentra today.

View Pricing