Skip to content
Jim Bartek + Git edited this page Jul 26, 2016 · 17 revisions

Welcome to the declarative-lookup-rollup-summaries wiki!

(This wiki is a work in progress)

#Installing DLRS

You can either install the managed package which will save you space against your app and tab limits, or you can install the latest unmanaged package into Production or a Sandbox with the links in the Package Release History in the README

Permissions

There are two types of DLRS Users:

Admin

Kind of a tool admin user that both configures and activates the rollups (this has to be an admin to deploy and manage the trigger for example). This user also needs full read/write access to all the objects in the package.

User

Then there is the users that don't directly use the tool, but indirectly invoke its rollups. These users need read access to all the objects in the package. You don't however need to give them access to the app, tabs or Visualforce pages for example since they don't need to be able to access the tools admin UI.

Assigning Permissions

  • You can click on Permission itself Lookup Rollup Summaries - Process Rollups and there is a button Manage Assignments. From the page that is displayed you can create a List View to filter for the users you want, tick them and click Add Assignments.
  • You can update a Profile by giving Read access to the following objects, Lookup Rollup Summaries, Lookup Rollup Summary Logs and Lookup Rollup Summary Schedule Items.
  • Finally, if you didn't find the first option useful enough, you may want can try out the free The Permissioner tool on AppExchange.

Professional Edition

It is now possible to install the managed package in a Lightning Professional Edition and configure entries to trigger Process Builder to action the declarative roll up summary. (per 341)

#Creating a New Lookup Rollup Summary

Lookup Relationship

Parent Object

Enter the API name of the object in salesforce.com that you want the rollup summary to be stored on

Child Object

Enter the API name of the object that you want to query and rollup to the Parent Object

Relationship Field

Enter the API name of the lookup field on the Child Object relating to the Parent Object

Relationship Criteria (Optional)

If you would like to filter the Child Object records that get summarized enter the SOQL WHERE query here.

e.g. Amount > 200 AND Stage = 'Closed Won'

Examples & Details

Relationship Criteria Fields

Any field used in the Relationship Criteria needs to be entered here, one field per line e.g.

Amount
Stage

Rollup Details

Field to Aggregate

This is the field on the child record

Field to Order By

Aggregate Operation

Aggregate Result Field

Where on the Parent to place/write the result

Active

Calculation Mode

Calculate Job Id

Text Rollups

Concatenate Delimiter