Rollup: Display a List of Strings from a Linked Table Attribute

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!

I’m a bit of a Baserow noob, so there is a good chance I’m misunderstanding your requirements of the functionality - but wouldn’t a simple lookup achieve this?

@spook has the right approach here. What you’re looking for is a lookup, not a rollup.

Ah very great I used the wrong type. I got confused with the German specification names. It is working now!

1 Like