I’m having some trouble writing this expression. Here’s what I need:
I have an action button inside the view ANIMAL_DETAIL.
Lets suppose I’m seeing the details of a female dog named “Annie”
Every animal has its father and mother (references to the same table - to another animals). So, in this view, Im gonna show all animal’s “kids”. (in the example, all annie’s kids)
So, I want the linktofilteredview to go to the “Kids” view (that’s working), and to compare the Animal’s name from previous view (ANIMAL_DETAIL) to all data in the google sheets.
If the animal in the previous view (animal_detail) is a female animal, to find all animals that have their mother named the name in the previous view (annie).
If it’s a male, all the animals whose fathers have its name.
I’m having trouble because I don’t know how to get the info (annie’s name) from the previous view I was on.
I’m not sure if it’s too confusing, english is not my first language hehe… Anyway, if it’s needed, I can explain it again
Thank you all