Hierachy within the same Table

499 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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