Content Comparison

For example, In an Account object with related Department records, you can use the Concat rollup type to list all 'Employees' in a single field on the Account. After the rollup calculation, it will return all employee names in the selected destination field on the Account object, using the specified delimiters and qualifiers.

The object hierarchy might look like this:

Employee→ Department→ Employee → Department → Account

Field to Rollup: Employee Name
Delimiter: Comma (,)
Qualifier: Single Quotes(')

• Account Name: Enzigma

  • Employee 1: "Ryan Ten"

  • Employee 2: "Natasha Hedgehog"

  • Employee 3: "Neon Tudro"

• Result on the destination field: 'Ryan Ten', 'Natasha Hedgehog', 'Neon Tudro'