Linking records seems to me to be the least exploited, most powerful feature on Airtable.
I love the feature, but it seems to lack some continuity, IMO. Almost a head-scratcher to neglect. If I can say so respectfully. :confused:
I’m looking for three very closely related things:
If you can set a record link column to ‘single select’, why can you not arrange Kanban views by that column?
This would make things amazingly easy in several of my boards.
(For example, I have an phylogeny studies board where I group animals into a separate table of families; currently, I have to have a separate single-select list, and frequently update them to match so I can view and organize in Kanban view.)
It makes a lot of sense to be able to group by self-joins in a sort of hierarchical or nested view. This is basically the number one feature I’m feeling the need for. Similar to here. Hierarchical views?
If this needs to be a dedicated ‘parent’ type of link for that to work, or if it requires single-select, I can see either working.
I would love a mind-map view of records; really, just something like a ‘node-edge’ sort of view, edges being linked records, drawn as a line between them, ‘defining’ the relationship by the column’s name. For example, as above with the ‘parent’ self-join; or a ‘smells like’ or whatnot. Or, “Bilbo Baggins” (node/record) is “Uncle To…” (edge/link) “Frodo Baggins” (node) and “Companion of…” (edge) “Galdalf the Grey” (node).
If it could see across tables, or ‘auto-organize’ into common formats that would be awesome.But really I’m just hoping for basic self-joins only; showing the checked types of eligible relationships, and expanding records when clicked, changing attributes/links as dragged, etc. similar to the Kanban view.
(Look at ‘Tiddlymaps’ for ‘Tiddlywiki’ for an idea of what that might look like. Super simple, not a ton of features, but really robust because of the underlying wiki ‘pages’ and tagging structure. I can see this working wonders with how records already work.)
…I realize this last one is a lot bigger of an undertaking. But even a similar ‘group by’ view with a little more intelligent node-edge type relationships would go a long way.
Thank you for your awesome work!!
This literally has changed my life.
…please notice me, senpai.