The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Recursive hierarchy in self-linked table using "child" relationship
Hello all, I’m working through the parent-child relationships of a self-linked table. I need to build a hierarchy or path which traverses a multi-level hierarchy using a “child” relationship. Some other solutions in these forums are focused on a “parent” relationship column, such as the excellent solution by @Justin_Barrett here:
https://community.airtable.com/t/parent-child-tree-hierarchy/44094
Using the above solution as an example, I would like to build the following hierarchy:
I’m open to other feedback on how construct this, even if it isn’t a scripting solution. I’ve just used the above example as a starting point.
I’m also aware of the parent vs child tradeoffs of self-linking tables. I’ve gone through multiple iterations of this project already, trying both approaches.
Thanks for the help!
Accepted Solutions
It took a little longer than I thought to get around to the update, but it’s done. I just added it as an option to the original script instead of making a whole new script. The link in the original thread still works, but I’ll add it here for those who might find this thread first.
