Defining a Mass Update

You can define a mass update if you have the Mass Updates permission.

To define a mass update:

  1. Go to Lists > Mass Update > Mass Updates.

  2. On the Mass Updates list, expand a category and click a link.

    Mass Updates list with the Customer Support and Service category expanded.
  3. In the Title of Action field, enter a name for this update.

    If you are saving this mass update, create a name that describes the update so you can find it in the future.

  4. To enter the new information:

    • If you are performing a General mass update on a record type:

      Click the Mass Update Fields subtab and review the fields that are available for update.

      Check the box in the Apply column next to each field you need to update, and enter or select the new data in the Value column. Or, you can enter a formula to dynamically calculate values to be entered. See Entering Formulas for a Mass Update.

      Fields exposed for mass updates are the same as those available for inline editing and include the following: standard fields that are outside of subtab lists and do not have dependencies on other fields, and custom fields that are stored and do not have sourcing relationships.

      Mass Update Fields subtab on the Mass Update page.

      For transactions updates, fields that are not displayed on your preferred form for a transaction are not made available for mass updates. For example, if your preferred invoice form does not include the To Be Printed field, this field is not listed on the Mass Update Fields subtab for a mass update to invoices.

    • If you are performing a specific type of update, such as Contact Management:

      To the right of the Title of Action field, select or enter the new data.
      On the Criteria subtab, select filters that you want to use to set criteria. When you select a filter, a window pops up where you can select criteria.
    Criteria subtab on the Mass Update page.
  5. Define a filter or filters on the Criteria subtab.

  6. Define display options for mass update results on the Results subtab.

    • Select the order in which you want the results to sort.

    • Choose to view the list as a report.

    • Pick which columns you want to appear in the list.

    • For information, see Search Results Display Options.

  7. Define the users who can run the update on the Audience subtab, if available.

  8. If you are an administrator and you want to run the mass update on a recurring basis, set up this recurrence on the Schedule subtab. See Scheduling a Mass Update.

  9. Click Preview to see which records the mass update will change, and review the Mass Update Preview page.

    • To modify the mass update, click Return to Criteria, and repeat steps 4-8 as necessary.

    • If your list has less than 1000 entries, an Apply column is shown. (If you want to show the Apply column, select search criteria that return results with less than 1000 entries.) If any record listed should not be updated, clear the box in the Apply column.

  10. Choose one of the following options:

    • Click Perform Update to make the mass update.

      • After you click Perform Update, you cannot stop or cancel the mass update, so proceed with caution!

    • Click Save to save this mass update for future use.

      • When you save the update, it is not run. To make the mass update changes, go to Lists > Mass Update > Saved Mass Updates, and click Preview next to the name of the update. On the Mass Update Preview page, click Perform Update to make the changes.

      • When you save a mass update, you can always return to the list to make changes to the same records by going to Lists > Mass Update > Saved Mass Updates.


You can update more than one field on records, by using the links under the General Updates heading on the Mass Updates list. Use the links under the Sales Force Automation, Contact Management, Activities, Files, Group Records, Customer Support and Service and Marketing headings to quickly create more specific updates that only affect one field.

Related Topics

Mass Changes or Updates
Entering Formulas for a Mass Update
Scheduling a Mass Update
Translations for Mass Updates
Example Mass Update
Available Mass Updates
Mass Updates of Global Subscription Status
Performing Mass Deletes

General Notices