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