Data method recommendation

Ask for Help
1

Hello,

I’m building a family reunion app and would like to display family members on each persons page. While spouse is pretty easy, siblings is giving me some trouble. Can anyone recommend a good method to utilize the Relation column type such that it relates the children that have the same “mother” and/or “father”. I think it would also apply to “children” for each parents.

Thank you in advance!
James

2

I would probably structure the sheet with one column for Unique ID. Another column for name. Then two more columns the would contain the Unique ID of each parent (labeled ‘Parent 1’ and ‘Parent 2’).

You can the create a relation column to link the Unique ID column to the ‘Parent’ array column. This should give you a list of all Children (if any) for that person.

You can also create a relation column to link the ‘Parent’ array column to the Unique ID column. This should give you a list of parents that person.

1 Like
3

Thanks Jeff, how do you pick the single “Parent” array column? I think I have to either pick parent 1 or parent 2?

4

You should see Parent 1, Parent 2, and Parent. Glide creates the Parent array column. Select the Parent array column.

5

Great - thanks Jeff.

1 Like
6

@Jeff_Hager Clever!

1 Like