---
title: "Mass Editing Records"
canonical: "https://help.agiloft.com/space/HELP/43715067/Mass+Editing+Records"
format: markdown
---
Mass editing allows you to modify several records and fields simultaneously. For instance, you can use mass edit to close several service requests at once. You can perform more complex updates on records as well, such as changing their status to Closed, updating the Closed On field to a specified date, and appending "Resolved by upgrade" to the Resolution text field. Changes made by mass edit are recorded in each record's history, just like they would be if you opened and updated each record individually.

To choose records for mass editing, select the checkboxes next to the desired records in the table view and then click Edit Fields in the action bar.

![Select multiple records and click Edit Fields](media://9a36c9c8-6356-49c6-ae82-f7d4d7094a84)

# Using Mass Edit

The Mass Edit wizard appears when you click Edit Fields on a table's action bar. It contains several tabs for configuring the mass edit operation.

## Select Fields Tab

<span style="color: #000000">On the Select Fields tab, select which fields to change. Fields that are greyed out cannot be modified. You can use the following methods to choose the fields to edit:</span>

- <span style="color: #000000">Choose any number of fields by selecting the corresponding checkbox.</span>
- <span style="color: #000000">Click Select All to choose all fields.</span>
- <span style="color: #000000">Select a linked field from the drop-down menu to edit fields in a linked record.</span>

![Select Fields tab](media://df3b88e4-db4c-4e48-8a95-5680b8fa727d)

## Update Tab

The Update tab contains a set of inputs for each selected field and appropriate input aids based on the field type. For example, Choice fields use radio buttons or drop-down lists, and Date fields include a calendar icon for choosing the date.

![Update tab showing example field changes](media://04c1e77b-fcd8-4d77-ab68-180b9608e0a8)

<span style="color: #000000">You can also update fields based on formulas and variables, enable search and replace string substitution for most data types, and use other </span>[<span style="color: #000000">update formulas to set the field's value</span>](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43715029)<span style="color: #000000">. For example, if you're mass editing the Amount field in a table, you could set its value to the product of the Unit Price and Quantity fields.</span>

![Formula field](media://c3ad6f96-e7a5-4c13-b7a5-de3afa76215a)

> ⚠️ Certain data types have additional mass editing options. For example, Multi-Choice fields allow you to decide whether the new value overwrites existing values, is appended to existing values, or is removed from existing values.

## Confirm Tab

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

![Confirm tab](media://0bf0adf0-400b-40ce-93fa-5030d5a46692)

# Mass Edit Permissions

P<span style="color: #003366">e</span><span style="color: #000000">rmissions for mass editing are set on the Permission tab of the Gr</span><span style="color: #000000">oups wizard, and access is controlled by group membership. </span>G<span style="color: #000000">roups that are not authorized to mass edit records in a table do not see the Edit Fields icon on the action bar for that table.</span>

<span style="color: #000000">To grant a group the permission to mass edit records:</span>

1. <span style="color: #000000">Click the Setup gear in the top-right corner and go to</span>**<span style="color: #000000"> Access > Manage Groups</span>**<span style="color: #000000"> and edit the relevant group.</span>
2. <span style="color: #000000">In the Groups wizard, click the Table tab and edit the relevant table.</span>
3. <span style="color: #000000">In the Table Permissions wizard, click the Record Permissions tab and select the "Mass Edit multiple records in [Table] in a single operation" checkbox.</span>  
> Macro (inline-media-image)

<span style="color: #000000"> </span>
4. <span style="color: #000000">Click Finish.</span>

#### Related articles

> Macro (contentbylabel)