How to Export Field Usage Report in salesforce for multiple objects?

Export Field Usability in Salesforce

Requirement:
For any Salesforce Admin or developer, if there is a requirement to find how much the field is used (usage report) in the Salesforce and export the field Usability for fields and objects (single or multiple) in the form of XLS.

– For a developer, it will be a tedious and time taking job. User would have to get and export field usability for single or multiple fields one by one using Salesforce Standard process. These type of work requests would take much more effort and time, but with our Salesforce AppExchange application “Bulk Object Field Creator (BOFC)“, user can easily “Export field usability (Single or Multiple) Objects” with in few clicks.

Benefits of BOFC Application to Export Field usage report:

  1. User can export field usability for all types of fields for single or multiple objects.
  2. Support any kind of objects (Standard or Custom)
  3. Supports the feature to find field usability for each picklist values as well
  4. Easy to use with few clicks
  5. Saves ample amount of time of doing manual work

Note:

To avail this feature, kindly make sure you have installed the latest version of the application. You can upgrade your package using either of two ways:

  1. In Salesforce, go to “BOFC Home > Settings > App Version > Click to Upgrade” — or —
  2. Refer the below button to quickly upgrade your package to the latest version and explore its complete benefits:

Stay up to date with the latest in BOFC - Latest features, offers, news, tips and more

Few Simple Steps to “Export Field Usability”

Step 1. Open the BOFC Home > Export Field Usability”

Clone Permission Sets

Step 2. It will open below screen for “Export Field Usability” page.

Step 3. Now click “Create New Field Analyzer” Button and screen look like below image

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

  1. Give your field analyzer name
  2. Select object from the dropdown
  3. User can add SOQL query
  4. Click on Save button

Step 4. Once the “Save” button is clicked, it will create a new row in the main table with some links in the action column as shown below

Above image has many links to click (each link has its own functionality as described below)

– Start All Field Analysis – It will start analyzing all the fields of the selected object with respect to SOQL defined. Once this link is clicked, it will show the below popup and will start the process.

Once the process is completed, BOFC will send an email when analysis is completed (No need to keep this popup OPEN).

NOTE:

  1. You can monitor the progress of the analysis or wait for an email notification.
  2. Once process get completed, it will display “View Results” and “Download Results” link in the main table.
  3. If you are waiting for the job to complete, then please do not refresh your page and wait until Status is changed to “Completed” in below table.
  4. The table in the popup updates automatically after every few seconds.
  5. This process takes around 2-3 mins for up to 1 million records

– Start All Picklist Value Analysis – It will start analyzing all the picklist values of all the picklist fields. Once this link is clicked, it will start the process.
– View – If user want to view the field analyzer result, please click on view link to view field analyzer process result.
– Del – If user want to delete the field analysis, click on del link to delete field analyzer process.
– Download Results – Click on “Download Results” link from the above image to download the results and open the downloaded field analyzer report.

Here is the final result of field usability report (XLS):

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

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.

Experience it for yourself

Bulk Object Field Creator (BOFC) is a must-have tool, designed specifically for Salesforce.com Administrators, that simplifies many of the tedious tasks of managing a complex Salesforce environment.

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

or learn more
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Announcement: Introducing our new product "KAiZEN - a digital signature solution to secure your digital e-signing experience". Discover Now

X