Versions Compared

Version Old Version 6 New Version 7
Changes made by

Content Writers

Content Writers

Saved on

Key

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

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 a specified delimiter, such as a comma or spacedelimiters and qualifiers.

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

For example, in a Project object with related Task Owner records, you can use the Concat rollup type to list all "Tasks" in a single field on the Project. After the rollup calculation, it will return all task names in the selected destination field on the Project object, using the specified delimiters and qualifiers.

Field to Rollup: Task Description
Delimiter: Comma (,)
Qualifier: Double Quotes(“ ")

  • Project A:

    • Mark Antony : "Design mockup"

    • Natasha Hedgehog : "Develop feature"

    • Ryan Ten : "Review code"

Result: "Design mockup, Develop feature, Review code"

...