Hi everyone,
I’m trying to use a Rollup field to display the values of a specific attribute (for example, “Name”) from a linked table as a list of strings in my main table. My goal is for the Rollup field to simply show all the names (or other text values) from the linked records as a list, like:
"Value1", "Value2", "Value3"
I’ve tried all the available rollup types, but none of them seem to return a simple list of strings. The existing Rollup functions like sum, max, min, count, etc., are all focused on calculations or aggregations, and don’t provide a direct list of the values.
My setup:
• I have a “Link to table” relationship.
• The Rollup field is correctly configured (link field and attribute selected).
• No matter which Rollup function I use, I never get just the list of strings.
My question to the community:
How can I configure a Rollup field to simply return the values (e.g., names) of a specific field from all linked records as a list of strings? Is there a trick, a special function, or a workaround?
If this isn’t currently possible, I think this would be a very useful feature for many use cases (for example, API outputs, documentation, etc.).
Thanks in advance for any tips or advice!
Background:
According to the docs and the UI, there currently isn’t a Rollup function that simply returns an array of values as strings-only aggregations are available. If anyone knows a workaround (maybe using formula fields or external tools), I’d really appreciate your input!