Tuesday, July 12, 2016

In short, Octopus is a free app available in AppExchange built by Astrea It Services Pvt Ltd. Octopus allows you to document all the items in your Salesforce org. Get information about apex classes, pages, workflows, triggers, objects, fields and much more in a single place. You can also download it as a PDF/Word file for future reference.

To get information about Approval Processes, Validation Rules, Workflow Rules, Workflow Field Updates, please ensure that your Salesforce instance URL has been added in the remote site settings - navigate to Setup | Administer | Security Controls | Remote Site Settings, for example, if your Salesforce instance is ap1.salesforce.com, the Remote Site URL would be https://ap1.salesforce.com

Once installed from AppExchange, navigate to Octopus tab, select items you would like to document, or you can select all items. Click View button or PDF or Word icon, and done. With just an easy a few clicks, you will get result from Salesforce org with information of:

Name

Namespace Prefix

Table Enum or Id

Active

Last Modified Date

Sample result:

Even you downloaded the information as PDF or Word document, you still can click the Name link to open the real metadata in Salesforce.

Tuesday, July 5, 2016

Schema Surfer offer the fastest way to browse and explore your Salesforce object metadata. Whether you need to quickly see all the child relationships of an object, determine if an object is queryable, or determine what is the object prefix , Schema Surfer is the app for you.

Here are a few of the great features included in Schema Surfer:
- Filter object list by API Name
- Filter object list by Label
- Filter object list by three character object prefix
- View all fields about an object in a grid or sortable table/list layout (Label, API Name, Data Type)
- View all the child and parent relationships for an object on one page
- Drill down on a field to view complete field level metadata information

Why I bold sortable? because Salesforce default object / field view is not sortable - vote for this idea.

Once Schema Surfer you installed, navigate to Schema Surfer tab, or click + tab if you not see it on default.

Saturday, July 2, 2016

Declarative Lookup Rollup Summaries Tool is one of the most popular free tool for Salesforce admin built by fellow Salesforce MVP - Andrew Fawcett.

Out of the box, Salesforce support Roll-Up Summary field when the parent-child relation is Master-Detail relationship. But in many cases, we have to use Lookup relationship, example: sharing setting, when the child record owner may differ with parent record owner, and etc.

Without this tool, you need to engage developer to write trigger (and test class) in child object to roll-up the value to the designated parent field. With Declarative Lookup Rollup Summaries Tool, as admin, we just need to install the package and do a simple configuration to enable it, you can choose either real-time or scheduled (hourly, daily, weekly, etc).

In this sample, I would like to count number of Lane records and roll-up to Opportunity object. You cannot select Active at this moment until deploy the child trigger. So, just save this without select Active checkbox.

4. Deploy Child Trigger

Click "Manage Child Trigger" button and click "Deploy" button. This step will create a trigger in the child object.

5. Activate the Lookup Roll-up

Navigate back to "Manage Lookup Rollup Summaries" tab and select Lookup Rollup Summary created, now you should be able to enable Active checkbox to activate the roll-up configured.

6. Real-time or Scheduled

In the "Calculation Mode" you can choose Real-time or Scheduled (we will not discuss Developer and Process Builder in this blog).

Select Real-time will auto calculate when child record added, modified or deleted. Select Scheduled, you need to schedule when the calculation trigger, click "Schedule Calculate" button to schedule when it will be triggered, by a specific hour, hourly, specific day, etc. Example: you can configure multiple hour, such as: daily 2 AM and 6 AM by hold Ctrl key when click.

You can monitor next scheduled run from Setup | Jobs | Scheduled Jobs.

If you configure the calculation mode as Real-time on existing child object with records, parent record will not be auto populate with the roll-up value until there is activity in a related child record, either create, update or delete. So, you may need to create another roll-up with Scheduled to calculate existing values.