Skip to main content

Kanban View based on Lookup field - single Select or Collaborator


Forum|alt.badge.img+16

Continuing the discussion from Calendar View based on Lookup field dates:

Now that Lookup fields work for Calendar Views, please extend this functionality to Kanban View.

My use caseā€¦

I have a base that covers our video content management and review process. Three key tables and fields are:

  1. Table of Videos: Title, Description, etc.
  2. Table of Reviews, including fields for when the last review was, a formula for when the next review is due, and who will do the review.
  3. Table of Account users, including fields for peopleā€™s name, their role in video content management, email address, and a Collaborator field type named Airtable user. (Most, but not all of the team will have Airtable accounts.)

Iā€™d like Kanban Views of Videos / Reviews stacked by the Lookup field which references a single Airtable user. Videos / Reviews kanbans would be stacked by each Airtable user assigned. Any Videos / Reviews assigned to team members who arenā€™t Airtable users would be listed in the Uncategorized stack.

Lookup field extension is a massive feature extension for Calendar Views. Letā€™s do likewise for Kanban! :grinning_face_with_smiling_eyes:

14 replies

Iā€™d also like to use a lookup field as the grouping on a Kanban View.

I am using a base to manage a product roadmap. Thereā€™s a table of Features and another table of Release Dates (among other things). Iā€™d love to use the Kanban View to group features by release date, given that itā€™s a single-select lookup field.

My workaround at the moment is to create a single-select dropdown that mimics the value of the lookup field.

Hope this is the best way to ā€œvoteā€!


This. Please. I want to be able to Kanban view attendees by event.


  • Participating Frequently
  • 7 replies
  • November 26, 2018

I have a table listing locations, and another table listing site visits. One of the data points for a site visit is the location, and I want to create a Kanban view grouping my site visits by location. To do this, Iā€™d need to get rid of my location table, and maintain the list of locations in the site visit table, and every other table that references location.

I see this was requested more than a year ago. Is it on the roadmap? Please let us know.


  • New Participant
  • 2 replies
  • January 30, 2019

Literally. Begging. For. This. Capability.


Dragging in an entire bag of +1


Any progress on this? Add one more request to the list, please!


  • New Participant
  • 1 reply
  • May 2, 2020

Any progress on this please?


Forum|alt.badge.img+5
  • Inspiring
  • 8 replies
  • June 18, 2020

+1 from me.

Lookup fields are critical to creating good normalised structure and the kanban view is a great way to visualise these into groups.


  • New Participant
  • 1 reply
  • December 31, 2020

+1 as well, super interested in this feature, itā€™d allow us to have Trello like views, itā€™d be grand!


Forum|alt.badge.img+12

This would be great, and Iā€™m not quite sure why we canā€™t do it? I have a linked field (actually from a synced base) that relies on a single select status field.

I do not want to double enter my statuses. I do need to keep my statuses up to date, as theyā€™re the field I want to show to my developers so I can use this view to keep them on track for deliverables.

Does anyone have a workaround?


Forum|alt.badge.img+17
Lauren_Briskin1 wrote:

This would be great, and Iā€™m not quite sure why we canā€™t do it? I have a linked field (actually from a synced base) that relies on a single select status field.

I do not want to double enter my statuses. I do need to keep my statuses up to date, as theyā€™re the field I want to show to my developers so I can use this view to keep them on track for deliverables.

Does anyone have a workaround?


Maybe you can create an Automation that update the Kanban field from the Synced field.


Forum|alt.badge.img+12
Elias_Gomez_Sai wrote:

Maybe you can create an Automation that update the Kanban field from the Synced field.


Thank you! I should have closed the loop here. Thatā€™s exactly what I did. Hereā€™s what I did:

This definitely works best with a paid version of airtable, because it requires syncs and automations, but I synced the original table with the statuses to the table with the kanban view.

(This part is probably extra, but I did it because Iā€™m extra.) I made a linked record from the synced table to the table with the kanban view (they have an obvious relationship- records in both tables are the states of the United States and the District of Columbia). I added a look up field to that table with the status field. I also created a placeholder field for ā€œstatusā€- I only use it if for some reason thereā€™s a problem with the automation, which there occasionally is.

Then I did created an automation- when the synced tableā€™s status updates, the automation updates the status in the kanban view.


  • New Participant
  • 1 reply
  • June 13, 2022
Lauren_Briskin1 wrote:

Thank you! I should have closed the loop here. Thatā€™s exactly what I did. Hereā€™s what I did:

This definitely works best with a paid version of airtable, because it requires syncs and automations, but I synced the original table with the statuses to the table with the kanban view.

(This part is probably extra, but I did it because Iā€™m extra.) I made a linked record from the synced table to the table with the kanban view (they have an obvious relationship- records in both tables are the states of the United States and the District of Columbia). I added a look up field to that table with the status field. I also created a placeholder field for ā€œstatusā€- I only use it if for some reason thereā€™s a problem with the automation, which there occasionally is.

Then I did created an automation- when the synced tableā€™s status updates, the automation updates the status in the kanban view.


Hi Lauren
This sounds really useful.
I am trialing AirTable at the moment and would have the same requirement, but no idea how the automations work yet. Is there anything you can share?
I have Process stages the work flows through in a table and want these to be the KanBan statuses, but core functionality doesnā€™t seem to allow.
Thanks
Graham


Forum|alt.badge.img+12
Graham_Drew wrote:

Hi Lauren
This sounds really useful.
I am trialing AirTable at the moment and would have the same requirement, but no idea how the automations work yet. Is there anything you can share?
I have Process stages the work flows through in a table and want these to be the KanBan statuses, but core functionality doesnā€™t seem to allow.
Thanks
Graham


The automation ended up working fine for this, but I can barely remember what I did anymore. I have a single-select status field that I never touch in the table with the kanban view (you can even lock it and make the editing permissions only available to automations). Then I adjust the statuses on the other table, which has a bunch of other stuff thatā€™s irrelevant to my developers.

When we update the statuses on the table we use most of the time, the automation updates the status view that the developers need.

I hope thatā€™s helpful!