Skip to main content

Hierarchical views?

  • April 22, 2016
  • 5 replies
  • 47 views

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?

5 replies

Forum|alt.badge.img+4
  • Known Participant
  • April 27, 2016

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


Forum|alt.badge.img+3
  • Known Participant
  • October 4, 2016

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


Forum|alt.badge.img+4

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.


Forum|alt.badge.img+3
  • Known Participant
  • March 7, 2017

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


To elaborate a bit, perhaps:


Forum|alt.badge.img+12
  • Known Participant
  • July 16, 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.