Group by linked table

[bobo]

I suggest the ability to group by a linked table field. I think it’s probably currently not implemented because linked tables allow for multiple linked items. Two suggestions for implementation:

1. Allow for the option to limit linked field to only link to one record. That would allow current configurations to group by that field.
2. Hoping eventually it will be possible to group by a field that allows for multiple selections (multi-select field or linked table field).

[bluegreeno]

Hello @bobo,
I was looking for this exact feature today !!
I have found a post adressing the subject

Request for Enhancement: Enabling Grouping with Fields Linked to Another Table

Hello Baserow Community, I am writing to request an enhancement in the grouping functionality of Baserow. Currently, it seems that fields linked to another table cannot be used for grouping purposes. Here is an example to illustrate the issue: Primary Table: Equipments Linked Field in Primary Table: Client (Linked to “Client Establishment” Table) Issue Encountered: When attempting to group by the linked field (Client), this field does not appear in the grouping options. This limitation hinde…

Please vote for it to make the development faster. This feature is very usefull

[frederikdc]

Hi,

There is indeed an issue for implementing this feature: Group by link to table (link row) field (#2306) · Issues · Baserow / baserow · GitLab.

Meanwhile, I work-around that I use a lot is creating an additional field. This field is a formula field with the following formula: join(lookup('Name of the Linked Field','Name of the field in the Linked table),' ').

This converts all values in the linked field to a long strong that can be used for grouping.

[bluegreeno]

I love it. Thank you very much.

[bluegreeno]

@frederikdc ,
Did you used with a “single select” linked field ?

I’ve added a concat() to make it works.

join(concat(lookup(‘Projects’,‘PM Stage’),’ ‘),’')

The workaround of the workaround…

[olgatrykush]

Hey @bobo @bluegreeno

Grouping by link to table (link row) field is already planned and has a very high priority. It should be available in Baserow 1.25 or, at the latest, 1.26: Group by link to table (link row) field (#2306) · Issues · Baserow / baserow · GitLab

We also already have an issue for limiting the link to the table amount of relationships: Limit link to table amount of relationships (one to many) (#403) · Issues · Baserow / baserow · GitLab. It’s not as high on the list as the ‘Grouping by link to table’ feature, but it should also be available in a couple of months.

You can track the progress of both features by following the GitLab links I shared.

[coolmoon]

It is already 1.27 now, any update on this group by linked column function?

[olgatrykush]

Hey @coolmoon, unfortunately, it’s not released yet. Some more urgent requests popped up, and this issue went down on the list.