Creating a Kanban view stacking (grouping) by contacts

[Arnau_Lamarca]

Hi there,

I don’t know exactly whether this question goes here or under table design but see below my challenge.

On my base I have different tables but the main ones are contacts and projects. Under contacts I have all person details, emails, etc and use these to send automated emails etc. My table projects I have different views and the Kanban I currently have is ‘stage’ view. We are growing quite fast and, now I would like to have a Kanban view which stacks the projects that certain people in ‘contacts’ table are running but to do this I would need to create a ‘single select’ field. This would duplicate my work as I already assign the project to a contact, linking the tables and running automations in the background. Just checking in to see if anyone can think of a smart way to stack / group by contact if that makes sense.

Thanks in advance,
Arnau

[Mohamed_Swella1]

Hi @Arnau_Lamarca ,

Welcome back to Airtable Community !

As you said, a Kanban view requires a single select field. The reason for that is when you move a card from one stack to another it would change the “status” of that card.

You would need to use a 3rd party app like Stacker or Softr to do something not quite the same but very close.

[ScottWorld]

@Arnau_Lamarca As you said, the only native Airtable solution would be to duplicate your work. You could create an automation that automatically copies the value from your other field into a single-select field.

[Arnau_Lamarca]

Thanks for getting back to me @Mohamed_Swellam and @ScottWorld , I will explore both of your options a bit further and let you know!