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 Popup - available via the Context Menu
- Bulk Update Status Bar (displays a Button that opens the Bulk Update Popup)
UI Step by Step Guide
Applying a Bulk Update
- This example shows how to apply a Bulk Update.
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 appyling a Bulk Update.
An info button is shown in the Bulk Update user control indicating the results of the validation check:
| Proposed Edits | Info 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 addtion 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, the table is available by clicking the Error Icon
- 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 he 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.
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.