Requirement
Salesforce Admins and Developers often need to export Controlling and Dependent Picklist fields across one or more objects — including their value dependencies and relationships — for documentation, audit, or migration purposes.
Challenge
Manually identifying and exporting Controlling and Dependent Picklist mappings is a time-consuming and error-prone process. If an admin must review dependencies for hundreds of picklists, they would have to:
-
Open each field setup individually
-
Identify controlling and dependent relationships
-
Copy the values manually into spreadsheets
This can take several hours or even days, especially in large or complex orgs.
Solution — Using BOFC (Bulk Object Field Creator)
With the BOFC App (available on Salesforce AppExchange), users can export Controlling and Dependent Picklist fields with their dependencies in just a few clicks. The app automatically extracts all dependencies, saving significant effort and ensuring complete accuracy.
Key Benefits of BOFC
-
Bulk Export Capability – Export Controlling and Dependent Picklist mappings for multiple fields across any Standard, Custom, or Managed Object.
-
Comprehensive Mapping Details – View the relationship between Controlling field values and their corresponding Dependent values in a clean, structured format.
-
Supports Global Picklists (Value Sets) – Export dependencies for picklists linked to Global Value Sets in a single operation.
-
Export All Value States – Option to include both active and inactive picklist values.
-
Simple, No-Code UI – 100% point-and-click experience — no need for scripting or API queries.
Example — Controlling vs Dependent Picklist Mapping
BOFC automatically extracts and displays such mappings in Excel format, ready for review or migration.
Summary
Using BOFC, Salesforce users can export controlling and dependent picklist relationships instantly, without any manual configuration. This eliminates repetitive work, reduces errors, and ensures clean documentation for both admins and developers.
Few Simple Steps to Export Picklist dependencies:
1. Open the BOFC Home > Click "Export Picklist Values for multiple fields"
2. It will open the below screen
3. Select "Export Picklist" and Select single or multiple objects for which controlling and dependent picklist fields needs to be exported
Click on "Fetch All Picklist Field(s)" button.
5. Select single or multiple dependent picklist, whose dependencies on controlling fields needs to be exported
Finally we are ready with all the configuration and ready to initiate the process to Export.
Click on "Download Dependency Details" button.
6. Once this button of "Download Dependency Details" is clicked, it will open a small section for Export Status.
Just wait for few seconds for the processing to complete. Once the processing is completed, it will update the status to "Completed" and it will enable the "Download" link as highlighted in below image.
Click on the "Download" link and it will export the XLS file with all the Controlling and Dependent Picklist Fields for the selected fields and will display in below format.
************************************************************
For more details, refer official webpage of this application
Below is the AppExchange URL for this application