Data Editor Keyboard Shortcuts
Reference for managing records, filtering, marking, and related table operations in the Data Editor.
Records & Editing
| Action | Mac | Windows/Linux | Description |
|---|
| New Record | ⌘ Cmd + + | Ctrl + + | Insert empty row and focus first editable cell. |
| New Related Record | ⌘ Cmd + ⇧ Shift + + | Ctrl + Shift + + | Add record to currently shown related table (if visible). |
| Apply New Record | ⌘ Cmd + ↵ Enter or ↵ Enter (on last column) | Ctrl + Enter or Enter (on last column) | Commit added row when in add mode. |
| Discard New Record | Esc | Esc | Cancel adding/editing current new row. |
| Next Editable Cell | ↵ Enter / Tab | Enter / Tab | Move to next editable cell (saves previous cell). |
| Go To Parent Record PRO | ⌥ + Click | Alt + Click | Open parent table filtered by FK/ObjectPtr value. |
Filtering
| Action | Mac | Windows/Linux | Description |
|---|
| Add Filter Row | ⌘ Cmd + F | Ctrl + F | Add first filter row; repeat to append OR row (max 4). |
| Add OR Filter Row | ⌘ Cmd + F (again) | Ctrl + F (again) | Append another green filter row combined using OR. |
| Filter by Cell Value | ⌘ Cmd + ⇧ Shift + F | Ctrl + Shift + F | Add filter row with current cell value and execute immediately. |
| Execute Filter | ⌘ Cmd + E | Ctrl + E | Run SQL built from filter rows. |
| Show All Records | ⌘ Cmd + G | Ctrl + G | Show full dataset again, keeping filter rows editable. |
| Discard Filter | Click filter discard icon | Click filter discard icon | Remove filtering (green rows remain for editing). |
Marked Records
| Action | Mac | Windows/Linux | Description |
|---|
| Mark / Unmark Record | Space | Space | Toggle mark of focused row (order preserved). |
| Mark All / Unmark All | Click mark column header | Click mark column header | Header click marks all if any unmarked, else unmarks all. |
| Show Marked / Hide Marked | Record menu | Record menu | Show only marked or hide them (state retained). |
Related Table Operations
| Action | Mac | Windows/Linux | Description |
|---|
| New Related Record | ⌘ Cmd + ⇧ Shift + + | Ctrl + Shift + + | Create child record in related table view. |
| Set Operations | Menu only | Menu only | AND / OR / XOR / Minus on marked parent record sets. |
| Show Mode Switch | Menu / toolbar | Menu / toolbar | Show All / Show Linked / Show Free child records. |
Transactions
| Action | Mac | Windows/Linux | Description |
|---|
| Toggle Transaction Mode | Tx button | Tx button | Start/stop transaction mode. |
| Commit / Rollback | Commit / Rollback buttons | Commit / Rollback buttons | Persist or discard uncommitted changes. |
Formatting & Layout
| Action | Mac | Windows/Linux | Description |
|---|
| Auto Size Columns | Autosize menu | Autosize menu | Size columns by visible/all rows or types; optional wrap. |
| Apply / Manage Layout | Layout choice / dialog | Layout choice / dialog | Switch, create, manage saved column layouts. |
| Format Value PRO | Field header / context | Field header / context | Set numeric, date/time, geometric, interval, or custom formats. |
| Set Input Mask PRO | Context menu | Context menu | Restrict allowed characters and structure for text input. |
Notes & Tips
- OR Filter Rows: Repeat Add Filter Row shortcut up to four rows; combined using SQL OR.
- WHERE Row: Added from filter menu for custom WHERE clause (exclusive with normal filter rows).
- Filter Editing: Hover filter icon for generated WHERE preview; use "Filter to SQL" to open full query in SQL Editor.
- Marked Order: Order of marking matters for related set operations (e.g. Minus depends on sequence).
- Apply New Record: Ctrl/Cmd+Enter works anytime during add; plain Enter applies only on last editable column.
Pending Keys: Some operations (Duplicate Record, Delete Record(s), Show/Hide Marked) are menu-only. Assigning shortcuts could improve efficiency; consider adding in future iterations.
Valentina Studio – Data Editor Shortcuts Reference