Adding, Deleting & Pasting

Rows are added one at a time with New, in a block with Paste rows, or by pasting past the last row of the grid. All three produce pending changes that only reach the database when you save.

Add a row

Click New in the toolbar. An empty row appears at the bottom with:

An empty Code, or a muted Auto when the entity generates its own codes. The real value is assigned by the database on save
Active set to true
Every other field empty
A purple left border, marking it as new and unsaved

Pressing Tab past the last cell of the last row also creates a new row, so you can key in records without touching the mouse.

A new row that stays completely empty is removed when you navigate away. A partly filled row is kept and shows red validation borders until you finish it.

Delete rows

Check the rows you want to remove.
Click Delete (N).
The dialog lists every record by code and name.
Click Delete permanently.

The dialog says This action cannot be undone, and it means it: a delete against the database is immediate and is not covered by Undo or Ctrl+Z. Check the list before you confirm.

On an entity that requires approval the button reads Mark for deletion instead. The rows are locked and queued for an approver, and an Undo N deletions button appears in the header until you submit. See Approval Workflows.

In the interactive demo the confirmation toast carries an Undo button with a ten-second countdown, because the demo holds its data in the browser.

Copy

Select cells and press Ctrl+C (Cmd+C on Mac).

A single cell copies its displayed text
A column of cells copies one value per line
A rectangle of cells copies as tab-separated text, ready for Excel
Reference cells copy as {CODE} Name
Date cells copy in the column's own format, with no time, so they paste straight back

Paste

Focus a cell and press Ctrl+V (Cmd+V on Mac). What happens depends on what is on the clipboard.

Clipboard holds	Result
One value	Written into every selected cell
One column of lines	Written downward from the focused cell, one line per row
Tab-separated rows	Written as a block, starting at the focused cell and spreading right and down

Lines that run past the last row of the grid become new rows rather than being dropped. The toast says so: 40 cell(s) pasted, 4 new row(s).

Three columns never accept a paste: derived columns, the system date columns, and Code on an auto-code entity.

What the values must look like

Reference columns accept the row id, the code, the name, or {CODE} Name. A value that matches nothing is skipped and reported with up to three suggestions
Yes/No columns accept 1, true, yes or ja for true, and 0, false, no, nee or an empty cell for false. Custom labels are not accepted — export a column to see what it holds, then paste one of the accepted words
Number columns reject anything that is not a plain number, and reject a negative value unless the attribute allows negatives
Date columns are parsed with the column's own format

Clear cells

Select cells and press Delete or Backspace. The values are cleared, including reference columns, which are set back to empty. The status column and any column you may not edit are skipped. Ctrl+Z brings the values back.

Paste rows

Paste rows takes a whole block out of Excel and turns it into new records.

Click Paste rows in the toolbar.
Press Ctrl+V in the text area. The dialog parses the text as you paste.
Read the preview.
Click Confirm.

The Paste rows dialog showing parsed rows with resolved reference values(click to enlarge)

How the columns are matched:

If the first line matches your column names, it is treated as a header row and each column is mapped by name
Without a header row, columns are mapped positionally, left to right
Reference columns are resolved from their display text to the underlying record
The preview lists the first 50 rows and states the total detected

On an entity that generates its own codes, Code is left out of the mapping entirely. Your first data column lands in Name, and a Code column in the pasted data is ignored with the note Code is generated automatically — the Code column was ignored.

Confirming adds every row to the bottom of the grid as a pending change. Nothing is stored until you click Save.

Paste rows only creates records. To update records that already exist, use Import from Excel & CSV with the Overwrite conflict action.