Hi team, I'm creating an attendance app which...

Hi team, Iโ€™m creating an attendance app which has a family code column and a child name column. Each family has a number of children and allocated code.

The idea is that the parent type in the allocated [Family Code] and as a result, the list of [Child Name] appears โ€œfilteredโ€ according to code.

The issue is that the whole list of children names in the worksheet shows on the list and doesnโ€™t filter according to family code !! What is the formula that I need to use to filter the list of names according to the typed code?. Also, should I use the slices option as a better solution or can it be done my way?

Hopefully, I havenโ€™t confused you

0 1 381
1 REPLY 1

Hi, you are talking about the related table structure. Please check this article how it works. help.appsheet.com - References Between Tables References Between Tables help.appsheet.com

Top Labels in this Space