You need to sign in to do that
Don't have an account?
nksf
How can I show Field Dependency matrix in Excel
Hi I am looking for a easy way to print or export a large Field Dependency matrix in excel. I am new to saleforce please guide me with complete details.
Field dependencies are part of the Metadata which cannot be manipulated via standard functionality.
I would like to suggest you to take a look to the following options:
First the link to the PDF File that contains all the necessary information to be able to handle the Metadata API that Salesforce has available:
http://www.salesforce.com/us/developer/docs/api_meta/api_meta.pdf
Also, there are other 3rd party application which allows you to export the data so it may help you to achieve what you need. An example of this application: http://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ
A last option might be to look at the Force.com Migration tool to export the Metadata, manipulate the appropriate Metadata XML files by hand and then migrate over back to your Production instance.
http://www.salesforce.com/us/developer/docs/daas/salesforce_migration_guide.pdf
All Answers
Or are you trying to print a Matrix report that you have created in Salesforce.
Please elaborate on your requirement so we can suggest accordingly.
Field dependencies are part of the Metadata which cannot be manipulated via standard functionality.
I would like to suggest you to take a look to the following options:
First the link to the PDF File that contains all the necessary information to be able to handle the Metadata API that Salesforce has available:
http://www.salesforce.com/us/developer/docs/api_meta/api_meta.pdf
Also, there are other 3rd party application which allows you to export the data so it may help you to achieve what you need. An example of this application: http://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ
A last option might be to look at the Force.com Migration tool to export the Metadata, manipulate the appropriate Metadata XML files by hand and then migrate over back to your Production instance.
http://www.salesforce.com/us/developer/docs/daas/salesforce_migration_guide.pdf
Here is the javascript that you would save to your own webserver:
Here is the bookmarklet code you would use to call your hosted code:
Steps to use:
1. Create a bookmark in your browser with the following info (this example uses my hosted code, which you welcome to use):
Name: SFDC - Field Dep Scrape
URL: javascript:void((function(){var e=document.createElement('script');e.setAttribute('type','text/javascript');e.setAttribute('charset','UTF-8');e.setAttribute('src','https://s3.amazonaws.com/datawin-wwwroot/SFDC/fieldDepScrape.js?r='+Math.random()*99999999);document.body.appendChild(e)})());
2. Navigate to the "Edit Field Dependency" in SFDC (click on Edit in the Field Dependencies area of the picklist properties).
3. Click the bookmark you created in Step 1.
4. A Popup screen will display the flattened data with column 1 contains the master fields and column 2 the dependent fields.
This will work whether you are viewing all columns or sets of 5.
Hope this helps!
Kenny
Uncaught TypeError: Cannot read property 'innerHTML' of undefined
at setColumnNumbers (fieldDepScrape.js?r=49219182.26176515:27)
at main (fieldDepScrape.js?r=49219182.26176515:10)
at fieldDepScrape.js?r=49219182.26176515:3
Any ideas how to get past this?
Here is the updated Java Script: This script assumes that Salesforce is showing 5 columns per page.
My above script is still set to only hadle 1000 rows but if anyone wants to use it they can set a bookmark on their browser and point it to this:
Again this is a little different than the original script it is going to ask for the number of rows which can be found on the
Regardless, it works in classic.
VM1597:1 GET https://s3.amazonaws.com/datawin-wwwroot/SFDC/fieldDepScrape.js?r=47280996.56450779 net::ERR_ABORTED 404 (Not Found)
For anyone having issues with not being able to use the 'View All' button, you can simply edit the javascript of the button so it allows the method to fire.
So change the javascript button
from: 'href="javascript:alert('The table has over 5,000 entries. "View All" is disabled.')'
to: 'href="javascript:picklistSetup.showColumns(-1)"'
Hi guys, it's Kenny again. It's been a while since I posted this and I haven't monitored it very closely. I'm glad it's helped people. I've since sold the startup I cofounded (yay!) and all the assets went with it (boo!), including my Salesforce id and the AWS account. Anyway....Here is that same hosted file you can use but with its new url:
https://datawin-wwwroot2.s3-us-west-1.amazonaws.com/SFDC/fieldDepScrape.js
Hope that helps!
The chrome extension wouldn't work for me.
I have managed to run the code above and the pop appears asking for the number of columns and then when I click ok and messages appears
"Sorry, I don't recognize this page or its format :( "
I have tried in Lightning and Classic.
Can anyone help please?
Thanks
Ross