Copy Dependent Picklists Quickly and Easily From Salesforce

Do you have field dependencies and you’d LOVE to copy the edit screen for that dependent field? I know I do and from what I’ve seen many others do too.  A Google search on this topic will bring up a litany of Salesforce Ideas for an exportable or printable view and countless questions about how to get a usable version of this list out of Salesforce. The most common use case seems to be the need to put the list into a file format, excel for example, where it can be reviewed, sorted, edited etc. It’s a convenient way to share the list with people, add to documentation or embed in training slides.

The best and most flexible solution that I’ve found is a Google Chrome plugin called Copytables. It’s great because it works on other tables in addition to Salesforce. It’s a multitasker – Yay!

Copytables – Grab the plugin here and follow along with the steps. https://chrome.google.com/webstore/detail/copytables/ekdpkppgmlalfkphpibadldikjimijon?utm_source=chrome-app-launcher-info-dialog

Copytyableimg

  • Pick a field with a dependency and go the edit screen.
    • Right click over the table
    • Click TABLE then Select Table

This will highlight the entire table!

Copytyable1

  • Click TABLE > COPY > AS IS

I like to use AS IS to retain the colors in the table. Why? In Excel, you can sort by color so it is quick work to weed out irrelevant values. Very cool and very fast!

Copytyable2

  • In a blank excel worksheet, use PASTE or CTRL V to paste your table.

Presto – there it is! Not only is it easy to copy and paste but it’s in a usable format!

Copytyable3

  • Lastly, Enjoy 🙂
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s