ColumnCopy: Google chrome extension for Salesforce admins

GoogleChrome is one of the most common browser used by people across the globe. One of the most important reasons besides its speed are the extensions that google chrome offers.

In this blog post, I will share with you a very powerful extension offered by chrome, its called as ColumCopy.

10

What does Column Copy do???

With the help of ColumnCopy, you can right click on any list and you can copy the values. It not only copies columns but it also copies table values. After you have copied these values and columns you can drop those into excel, or google docs or directly into salesforce.

Below is the list of ways where I have used ColumnCopy:

1) To copy picklist values:
I was working on configuring a client’s org where I was supposed to create a picklist which was a duplicate of another picklist. Without ColumnCopy, I would have to rekey all the picklist values but using Column copy I just right clicked on the column I was supposed to copy and then pasted it into excel or you can paste anywhere in salesforce.
In Spring 16 release, they have introduced the concept of GlobalPicklist which has reduced this overhead.

2) To export object Metadata:

To export salesforce object level metadata like fields, field values or data types is very simple, but what if you have to audit the field and field values for a single object?? Column copy comes to the rescue, with the help of columnCopy you can copy the entire fields table and drop into salesforce.

Column copy is also very helpful when you have to export validation rules and workflows. Using ColumnCopy you can copy workflows and validation rules and paste them in Google Sheet for evaluation.

3) Copy field labels from Page layout: 

While working on client org, I was required to compare the current Account object fields with the new list of fields which was provided in an excel sheet. Column Copy came to my rescue, with the help of column copy I copied the field labels from the layout and put them into Excel next to the new updated values.

I was able to find out very quickly which fields needs to added or removed. With one simple right-click, I copied Account fields and pasted into excel sheet next to the new Updated list of Account fields to review.

 

Drawbacks of ColumnCopy:

Column copy extension is really great but there are few areas where this extension doesn’t work.

With ColumnCopy you can copy values as Text so if you need an HTML version copied, you will need to try another extension. You have copyTables to your rescue. It’s a similar chrome extension. ColumnCopy also is not helpful when you have to capture checkboxes.

You have copyTables to your rescue. It’s a similar chrome extension.ColumnCopy also is not helpful when you have to capture checkboxes.

Security Concerns:
Mostly chrome extensions are created are created by the third party. Google doesn’t have a process to review the security for these extensions which means anyone can create and publish these extensions. So you need to be very careful when using these extensions.

You should always review the app privacy policy and also pay attention to what information you will sharing for the app to work and also be aware of what the app developer will be doing with this information. You should always pay attention to what extensions you are installing.

So you need to be very careful when using these extensions. You should always review the app privacy policy and also pay attention to what information you will sharing for the app to work and also be aware of what the app developer will be doing with this information. You should always pay attention to what extensions you are installing.

 

 

Leave a Reply

Close Menu
%d bloggers like this:
Skip to toolbar