Out of the box, you cannot do this in Salesforce, you need to use Data Loader or other data management tools. But wait a second, what is the different between mass edit with mass update? In this context:
Mass Edit - to update multiple selected records in View for multiple fields, you can enter value for each record and field manually.
Mass Update - to update multiple selected records in View for a selected field with the same value. Use case: to update multiple opportunities to new Stage at once.
With Mass Actions app available free in AppExchange, you can do this without need to hire a developer. Both screenshots above taken from Mass Actions app. Imagine productivity gain when you have this tool available for your organization.
Mass Actions provide 3 functions (edit, update, and delete) for 4 main Salesforce objects: Account, Lead, Contact, Opportunity. Once installed, you need to configure to make the buttons available for your user in List View or in Related List page layout. Follow this guide Post Install Setup Instructions and User Guide to add buttons to List View. It depend on your business needs if you need to add all 3 buttons, or you can just add 1 button, e.g. Mass Edit only. Once button added to List View layout, you should see the buttons when open a View for that object.
The same buttons can be added to related list of a page layout, example: Contact related list in Account page.
Can I modify fields in Mass Edit?
- Update the line of code that says selectedFields (here is an example from Account: selectedObject=account&selectedFields=Name,OwnerId,ParentId,Phone,Website,Type,Industry,BillingStreet). Remove or replace any fields that you don't want to see with fields you do want to see.
- Add your new "Mass Edits" custom button to your list views (ignore the installed one)
Now you see the exact fields you want your users to mass edit.
Can I implement this in other object or custom object?
Step 2. Create new buttons for a custom object . (e.g my object is Country)
Note: You need to make one modification to the script: find “Account” and replace all Account with the API name of your custom object, e.g. I replaced “Account” with my Object Name “Country__c")
Step 3: Assign the button to layout
Type: AppExchange (Managed Package)
Similar app: Mass Update And Mass Edit From List View by Salesforce Labs
Blog last updated: 26 Mar 2016