In short, what I would like to achieve is a filtered/grouped selection when creating a new record in a table that is linked to a table which itself is linked to another table.

[mirwit]

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

Hey, I just started using Baserow and am struggling to figure out some basic things, which might also be because I am generally new to the topic of databases and co.
What I have are tables “cluster” and “topic”, where each topic is assigned one cluster. Now I have a table “solution”, where each solution is linked to one or more topics. Is there a way to make the selection of those topics visually grouped by clusters?

A picture for reference is attached. I would be interested in knowing how this is done in either form or grid view or both

Thanks a lot for the help already!

Please attach screenshots or videos if they help illustrate your question.

[cwinhall]

Hi @mirwit, welcome to the community!

From what I understand, you would need to create a lookup field of the topic linked field in your solutions table. Then you would need to create a formula field to turn the values of those lookups into text so that you can then group by those results. The formula you would use is something liek this: join(lookup('Topic','Cluster'),', ')

Here are some screenshots of how I set it up:

Cluster Table

Topics Table

Solutions Table

[mirwit]

Thanks a lot @cwinhall for the detailed reply, much appreciated! This is half of what I wanted, unfortunately the half I already have haha Sorry if my explanation was bad. Basically I have a setup that is as you re-created it here. But I would want a form/app that allows me to select from grouped records in a way we can group them in the data view. The record selector element is close enough but doesn’t allow grouping from what I have understood so far.