Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Advanced Minimum feature allows you to add additional mappings to the Minimumrollup type while calculating the minimum value from related records. This provides more clarity and context to the result by including additional fields that help to better understand the result in relation to other data.

Panel
panelIconId1f5e8
panelIcon:speech_left:
panelIconText🗨️
bgColor#DEEBFF

For example, consider an Account object with related Opportunity records. When calculating the minimum "Close Date" among all opportunities, you can use the Advanced Minimum feature to include additional fields in the rollup result.

  • Field to Rollup: Close Date (to find the minimum)

    Additional Mappings: Opportunity Name

    Configuration:

    • Source: Opportunity Name

    • Destination: Opportunity Details

  • Result:

    • Account: Acme Corp

      • Minimum Close Date: 2024-02-15

      • Opportunity Details: "New Product LaunchRyan Constructions CRM Consulting"

In this example, the Advanced minimum feature provides the minimum close date among all opportunities and includes the name of the opportunity with that minimum close date. This added context helps in better understanding and verifying the result.

...

Attribute Name

Description

Source

In this section, users Users can select the source field from which to perform rollup calculations or derive data.

Destination

In this section, users Users can select the field where the result of the rollup calculation will be displayed.

Additional Mappings

This button allows you to include additional fields in the rollup calculation, providing more context to the minimum value.

Order By

It specifies the field by which the records should be sorted before after calculating the minimum value.

Info

To know more about Order By, click here

...

  • The Order By feature allows users to sort data in the related list records in both ascending and descending order.

  • You can apply sorting to multiple fields simultaneously, enabling you to organize and view records more effectively.

  • This feature enhances data presentation flexibility, helping users quickly locate and analyze the information they need.