Hierarchical views?

Dennis_Sutch1 · ‎Apr 22, 2016

Is there a method to display a hierarchical view of records?

For instance, in a table of items, I may have a field for name and sub_item_of link to another item.

name___________       sub_item_of_______
car
wheel                 car
rim                   wheel
tire                  wheel
windshield            car
transmission          car
bicycle
banana seat           bicycle

I’d like to see a view where I can order by name and have each sub item fall under that name, and each sub-sub item fall under the name of its item.

Alternatively, can a parent item’s expanded view contain a list of all items that are sub_items, as well as showing the complete hierarchy?

Mike_Eovino · ‎Apr 26, 2016

SQL joins would make this very easy. I’d love to see that functionality.

Jason_Nordin · ‎Oct 04, 2016

Is there any activity on this feature?
This is why I came here.

Julian_Kirkness · ‎Oct 04, 2016

You are talking here about self joins I assume - you can set this up but cant really do anything with it - with no ability to Lookup values across this type of join. Self joins are quite common so it would be great to see some way of dealing with this.

Jason_Nordin · ‎Mar 07, 2017

To elaborate a bit, perhaps:

ripwit · ‎Jul 15, 2017

I also need this, very much. I’m modeling a very stratified organization that has 4-7 levels of groups and people that report to one another.

Of course, it could be argued that a graph DB (Neo4J, etc.) is much more suited for this purpose but I really/REALLY like the web interface in Airtable.