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…