Concat Rollup Type
- Content Writers
The Concat rollup type combines all the values from the selected field into a single, concatenated string. This is useful for merging text or other data types into a single field, allowing for a comprehensive view of the data in a unified format. Values are typically separated by specified delimiters and qualifiers.
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 → 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'
Configuration
When you select the rollup type as Concat, you will see the following configurations:
Attribute Name | Description |
|---|---|
Delimiter | Specifies the character(s) used to separate concatenated values in the resulting string. Note: Although, users are not restricted to what delimiter they can use, we recommend you these standard delimiters for better viewing and understanding of data. |
Qualifier | Defines the text to be added before and/or after each concatenated value. Note: Although, users are not restricted to what qualifier they can use, we recommend you these standard qualifiers for better viewing and understanding of data. |
Return Unique Values Only | This checkbox determines whether to include only unique values in the concatenated result, excluding duplicates. |
Order By | Specifies the order in which values should be concatenated (e.g., alphabetical, by date). |
Standard Delimiters Suggested
Name | Delimiter |
|---|---|
Comma |
|
Period |
|
Colon |
|
Semicolon |
|
Pipe |
|
Standard Qualifiers Suggested
Name | Qualifier |
|---|---|
Single Quote |
|
Double Quote |
|
Bracket |
|
Parenthesis |
|
Curly Braces |
|
Underscore |
|
Percent |
|
Order By
The Order By feature allows users to sort data in the related list 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.
Related content
If you have any concerns or queries then please contact us at support@orektic.com