Filtered Groups for Lookup columns

1

Hi all,

we have a lot of tables where we use the groups feature of tables for Kanban boards or Maps.

However, the grouping options don’t fit our use cases:

  • We need a sub set of the groups. Hence, we can not use the option “show all groups”
  • Empty groups should be visible. Hence, we can not use the option “show only groups with values”

What we are missing is an option between both group options “show all groups” and “show only groups with values” – maybe

  1. “show filtered groups” with the capability to define a filter for a lookup table
  2. and a check box “show groups with values”

Is there something planned to enhance the grouping feature for lookups?
If not, does anyone know a workaround?

Please see the following example, I hope it is visible to the public:

Thanks in advance!
Marco

1 Like
2

Dear @Marco_Klemm,

Welcome to the community :handshake:
Would you mind to update the sharing settings as below?

image
image1243×84 6.25 KB

image
image862×67 4.35 KB

3

Dear @Jean_Pierre_Traets,

Thanks a lot! I’ve just tried, but my domain has a restriction that I cannot share a link outside the domain :frowning:

Here is a screenshot:

image
image1153×645 12.9 KB

image
image491×548 21.1 KB

I hope that helps for understanding the problem.

Thanks!
Marco

1 Like
4

I think I’m grasping the question here. My suggestion is to use a View of this table that only shows the groups you want to display in your card view. Then you can Show All Groups for that view where the ones you don’t want are already filtered out.

5

Thanks, @BenLee! Unfortunately, it is not possible to select a view as a lookup column.

6

Hi @BenLee does this actually work? I created a view that filters to a subset of the groups. However, when I use the “Group options” > “Show empty groups,” I actually see all empty groups EVEN if they have been filtered out of the view.

7

Hi @Anthony_Yam,

I just tried this myself and found that you can’t filter out blank groups even if you filter the view. I asked out engineers as well and this is working as intended. But … we can definitely see the use-case and that this would be beneficial, so we’re adding it as a feature request.

For now, if you’re using a Select List or a Text column type, you can “pin” the groups that you want to stay. It depends on your setup as to whether this will help as a workaround though. If your groups change a lot or if you have lots of groups to go through, this could be too cumbersome.

8

Thanks for making the feature request and for the workaround suggestions!

1 Like
9

Hi,

I have the same need. Is there a solution since the last post?

thanks

10

Any updates on this, @BenLee? Is it still a feature that Coda team is considering to implement?

The option to show empty groups and apply a filter on them (so only relevant empty groups are shown) would be very helpful in many situations.

1 Like
11

Indirect work has been getting done on groups that can lead to this being possible, but direct work on this hasn’t been done yet.

Groups aren’t all that easy to make happen and they also aren’t easy to make performant so our current work has been optimizing those types of aspects that will hopefully pave the way for other improvements like this in the future.

Sorry it’s not better news at the moment, we just have some foundational work to do first. It’s not a forgotten request though.

3 Likes
12

Thanks, @BenLee! Great to know! :partying_face: