Link fields in other tables show up as options for a Lookup field, but not the link fields to the self-linking table. I see a feature request for Rollups on self-linking tables (Roll Ups for Fields Linked Within The Same Table). Is there no way to use the linked field within the table for Lookup at this time?
I’d love this to work. When I’m planning a project, I have tasks A, B and C.
I want A to have children of B and C
B depends only on A
C depends on A and B
I want to be able to perform lookups and rollups on those records to pull the start and end dates from their parents for use in formulas after.
Programs like ProjectLibre work this way to set up task dependencies. Being able to perform this kind of reverse-lookup in Airtable would be a huge step forward.
Hi everyone! Lookup, rollup, and count fields now support looking up, rolling up, and counting from a linked record field that has been linked to its own table. This will make it easier to model the relationships between records that exist in the same table. Going to go ahead and set a timer for this thread to close—thank you all for your patience, and happy linking!
A couple of the posts in this topic were about a related feature request—the ability to make it so that a self-linking linked record field automatically populates in the same table. This is not yet something that Airtable supports, so I split those posts out into a separate topic: Automatic bidirectional linked records in same table.
