Bulk Update

View as Markdown

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:

UI Step by Step Guide

Applying a Bulk Update

Bulk Update
Fork
  • Select editable cells in a single column (text, numeric, or date), choose a value in the Bulk Update toolbar, then apply
Try It Out
  • Select a value in the Bulk Update toolbar and press the Green tick to update the selected cells
Loading demo…

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 EditsButton Colour / TypeApply Bulk Update Button Behaviour
All are ValidSuccess (default is green)Button is fully enabled
Some are InvalidWarning (default is amber)Button is enabled but only valid edits are applied
All are InvalidError (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

Bulk Update Validation
Fork
  • This example shows what happens when trying to apply a Bulk Update which breaks Validation
  • We have created a Data Validation Alert that the Language column 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
Try It Out
  • Enter "Python" in the dropdown in the Bulk Update Toolbar as a new value and see the validation results immediately error
Loading demo…

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.