Skip to main content
Solved

Recursive hierarchy in self-linked table using "child" relationship

M

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!

Best answer by Justin_Barrett

I got parent-to-child parsing working after tackling the problem in a different way. The script at the link above has both options now.

View original
Did this topic help you find an answer to your question?

Justin_Barrett
Forum|alt.badge.img+20

Welcome to the community, @maqjara! :grinning_face_with_big_eyes: Thanks for the nod! I can definitely see the benefits of working the tree from the other end, and I don’t think that it would take much to modify the script that I shared in the other thread. I’m tight on time at the moment, so it might take me a few days, but I’ll see what I can do.

M
H
2 people like this
  • M
    maqjara
  • H
    Hendrik_Yang
H
Forum|alt.badge.img+18
Justin_Barrett wrote:

Welcome to the community, @maqjara! :grinning_face_with_big_eyes: Thanks for the nod! I can definitely see the benefits of working the tree from the other end, and I don’t think that it would take much to modify the script that I shared in the other thread. I’m tight on time at the moment, so it might take me a few days, but I’ll see what I can do.


Thanks @Justin_Barrett for your contribution. Your few scripts help us a lot. You should set up ko-fi :grinning_face_with_big_eyes:

Justin_Barrett
Forum|alt.badge.img+20
Hendrik_Yang wrote:

Thanks @Justin_Barrett for your contribution. Your few scripts help us a lot. You should set up ko-fi :grinning_face_with_big_eyes:


Thanks for the recommendation! I just set up an account. I won’t link it here in the thread, but you can find it in my profile.

H
1 person likes this
  • H
    Hendrik_Yang
Justin_Barrett
Forum|alt.badge.img+20

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.

M
H
E
3 people like this
  • M
    maqjara
  • H
    Hendrik_Yang
  • E
    eccmbr
Justin_Barrett
Forum|alt.badge.img+20

I got parent-to-child parsing working after tackling the problem in a different way. The script at the link above has both options now.

Reply


Most helpful members this week

Terms & Conditions