Mambo Merge automatically works with all the fields on the record from which you initiate the merge. It also includes some related information like when a case was created. But sometimes, you may need more information from a related record. You can create Roll Up Summary fields in Salesforce to make more data from related records available to Mambo Merge.
Let’s say you create a custom field on Cases, named “Most_Recent_Case_date_ _c” and you want to use that field to calculate the most recent case date when performing a merge. You can create a new roll up summary field on Cases that will calculate the date and then add it to your template.
To define a roll-up summary field:
Create a custom field on the object where you want the field displayed. Summary fields summarize the values from records on a related object, so the object on which you create the field should be on the master side of a master-detail relationship. For instructions on creating a custom field, see Create Custom Fields.
Choose the Roll-Up Summary field type, and click Next.
Enter a field label and any other attributes. Click Next.
Select the object on the detail side of a master-detail relationship. This object contains the records you want to summarize.
Select the type of summary:
TYPE DESCRIPTION COUNT Totals the number of related records.
SUM Totals the values in the field you select in the Field to Aggregate option. Only number, currency, and percent fields are available.
MIN Displays the lowest value of the field you select in the Field to Aggregate option for all directly related records. Only number, currency, percent, date, and date/time fields are available.
MAX Displays the highest value of the field you select in the Field to Aggregate option for all directly related records. Only number, currency, percent, date, and date/time fields are available.
Enter your filter criteria if you want a selected group of records in your summary calculation. If your organization uses multiple languages, enter filter values in your organization’s default language. When you use picklists to specify filter criteria, the selected values are stored in the organization’s default language. If you edit or clone existing filter criteria, first set the Default Language on the Company Information page to the same language that was used to set the original filter criteria. Otherwise, the filter criteria may not be evaluated as expected.
Set the field-level security to determine whether the field should be visible for specific profiles, and click Next.
Choose the page layouts that should display the field. The field is added as the last field in the first two-column section on the page layout. For user custom fields, the field is automatically added to the bottom of the user detail page.
Click Save to finish or Save & New to create more custom fields.