How to effectively display grandchild relations?

I have projects that have milestones that have details. The details are also linked back to the project directly. I was looking for ideas on how to best display those grandchildren in a single view? we currently have an interactive dashboard that shows projects and that affects a detail view on the right side. We designed the app without milestones in the middle and have to retrofit them in. The functional portion of it is working fine but the visual side could use some work. I don’t really know how to display the details for a milestone while still on the project. Any ideas are welcome but I would like to avoid adding more views to the dashboard.

A detail view of what? Can you add an inline view of these grandchild details to this Detail view?

a detail view of the project(grandparent).

I assume you have

Parent
Child
grandchild

Three tables

First, you should have a ref in child table to look up parent. In this field, you store parent row ID.

Then on the grandchild table, you have ref to look up child. In this field, you store child table row ID.

You make another field, either vc or physical and push app formla, using deref type expression to pull Parent row id fields value from child table into grandchild table. Then make this fields type also ref type but looking up to Parent table.
Then you can quickly and naturally establish relationship between Parrent and granparent, where you will see inline view for grandchild associated rows in detail view for parent table.

There is a physical column that links the grandchild to the parent already. This displays the grandchild and child in inline views but the relation between child and grandchild is not show in the best way. what grandchild is related to what child is not the easiest to see. I was looking for if anyone has effective ways to display that relation in the parent.

What would you consider an effective way? Ignoring AppSheet’s limitations.

1 Like

I’m not sure what is the best way from you and prospective.

Not really sure. Maybe similar to the interactive dashboard where I click the child inline view and the other inline view filters down to the grandchild? would be the effective solution?

1 Like

I would set your inline grandchild view to Group By the child (its direct parent).

3 Likes