Update multiple records (bulk update)
Bulk update allows you to change values across multiple records of the same type. You can perform the bulk update on all or selected records in section tabs (archives), selections and the Find screen. This task can also be used to delete multiple records.
Open the selection, section tab (archive) or search results (Find screen) containing the records you want to update.
Selections: Click the Task button and select Bulk update. or Select the records you want to update, right-click them and select Bulk update.... The Bulk update dialog opens. In the bottom of this dialog you can see the type of record and how many records to be updated. Example: Number of contacts in queue for bulk update: 7.
Note
If the selection contains both companies and contacts, there will be two tabs: Company and Contact.
Select a field to update in the Field column. You can also type the name in the field. As you type each letter, the list below displays all matches relevant to the selected records.
Select an action in the Action column. The available actions depends on the type of field you selected in the previous step. Examples:
- Check: Check or uncheck a checkbox.
- Toggle: Uncheck a checked checkbox and vice versa.
- Search and replace: Find a text and replace it.
- Regex: Update a field using regular expressions.
- Set: Apply a new value to the field.
- Clear: Clear any value from the field.
- List actions: Select or clear single or multiple values for list fields.
- Activity link actions: Add, remove or replace activity links or clear all activity links.
To add more fields to be updated, click Add and repeat steps 3 and 4.
Make sure you select (
) the fields you want to update and unselect (
) the fields you DO NOT want to update.Click Update. The Confirm dialog opens, showing a summary of the updates.
Note
After an update is applied, it cannot be undone.
Click Yes to implement the changes to the selected records.
Note
It is possible to stop the update as soon as you have started the update. Any entities that have not been updated yet, will not be updated.
Click LOG to show the change log. If any records were not updated, the reason is listed in the Reasons why column.
Click Close.
Search and replace
The action type Search and replace allows you to find a specific text in a field and replace it.
- Select Search and replace in the Action column.
- Enter the text to be replaced in the Find field.
- Enter the replacement text in the Replace with field.
- Optional: Click Options and select settings for case-sensitivity and whole/partial word search.
Regular expressions
The action type Regex allows you to use regular expressions to update a field.
- Select Regex in the Action column.
- Enter the expression in the Expression field.
- Enter the replacement text in the Replace with field.
- Optional: Click Options and select settings for the regular expression.
Examples
Update company categories
You want to categorize your customers according to sales amounts. Create company categories called "Customer A", "Customer B" and "Customer C" in SuperOffice CRM. For "Customer A" you can create a selection of companies with sales amounts over EUR 50 000 last year. Use Bulk update to update the category for these customers to "Customer A". Repeat this process for the other companies.
Update company post code and post city
Post codes and post cities in Norway have changed. Use Bulk update to update the addresses.
Update contact
You discover that the contact field Position is rarely used. To at least start the task of filling in this field for all contacts, you want to find everyone that have director in the title. Create a selection of all contacts that contain the word "director" in the Title field. Use Bulk update to set the field Position to Management.
Update project
You want to clean up all the "old" projects that have not been set to completed. Create a selection of all your old projects, for example all projects created more than 2 years ago and that has not been updated in the last year. Use Bulk update to set the Completed status for these projects to Yes.