Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Hierachy within the same Table

204 0
Showing results for 
Search instead for 
Did you mean: 

I am trying to create a hierarchical structure for different projects.
To simplify the whole thing let’s say there are 3 Tables: Categories → Project → Tasks

I would like to create a hierarchy within the Projects Table. As far as I know, it is not possible to create both-way sync within one table but I was hoping to achieve that with automation.

My current automation selects the parent ID and adds the record to the child column.
(To be more specific: The automation selects the original record + a lookup of the current child values and writes that in the child column)

The problem arises when I change multiple parent records at once.

Is there a better way to do that?
Ideally, I’d love to recreate the sync both ways option from Notion when linking a table to itself.

Thanks for the help already.

0 Replies 0