How to Update multiple Custom Fields in Salesforce in few clicks? (2024)

Requirement

For any Salesforce Admin or developer, if there is a requirement to update multiple field attributes like length, label, Description or Help Text (or any other attribute) for Custom Fields for multiple objects (Standard or Custom).

– For a developer, it would be tedious job to open and update each field one by one using Salesforce Standard process. These type of work requests would take much more effort and time.

To overcome this situation and save user precious time, there is an app-exchange tool called Bulk Object Field Creator (BOFC).

Benefits of using BOFC Application for updating fields:

1. Supports both Standard and Custom fields to update
2. Supports both Standard and Custom Objects
3. User can update fields of multiple Objects in single click
4. User can update multiple fields of a multiple types in single click
5. User can update fields easily using XLS.
6. Easy, Simple, Clickable process to update fields.

Few Simple Steps to Bulk Field Updation in Salesforce

1. Open the BOFC Home > Click “Bulk Field Updation“

2. It will open below screen for BOFC Update Fields.

User can Update fields in two different methods.

• 1st method: Display all the fields in table, then modify & Update in Salesforce
• 2nd method: Download all the fields in XLS, then Modify in XLS, upload and Update in Salesforce

Once this blue button is clicked, it will displays all the custom fields in tabular format as shown below.

Above image has many features (each number has its description as below):

1. User can filter fields by object or field names
2. Pagination – This page has a pagination if count of fields is more than 80. Each page shows 80 fields. User can use “>” or “<” or “<<” or “>>” buttons to navigate on other pages
3. User can select fields by checking check-boxes in-front of each row
4. Each row columns are enabled or disabled depending upon field type. User can update the field attributes which are editable (scroll the tables and it will show more columns)
5. Total Field Count on page & Selected field count (for update)
6. Button “Update Fields” – On clicking this button, it will update all the selected fields for object.

Select the Fields which you want update by selecting checkbox infront of each row.

Once fields are selected, Click “Update Fields” button to Update fields for an object. Once the Update action is completed, it will show “Success or Error” status message in-front of each row (check below image for reference)

2nd Method = “Download as XLS > Modify > Upload > Update”

If user selects the 2nd method to download the sheet, it will display below UI for the user. This image is labeled with some number and below are there descriptions:

1. Select single or multiple objects
2. Select Method to Update as “Download as XLS”
3. Click on Download as xls and wait for couple of seconds for process to complete (as shown in below image)

1. User can click on [Download] link as per above screenshot to download all custom fields in XLS
2. Open excel and modify your field details and save file as xls or xlsx
3. Open your BOFC Update Field page and drag or select your excel file

Drag file on page and it displays all the fields in tabular format as displayed below:

Above image has many features (each number has its description as below):

1. User can filter fields by object or field names
2. Pagination – This page has a pagination if count of fields is more than 80. Each page shows 80 fields. User can use “>” or “<” or “<<” or “>>” buttons to navigate on other pages
3. User can select fields by checking check-boxes in-front of each row
4. Each row columns are enabled or disabled depending upon field type. User can update the field attributes which are editable (scroll the tables and it will show more columns)
5. Total Field Count on page & Selected field count (for update)
6. Button “Update Fields” – On clicking this button, it will update all the selected fields for object.

Select the Fields which you want update by selecting checkbox infront of each row.

Once fields are selected, Click “Update Fields” button to Update fields for an object. Once the Update action is completed, it will show “Success or Error” status message in-front of each row.

All the field attributes like (label, api name, description, help text, etc) can be updated for multiple fields for multiple Objects in few clicks.

Have a look at step by step detailed video to “How to Update Bulk Fields in Salesforce Using BOFC?“

******************************************************************************

Have you started using BOFC yet? Thousands of BOFC users have been able to save time & boost productivity using our Salesforce Metadata app. Click here to install the latest version of BOFC application in your Salesforce instance & explore its complete benefits for you.

For any queries or suggestions, you can write your comment in the comment box or for further assistance contact us at https://www.bofc.io/#contact or mail us: support@bofcapp.io. Our BOFC Expert will help you get the best out of it.

This tool is available on Appexchange and Click on below button to install the
latest version of BOFC

or learn more