Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Data Grid Capabilities

How to Edit Multiple Records at Once (Bulk Editing)

Learn effective techniques for bulk editing multiple records simultaneously to save time and streamline your workflow.

Written by Akanksha Shukla

Updated at June 8th, 2026

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Partner Quoting Workspace (PqW)
    Introducing StrataVAR PQW Importing Vendor Quotes – Creating Bills of Materials (BoMs) Assembling a Quote Editing a Quote Pricing, Margins and Calculations in PqW Preparing a Quote for Ordering Exporting Quotes in PqW StrataVAR Admin Related Articles Order Management and Upload Finding and Managing Quotes Cisco 360 Estimated Land Rebate
  • Partner Renewal Workspace (PrW)
    About Partner Renewal Workspace (PrW) PrW Maintenance Contract Module PrW Subscription Module
  • Data Grid Capabilities
+ More
  • Partner Quoting Workspace (PqW)

  • Partner Renewal Workspace (PrW)

  • Data Grid Capabilities

    •  How to Apply Server Filters to Filter the Data in the Grid
    •  How to Apply Column Filters in the Data Grid
    •  How to Search Records in the Grid
    •  How to Edit Records Inline in the Grid (Inline Editing)
    •  How to Edit Multiple Records at Once (Bulk Editing)
    •  How to Navigate and Find Records in the Grid
    •  How to Export Grid Data to Excel
    •  Understanding the Save Button and Save Counter in Grids

Introduction

When you need to set the same field value across many records, editing them one row at a time is slow. The grid's bulk editing feature lets you select multiple records and update them all in a single action — saving time and keeping values consistent across the set.

This article explains:

  • What you need before you can bulk edit
  • How to select records and apply a bulk change
  • Which field types support bulk editing
  • How validations and locks affect a bulk save
  • What to check before you commit a bulk edit

Bulk editing behaves consistently across the grids that support it; the specific fields available will vary by console or tab.


Prerequisites

Before you can bulk edit, the following must be in place:

  • Checkboxes are enabled on your grid, so you can select multiple records.
  • Inline editing is enabled for the fields you want to bulk edit.
  • You have edit permission on the records you want to update.

If you don't see checkboxes or a bulk edit option — or certain fields aren't editable — contact your Grid Administrator to confirm these are enabled and to check your field-level permissions.


Step-by-Step: Bulk Editing Records

Step 1 – Select the records

Use the checkboxes on the left of the grid to choose the records to update:

  • Click individual checkboxes to select specific records.
  • Use the header checkbox to select all visible records at once.

For example, in PrW “Assign Contracts to Account Console”, select the records using checkbox.

Step 2 – Edit the records.

Once records are selected, double-click on the required column of one of the records. Make sure the field is editable ( the column header has an edit icon)

Step 3 – Enter the new value

  1. Enter the value in the edit box or select from the picklist, depending upon the field type.
  2. You will see the checkbox confirming the number of records being updated. Click the Apply button. It will be set on every selected record.

Step 4 – Save

  1. You will see the updated records highlighted in yellow and a Save button and a Discard button in the Action toolbar.
  2. Click the Save button as seen in the action toolbar to apply the change to all selected records. A confirmation message appears once the update completes.

What You Can Bulk Edit

Field types that commonly support bulk editing include:

Field type What you can do
Text Update descriptions, notes, or any free-text field.
Picklist / dropdown Set the same status, category, or type across records.
Number Update quantities, prices, discounts, and similar values.
Date Set the same date across multiple records.
Checkbox Toggle a setting on or off for all selected records.

Not every field can be bulk edited. Fields that are read-only, formula-based, or restricted by your administrator won't be available.


Validations and Checks

The same validations that apply to inline editing apply to bulk editing:

  • Mandatory fields — if a bulk edit would leave a required field empty, the save is blocked.
  • Validation rules — every selected record must pass the configured rules with the new value. If even one record fails, you'll see an error and need to resolve it before saving.
  • Data type — the new value must match the field's expected type (for example, you can't enter text in a number field).
  • Locked records — records held by an approval process or workflow are skipped, and you'll be notified which ones couldn't be updated.

Things to Keep in Mind

  • Review before you save — a bulk edit changes many records at once, so double-check both your selection and the new value first.
  • There's no one-click undo — to reverse a bulk edit, you'll need to correct the records manually or run another bulk edit.
  • Only selected records change — unchecked records are left untouched.
  • Large selections take a moment — wait for the confirmation message before navigating away.

Summary

Bulk editing lets you apply a single change across many records in one action, so you can keep large sets of data consistent without editing row by row. Because the same validations and locks apply as in inline editing, your bulk changes stay within the rules already configured for your grid. For editing one record at a time, see How to Edit Records Inline in the Grid.

bulk edit

Was this article helpful?

Yes
No
Give feedback about this article
In this article
  • Introduction
  • Prerequisites
  • Step-by-Step: Bulk Editing Records
  • Step 1 – Select the records
  • Step 2 – Edit the records.
  • Step 3 – Enter the new value
  • Step 4 – Save
  • What You Can Bulk Edit
  • Validations and Checks
  • Things to Keep in Mind
  • Summary

Related Articles

  • How to Edit Records Inline in the Grid (Inline Editing)
  • How to do Bulk Operations in a Quote

Salesforce™, Force.com™ and other trademarks are trademarks of Salesforce.com, Inc. and are used here with permission.

Linkedin-in Youtube
Platform
  • Platform Overview
  • Partner Quoting Workspace (PqW)
  • Salesforce CPQ Enhencements (iCPQ)
  • Partner Renewal Workspace (PrW)
  • Integrations
Resources
  • Blogs
  • Case studies
  • White Papers
  • FAQ
Company
  • About us
  • Contact Us
  • Support Portal

2024© All rights reserved

  • Privacy Policy
  • Terms & Conditions

Made with 🤍  by StrataVAR

Knowledge Base Software powered by Helpjuice

Expand