Complex Multilevel tree app design

I’d like to have an app structure which allows individual elements to belong to multiple trees at different levels vs. only a single tree without duplicating data and allowing tree levels additions to be included on the fly.

I made an attempt along the lines of the Category-Subcategory tutorial at https://ogfle.glideapp.io … with the intent of having two or more inline lists available (in this case, one for Anatomy and one for physiology) based on two Parent and two Children lists.

However, it appears I can only draw from one child list at a time vs being able to use Children1 for the Anatomy tab and Children2 for the Physiology tab.

I know I can setup multiple multiple relations vs category/subcategory … but the ability to maintain a complextree structure in certain situations is advantageous.

Any ideas appreciated … Thanks very much!

Just an FYI, that I reclassified this post to unclassified. The Showcase category would be the place for this if it was the solution to your issue, not to ask for help for the solution. Also please don’t duplicate posts. You can refer to a post from another one, so just create one and if you feel it needs to be in two categories just create a short post pointing to the other main post. Thanks.

Thanks! Will do this in the future.

Hey @moses5407 - does this help? https://docs.glideapps.com/all/guides/deep-dives/data/subcategories

Hi, Jack … thanks for your reply!

The link you provided is what I based my sample app on … but with the hoped for difference of allowing any detail item to have more than one “parent” without having to repeat it in the item column.

However, it seems I can’t base one tab on one child relation list and a second tab on a different child relation list.

Without being able to gauge what exactly you are trying to do, would it help to structure your sheets using an array of columns? So you would have columns like this (‘Parent 1’, ‘Parent 2’, ‘Parent 3’ or ‘Child 1’, ‘Child 2’, ‘Child 3’). This would create a combined array column of ‘Parent’ or ‘Child’ which would allow for multiple relations in the same row.

I tried that following the pattern in the cat/subcat tutorial but I think the method used there, which makes the child connection within the Google sheet versus within glideapp data view, breaks the child array formation in glideapp.

I’m going to try it with stay columns your describe and then try setting the relations in the glideapp data view.

I’m not sure this will allow any detail element to show up under multiple branches of a tree structure though, which is the goal.