Bulk Update
Summary
- Bulk Update replaces, via a single action, the cell value in multiple cells
- All the cells will receive the same new value
- The new value can either be one that already exists in the column or an entirely new one
Bulk Update replaces, via a single action, the cell value in multiple cells in one (editable) Column.
All the cells that are updated will display the same new value.
Note
Bulk Update differs from Smart Edit in that it replaces, rather than updates, the existing cell value
The replacement value can either be one that already exists in the column or an entirely new one.
Using Bulk Update
Bulk Update can be applied on text, numeric and date columns.
Bulk Updates can be applied in numerous places in the AdapTable UI:
- Bulk Update Toolbar - available in Dashboard
- Bulk Update Module Tool Panel - available in AdapTable Tool Panel
- Bulk Update page in the Settings Panel — available via the Context Menu
- Bulk Update Status Bar (displays a Button that opens the Bulk Update page in the Settings Panel)
UI Step by Step Guide
Applying a Bulk Update
- Select editable cells in a single column (text, numeric, or date), choose a value in the Bulk Update toolbar, then apply
- Select a value in the Bulk Update toolbar and press the Green tick to update the selected cells
Validating Bulk Update
AdapTable will check all Data Validation Rules before applying a Bulk Update.
The Apply Bulk Update button colour indicates the results of the validation check:
| Proposed Edits | Button Colour / Type | Apply Bulk Update Button Behaviour |
|---|---|---|
| All are Valid | Success (default is green) | Button is fully enabled |
| Some are Invalid | Warning (default is amber) | Button is enabled but only valid edits are applied |
| All are Invalid | Error (default is red) | Button is disabled and the operation is not accessible |
In addition AdapTable will display a Preview Results table which will indicate — and provide details — of which proposed edits break a Validation Rule.
Hint
In the Bulk Update Dashboard Toolbar and Module Tool Panel, click the Preview Results button to open the Bulk Update page in the Settings Panel, where the table is displayed
- This example shows what happens when trying to apply a Bulk Update which breaks Validation
- We have created a Data Validation Alert that the
Languagecolumn value cannot be "Python" - Trying to enter "Python" in Bulk Update for Language column will not be allowed and the table will display all the failed validations
- Enter "Python" in the dropdown in the Bulk Update Toolbar as a new value and see the validation results immediately error
Custom Column Values
By default the Bulk Update component will automatically display a list of the distinct values in that column.
However it is possible to provide a bespoke list of items to display instead, via the customEditColumnValues property in Edit Options.
Find Out More
See Providing Custom Column Values when Editing for more information and a demo
FAQ
Can I perform a Bulk Update on any column? Yes, well most. Bulk Update can be performed on text (string), numeric and date columns.
Can I perform Bulk Update on a readonly column? No, Bulk Update only applies on editable columns.
How do Module Entitlements affect Bulk Update?
When the Bulk Update module is Hidden, UI is unavailable (same as other action-only modules). There is no separate read-only mode for Bulk Update objects.
Can I perform a Bulk Update across more than one column? No, like Smart Edit, Bulk Update works on only one column at a time.
Can I choose to enter a value that is not currently in the column? Yes, you can enter either an existing column value or an entirely new one.
I do not want all the current values in the Column to be available in the Bulk Update dropdown? You can provide custom values to be displayed in the Bulk Update control.