Create a view with dynamic data

[Gustavo_Rocha]

Hello all,

I’ve been struggling with this problem for a while, so any help will be welcome. So, I’m building basically a genealogy tree. The references go as:

Every person in the sheets have their own data and a reference column to his mother and another to his father. Every father/mother can have as much sons and daughters as they want. The problem I’m having, is that I want a view that if I click in any person (through an action button for example), I would show all his kids.

It doesnt necessarily has to be a view, but I want to show, somehow, the kids from any parent I click on.

And btw, sorry to put another question inside, does anyone know if its possible to create a view that actually shows the genealogy tree ?

Thank you all

[Rifad · Accepted solution]

help.appsheet.com

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view