Hey,

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.