Data Entry in AdapTable
Summary
- AdapTable provides 4 Modules to ensure fast and safe data entry in AG Grid:
- Smart Edit - applies a single mathematical edit to numerous cells
- Bulk Update - updates numerous cells with a new value in a single operation
- Shortcut - avoid fat finger issues and speed up data entry for numeric columns
- Plus Minus - define nudge rules for numeric cells when + or - keys are pressed
Data Entry Modules
AdapTable offers 4 separate Modules / functions to facilitate quick and efficient data entry:
| Edit Module | Details |
|---|---|
| Smart Edit | Updates multiple numeric cells with a single operation |
| Bulk Update | Updates multiple cells to display the same value |
| Shortcuts | Enables quick, safe, numeric data entry via keyboard shortcuts (e.g. M for million) |
| Plus Minus | Increments / decrements numeric cells when pressing the + / - keys |
Other Editing Features
AdapTable provides many other features to help users edit data quickly and accurately in AG Grid:
Row Forms
Edit Row Forms provide a secure and easy way for users to edit data in AdapTable.
AdapTable will display a dynamic form where only the editable fields can be updated.
Note
They can also be used manage creation, cloning, editing or deletion of (partial) rows
Cell Editors
AdapTable provides 4 Cell Editors which help to ensure quick and error-free editing:
| Cell Editor | When Used |
|---|---|
| Select Editor | Selecting an item from a list of values |
| Numeric Cell Editor | Editing numeric columns |
| Date Picker | Editing date columns |
| Percentage Cell Editor | Editing numeric values that display as percentages |
Validating Edits
AdapTable provides advanced Data Validation capabilities.
These can be applied either on the client or your server depending on your requirements.
Data Validation can be applied on both user edits and 'ticking' data changes.
Editable Cells
AdapTable allows developers to define Editable and ReadOnly Cells and Columns in AdapTable.
Note
Use editableCellStyle and readOnlyCellStyle properties in User Interface Options to style these cells distinctively
Data Change History
The Data Change History Module provides full visual coverage of all data edits in AG Grid.
These are provided in the Data Changes Monitor which displays details of all cell value changes in the current AdapTable session.
Hint
An Undo Button can be added to each row in the Monitor to allow Users easily to undo data edits they have made
Editing Tips & Tricks
FAQ
Do you only support inline editing? No, AdapTable also provides Row Forms which allow you to edit an entire row via a dynamic popup form