Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

This topic describes how the Mass Edit feature works with records.

Mass Edit Operations

Widget Connector

A Mass Edit operation can modify several records and fields simultaneously. For instance, The Status field in a particular set of records can be assigned the value 'Closed'.


To select a number of records for mass editing, select the checkboxes in the table view and click Mass Edit in the action bar. The Mass Edit wizard opens when Mass Edit is clicked in a table view. For more information on using table views, see Table View.This opens the Mass Edit Wizard. 

Mass Edit Wizard


Note that Mass Edit changes, like changes from the record Edit form,


are reflected in the record


history.If you do not see a

Mass Edit



Mass Edit permissions are set on the toolbar for the selected table, you probably do not belong to a group with permission to edit multiple records at once.

Mass Edit permissions are set on the Permission tab of the Groups wizard.

Widget Connector
Permission tab of the Groups wizard, and access is controlled by group membership. Groups that are not authorized to mass edit records in a table will not see the Mass Edit icon on the Action Bar for that table.

To grant a group the permission to mass edit records in a single operation...

  1. Navigate to Setup > Access > Manage Groups and edit the relevant group.
  2. In the Groups wizard, click the Table tab and edit the relevant table.
  3. In the Table Permissions wizard, click the Record Permissions tab and tick the Mass Edit multiple records in <Table Name> in a single operation checkbox.

Mass Edit Permissions CheckboxImage Added

Mass Edit Wizard

The Mass Edit wizard contains the following tabs:

Select Fields Tab

The Select Fields tab allows you to select which fields to change. Fields which are greyed out may not be modified. You can use the following methods to choose the fields to edit:

  • Select a number of fields and click Next
  • Click Select All and then click Next.
  • Choose a linked field from which to edit linked records from the drop-down.

Select Fields Tab Mass EditImage Added

Update Tab

The Update tab contains a set of inputs for each selected field, with appropriate input aids based on the field type. For example, a Calendar is displayed as the input aid for the 'Start Date' date field.

Update Tab Mass Edit WizardImage Added

You can update fields based on formulas and variables, enabling 'search and replace' string substitution and other update formulas to set the field's value. For example, if you had fields Cost, Price and Quantity, you could set the Cost to Price * Quantity.

Update Tab Search ReplaceImage Added

Note: You can use search and replace for most data types, including email fields.

For multi-choice fields you can choose whether the new value should overwrite or append to the old value.

Confirm Tab

The Confirm tab allows you to choose whether to run rules and update default field values when the change is saved.

Confirm Tab Mass EditImage Added

Hide If

Content by Label
cqllabel in ("mass","edit") and type = "page" and space = currentSpace()
labelsmass edit