Versions Compared

Key

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

The Add Rollup Action enables users to aggregate and compute data based on applied filter criteria within an object structure. This action facilitates accurate data rollup and calculation.

Info

References

This section allows users to define and apply multiple rollup aggregate actions within a single hierarchy.

You can add multiple Rollup Types, such as Average, Concat, Count, Count Distinct, List, Maximum, Minimum, and Sum, within a single rollup by using the Add Rollup Action option button.

...

What is source field?

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

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

For example, If you need to calculate the maximum age among students, you would select the "age" field from the "student" source object.

...

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

Example:

  • Objective: Calculate the maximum age among students.

  • Source FieldObject: Age student

  • Source ObjectField: student Age

By selecting the appropriate source field, you can easily compute and aggregate data as needed.

...

What is destination field?

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

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

Example:For example,

  • Objective: Show the maximum age of students in a university.

  • Destination Field: Choose the appropriate field from the list of available fields in the university object.

If the desired field is not available, you can create a new field directly from the rollup interface using the Create New Field option.

...

If you do not have an existing field to display the result, you can create a new field directly from the same page. Follow these steps:

...

  1. Click on "Create New Field"."

...

  1. Provide a label and an API Name.

  2. Select the appropriate Field type either Number or Text that best represents your data.

  3. Provide a description for the field.

  4. Click "Save.

...

By following these steps, you can easily create a new field to display your rollup calculation results.

...

Note: Ensure that the newly created field is added to the appropriate page layout to make it visible and accessible.

...