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.