CRX id
fpieolagnlkejcpejlbjgbdpaglffacj
fpieolagnlkejcpejlbjgbdpaglffacj
Description from extension meta
Saves the Dependent Picklist Matrix as a CSV file
Image from store
Description from store
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 support the app development here: https://buymeacoffee.com/maninders
For any queries contact by email.
Why you need this app?
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 : https://youtu.be/k0Q91yrtCeE
Licence:
This extension requires a paid license key subscription and offers a free 7-day free trial. Your card will be charged at the end of the free trial. You can cancel the subscription during this trial and you will not be charged.
This app was free for use for more than 3 years. To compensate for the effort required to keep this app working we have set up paid licence with minimal cost and a free trial.
Steps to use:
- Install the Extension
- Set the Salesforce logged in 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.
- You will see option to purchase a licence on this screen.
- Once you have purchased the licence, right click the extension icon to the right of the Chrome address bar and select "Options". Enter the Subscription License Key and click "Save".
- You will have to refresh the picklist matrix page for the update to take effect. Now you can use the extension.
- Ensure you are on the first page of the matrix.
- Click the Green "Export Matrix" button. This button is added by this extension to the page only if you have a valid licence.
- 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.
- The csv data is also copied to the clipboard.
- 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.
17/03/2023 (v0.8)
- The csv file now contains all values of the matrix with INCLUDED/EXCLUDED flag for each
v0.0.6:
- Fixed bugs, modified UI and added Licensing
v 0.0.4:
- Added support for "View All" for more than 5000 entries.
v 0.0.2:
- bug fixes
Latest reviews
- (2023-03-24) The tool is no longer working in my chrome browser. I am using Version 111.0.5563.64 Updating review 2023-03-24: tool requires admin edit permission to work.
- (2023-02-28) Paul Sulit: Very helpful!
- (2022-07-13) Jayanthy Ambady: This is very useful.
- (2021-11-08) Stephanie Poorman: This works beautifully
- (2021-10-21) Ed: NICE!
- (2021-08-31) Dmitri Goreshnik: Very useful extension. Saved a lot of time
- (2021-08-11) Robyn Jungers: This just blew my mind. AMAZING!! Exactly what I have been needing and absolutely LOVE IT!! Clearly, quickly and easily view your picklist values and their dependent values.
- (2021-07-22) Blanca Ramírez Magaña: This is a super helpful extension, you will need it when you have a huge field dependency matrix in SFDC!
- (2021-05-26) Nathan Graber: This is a great tool for exporting dependent picklists. As indicated in the description, I did have to disable my VPN to get this to work. I would love a feature to be able to export this data based on record type as well. Basically, from the field dependency screen, if you click Preview, you can filter by record type, and it would be very helpful to be able to export the field dependencies after being filtered for the record type. As-is this is still great and a big time saver.
- (2021-04-27) Ray Rudd: Great Extension! A must have for Salesforce Administrators. I was quickly able to provide a large field dependency matrix to our management team. An awesome time saver.
- (2021-03-17) Sushama Patchala: Excellent tool! Kudos to the development team!!!!
- (2021-03-17) Arpi Komaromi: Great Extension, saved me lots of time
- (2021-02-10) Carlos Tovar: Great Stuff!
- (2021-01-18) Jason Alpert: This worked flawlessly.
- (2020-12-30) Charmaine Ong: Awesome tool , practically a no-brainer to use and it does the job (fast).
- (2020-11-17) Dave Holford: It isn't all-singing, all-dancing, but it does what it says on the tin and it works first time. For me, that makes it a winner. This one is "going in the swag" of useful extensions I use every day.
- (2020-06-29) Evan Johnson: Works as expected. Just right click on the page showing the dependencies and an option is available allowing you to export.
- (2020-04-07) Brahmaji Tammana: Excellent one
- (2020-04-06) Kamal Kishore Singh: Very nice and easy to use maninder. Awesome.
- (2020-02-06) Sevda Tuna: Saved me a lot of time! Easy to install and use.
- (2020-01-20) Rahul Sharma: Very Useful
- (2019-12-18) Very useful - highly recommend!
- (2019-12-09) Daniel Rivero-DeAguilar: easy and quick to install/execute. Saved me a bunch of time.
- (2019-12-09) Becky Neate: Great tool - much needed for Salesforce field - will save me alot of time moving forward.
- (2019-11-18) Arvid Bux: Amazing extension. Saved a lot of work from my end. I had a small issue getting it installed, after an email to the developer this was solved and it was easy sailing. A must for any Administrator using Salesforce
- (2019-10-28) Brian Karcinski: Great time saver
Latest issues
- (2022-01-31, v:0.0.4) Rob Kirchner: Is there a way to export a chain of dependent picklists?
For example, Picklist 1 drives choices on Picklist 2 . Picklist 2 then drives choices on Picklist 3, etc. I can kind of work it out manually via two separate exports But its pretty manual and still requires me to double check everything. It'd be great if there's a way to start at the 1st controlling field and work out all the possible "paths" depending on picklist choices. - (2021-09-07, v:0.0.4) Santiago Torres: It is not working
Hi, The extension is not working. I am not connected to VPN or anything, regular Wifi. The export is not working and it does not dowload any file. - (2021-08-06, v:0.0.4) P P: Export issues when we have few hundred's pick list values
When i try to export picklist matrix it is only returning a fraction of the dependency I was able to get one dependency to work but the others only give me a small fraction of the results. Where there should be several hundred lines I am only returning 10-15 in Excel - (2021-05-26, v:0.0.4) Josh Harsh: When i try to export picklist matrix it is only returning a fraction of the dependency
I was able to get one dependency to work but the others only give me a small fraction of the results. Where there should be several hundred lines I am only returning 10-15 in Excel. - (2021-04-20, v:0.0.4) Nancy Franklin: Written instructions
I am having trouble with the speakers in my laptop, and as a result I cannot hear the video playback. Are there written instructions on how to use the Dependent Picklist Extension? - (2020-08-07, v:0.0.4) venkat k: is it possible to increase controlling picklist value fields to 500
Hi Maninder, I really liked this Plug-in, installed extension and starting using. we have a situation where there are more than 500 Picklist values to one of the controlling field where i want to download CSV and identify those controlling fields where no dependent assigned. But , plug in is not supporting to download for more than 300 controlling field columns. is that something you can increase that to 500 ? - (2020-07-29, v:0.0.4) Ritu Aggarwal: List cutting off during export
First off, this Dependent list extraction is great - saves a lot of time! Thank you! I'm having an issue with one specific dependent list, and my hunch is because of a special character in the picklist value. The value has a "#", so the extraction stops right before it runs into that character. Is that correct? If yes, please advise if there are any other known charters that cause an issue for this extension. Are you able to add this to a safe list of characters? (Sorry I'm non-IT and limited on code knowledge.) - (2020-05-04, v:0.0.4) Bonnie Neuhardt: Extension loaded but doesn't show up list when you right click
Hi. I loaded the Salesforce Dependent Picklist Matrix Export. When I go the dependent list in Salesforce it doesn't show me the "option to export picklist matrix". Any suggestions? - (2019-12-10, v:0.0.2) Kristopher Estrada: List cut off
Hi. I get the csv file but the list cuts off after a certain sub value. The value happens to have a special character "+". Thanks! - (2019-11-01, v:0.0.1) matic eth: Not Working
I tried this extension on my dev environment(Lightning Experience) and right click extention, but csv not downloaded