[Feature Request] Enable Group Pinning options for Look Up Table column

Suggestion Box
1

When a column is detected with a number of Coda objects from a foreign table, pinning is disabled for groupings using that target column.

Because of this, I either have an excessive amount of columns when grouping on this column, or cannot see columns for which no cards exist - preventing me from using a proper Kanban workflow.

What am I trying to achieve

I want to have a master database that has a column “Status” to indicate a task status, and multiple different views into it in card view that each only show a subset of the possible statuses in always have these columns visible if no card is in them so that the Status can be adjusted by drag and dropping cards. (Kanban / Trello behaviour)

Concrete Example: Given [ Planning, Considered, Questions, Actionable, In Progress, Reviewable, Complete], I want a card view that shows only the columns [ Actionable, In Progress, Reviewable, Complete] and does not hide these columns if there are no cards for them.

Does a work-around exist?

No - I can create a secondary column on the task table in which I filter for the target Statuses, and use a formula to map over the value from the primary Status column. However, I then lose the ability to drag cards between columns and have their Status be updated.

Reproduction steps

See this embed, or follow below instructions:

  • Create a table “Status”, and fill it with relevant status values.

image
image.png900×454 18.1 KB

  • Create a table “Task”, create a Name column, and a Lookup Table to “Status”, or formula to grab values from “Status”.
  • Create a view into Table, and group on “Status”.
  • RMB to manage the groups on the view
  • Observe that the option menu doesn’t allow pinning any groups.

image
image.png1311×670 36.6 KB

Expectation
I expect to be able to pin certain values in a Grouping that derives from another table, much as I can with any other value set.

2 Likes
2

Dear @GJ_Roelofs,

:bulb:In general it’s a good practice to create a dummy doc where you put the example and explain the expected outcome.

This will make it more easily to make analysis, without reproducing the doc, respecting the time of the community members

1 Like
3

Thanks for the tip - I’ll update the posts tomorrow morning.

1 Like
4

Yes, please, this is a such needed improvement to grouping!

Without it it’s impossible to use lookup column and filter the values you want to use for grouping (at least I can’t figure out how to do it).

5

Dear @Andrei_Kharlanov

I guess your question is clarified at this post

6

As far as I understand, no, this post doesn’t help, because there is no option to pin values from a lookup column when grouping.

An option to choose which values to use for grouping even from a lookup column will be very useful, i.e. choose which groups to show (in table and cards views) even if these groups currently don’t have any rows in them AND not to show any other groups (even if they have rows associated with them).

1 Like