Content Comparison

For example, in 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 OpportunityAccount. After the rollup calculation, it will return all employees 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 → Account

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

• Account Anteria:

  • Employee 1: "Ryan Ten"

  • Employee 2: "Natasha Hedgehog"

  • Employee 3: "Neon Tudro"

• Result: "'Ryan Ten', 'Natasha Hedgehog', 'Neon Tudro"'