Saves the dependent picklist matrix as a CSV file.
NOTE: Some users have reported that the extension does not work for them if they are using vpn or proxy. Please check if this is the case for you as well and try without vpn/proxy.
Some users have reported that the exported file does not have complete data. In all these cases, the data is trimmed after a special character (for example '+' or any other character). I am not able to replicate this issue on my end so can not fix it. If you face similar issue and willing to spend time to resolve this with me, please contact by email.
Support:
You can buy me a coffee if this tool saved your time: https://buymeacoffee.com/maninders
Details:
Salesforce does not provide any feature to extract the Dependent Picklist Matrix for analysis, comparison and reporting. This extension helps to export the dependency matrix as a CSV file and supports using "View All" for more than 5000 entries.
Compatibility:
- Supported in Classic
- Supported in Lightning
Demo for export matrix : https://youtu.be/g4nyMhoEIRk
Demo for "View All" feature : https://youtu.be/ZHaOYemMgjQ
Steps to use:
- Set the user language to English.
- Go to the Edit/view page of the Dependent Picklist, where the picklist values are included/excluded based on the Parent value. (Shown in the screenshot)
- Ensure you are on the first page of the matrix.
- right click anywhere on the web page and click "export picklist matrix" option from the context menu. This context menu option is available only in the dependent picklist matrix view.
- The CSV file will be downloaded automatically with name "<Controlling field Label>-<Dependent Field Label>". The file has a header row with first column as Parent Field and second column as Child Field.
- Characters like > are represented as > and similarly for other special characters.
For View All feature (Tested for 300 x 1000 matrix which is the max you can create):
- Click on the "View All" button to see all the values on single page.
- Be patient for the page to load. It can take some time if the matrix is large.
- If you get page not responsive alert click on "Wait" to continue processing. Do this as many times as you get alert.
without using this extension when you click "View All" you will receive error "The table has over 5,000 entries. "View All" is disabled." if there are more than 5000 entries.
NOTE: Tested to work when user language is set to English.
Giving your valuable review and rating will be an appreciation token to the developer.
v 0.0.4:
- Added support for "View All" for more than 5000 entries.
v 0.0.2:
- bug fixes
You can Follow the below Step By Step procedure to install the Salesforce Dependent Picklist Matrix Export Chrome Extension to your Chrome Web browser.
It is the Salesforce Dependent Picklist Matrix Export Chrome extension download link you can download and install Chrome Browser.
Tags: Export Picklist Matrix , Dependent Picklist , Dependent Picklist Matrix , Dependent Picklist Matrix View , Click Export Picklist Matrix , Click View , Context Menu , Context Menu Option , Responsive Alert Click , Special Characters , Dependent Field , View Page , Picklist Values , Export Matrix , Parent Field , Dependent Field Label ,
A simple extension to help Salesforce users export their contacts in a CSV.
export the report
export the report
SFDC Query Manager is a very handy extension at your disposal for querying records on the fly while being on the same page and…
Export Salesforce listview data as excel sheet
Build complex Salesforce SOQL rapidly, monitor debug logs, and launch without sharing your passwords from any Salesforce tab.
This extension make matrix.
Mighty Matrix
Salesforce Code Coverage Info
Finite Element structural analysis method and design including sizing and optimisation to Eurocode EC3