Monday, October 29, 2018

Profile and Permission Set Helper

When you have a profile assigned to 1 or 2 users with different extra permission compare to other profile, it is a good chance to merge the profile and create a permission set for that 1 or 2 users.

Profile and Permission Set Helper from Salesforce Labs help admin to easily convert existing Profiles permissions in your org to Permission Sets. Within a few clicks, you can clone all Permissions from a certain Profile to Permission Sets, which are ready to be assigned to new users in no time!

Once the app installed, select Profile and Permission Set Helper app, there will be only 1 tab called Converter, then select the profile that you want to convert into Permission Set.

Notes: this app is only work in Lightning.



The conversion process is very fast, only a few seconds, and it will create a new Permission Set as you named it. The existing profile will still be there and not touch.



Now, you can assign the permission set as per normal to users, and delete the profile when required.


Type: Managed Package; AppExchange

Paid/Free: free

Publisher: Salesforce Labs

Installationhttps://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000FeF99UAF

Version: 1.5


Blog last updated: 29 October 2018



Wednesday, September 12, 2018

Field Footprint

You probably heard about Field Trip, one of the most famous free app available in AppExchange, this tool able to analyze fields population, this is very useful when you are doing field clean-up or to get data completeness. However, Field Trip has not updated since Jun 2015.

Field Footprint is kind of similar to Field Trip, but with additional features, such as checking record type, field usage in Validation rules, Workflow rules, Workflow Field Updates, and Reports.

On top of that, one thing I notice from this tool compare to Field Trip, when running a Field Trip to analyze an object with 134K of data, Field Trip required 75 minutes, while running Field Footprint analyze to the same of dataset, Field Footprint only need 25 minutes, so the performance is 3x better.

Once complete, you will see the result in the Footprint Detail page, or open Footprint results in a report.



With this tool, you also can check fields usage per record type, click the record type name in the main analysis page, it will tell you how many records for that record type and the population for each field.




Type: Managed Package; AppExchange; Private Listing

Paid/Free: free

Publisher: Salesforce Labs

Installationhttps://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EShrRUAT

Version: 2.8.33


Blog last update: 13 September 2018

Etherios EasyDescribe - Free MetaData Viewer/Extractor

EasyDescribe is a free tool to view and extract "object" metadata details. Don't waste time clicking through multiple screens to lookup record types, field types, picklists, and other metadata. EasyDescribe it and get everything at once!

Once the app installed, select EasyDescribe tab and select an object you would like to extract. You can turn on or off items you would like to extract, from fields, child relationship, and record type.



Type: Managed Package; AppExchange; Private Listing

Paid/Free: free

Publisher: West Monroe Partners

Installationhttps://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ

Version: 1.91


Blog last update: 12 September 2018

Tuesday, February 13, 2018

Salesforce Config Workbook

If you need more than just export Salesforce fields to Excel, such as Field Level Security, Page Layout, Profile, Flow, Field usage and many many more features that help admin life easier - Config Workbook by ConfigWorkbook would be your choice.

Once installed, you will be presented with a dashboard showing metadata breakup, code breakup, user login, and much more at a glance.



Then, you will also find a bunch of metadata reports defined, from object, profile, flow, user, permission set, layout and so on.



You can try this tool for free for up to 8 reports, get it from AppExchange.


Sample page layout report for Lead object




Type: Managed Package; AppExchange

Paid/Free: free for up to 8 reports

Publisher: ConfigWorkbook

Installation: https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000000q4evEAA

Version: 2.99


Blog last updated: 13 February 2018




Saturday, February 10, 2018

Field Dumper: Easily export your Salesforce fields to Excel

Salesforce allowed us to view all fields from an object in a glance, including Field Label, Field Name (API Name), Data Type, Controlling Field, and Indexed. However, sometimes we just need to extract it for different purposes:
- Documentation
- Audit
- To compare all formula
- To get help text for each field
- To export from many objects
- etc.

With Field Dumper, a free tool available in AppExchange, admin can easily export Salesforce Data Model to Excel. Produce an Excel document that lists out your data model - showing field level information for your Salesforce objects. Supports extract of multiple custom and standard objects to one workbook.

This tool works for both Classic and Lightning Experience UI.


The excel file produces may contain multiple tabs, one tab for one object, each tab will have following info:
- API Name
- Label
- Type
- Is Custom
- Is External ID
- Is Unique
- Is Formula
- Is Required
- Dependent Picklist
- Length
- Formula Text
- Help Text
- Picklist Values


Type: Managed Package; AppExchange

Paid/Free: free

Publisher: POP

Installation: https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EJg2hUAD

Version: 1.2.0


Blog last updated: 10 February 2018


Friday, November 17, 2017

Show Password

Chrome definitely is the most famous web browser at this moment, and if you are a Salesforce admin, consultant, or developer like me, you probably have many Salesforce login credential. Chrome is smart and makes our life easier by cache the password, so we do not need to remember it or using 3rd party tool to store it. But somehow, we can't see the password directly in the browser, example if we need to login using Data Loader or Salesforce mobile app.



1. From Setting Menu
As Chrome setting menu is keep changing by the versions, rather than to memory which menu should I go, just search with "password" from the settings menu, go to Settings and type "password", it would filter just menu related to password, then select "Manage passwords".



This will list down all username and the password (in masked) stored in Chrome, click Show password (eye icon) to see the password, Chrome will ask your Google password for security.




2. ShowPassword Chrome extension
As you may aware that Chrome has so many extension develop by people around the world, and most of them are free. There is an extension called ShowPassword built for the purpose to reveal the masked password in Google Chrome.

When this extension added to your Chrome, by default, you just need to hover your mouse over the masked password text for 0.5 seconds to reveal the password, or you also can change the way to reveal the masked password.



Type: Google Chrome extension

Paid/Free: Free

Publisher: a1618@love.com

Video: https://www.youtube.com/watch?v=71vyCtuFn-I

Installation: https://chrome.google.com/webstore/detail/showpassword/bbiclfnbhommljbjcoelobnnnibemabl?hl=en

Version: 1.1.5



Blog last updated: 17 Nov 2017