Nov 16, 2022 06:36 AM
Hi
First I have a table with a linked column that returns unique values (allowing multiple records = FALSE). Note the actual source column is a formula.
Second I want to build a kanban view over those linked unique values but the option doesnt show.
What am I missing?
Nov 16, 2022 11:56 PM
I think the Kanban view only works with Single Select
and User
fields I’m afraid
As a workaround, perhaps you could create a single select field and an automation that would, whenever a record’s linked field gets updated, pastes that value into the single select field, and use the Kanban view on that?
Nov 17, 2022 03:31 AM
tks the issue is I want the link. below print of data structure maybe there’s a smarter way to go about it.
Nov 17, 2022 03:34 AM
Hm, yeah, you’d have two fields, the original Linked
field and the new Single Select
field that you’d use the Kanban view on?
Nov 17, 2022 04:02 AM
But then I have to maintain both which defeats the purpose. Or could I automate the single select to mirror whatever linked value gets assigned? Can I do that?
Nov 17, 2022 04:07 AM
Yeap, I recommend an automation that would, whenever a record’s linked field gets updated, pastes that value into the single select field, and to use the Kanban view on that
Then you won’t have to maintain the single select field, but can still view the data the way you want to
Dec 09, 2022 04:30 AM
I'm now trying to implement the automation above however apparently there is no way to automate the insert to single select fields? Any pointers are appreciated.