Security filter for parent table based on child records.

[NyeinChan]

Hi, I just want to know whether this feature is availabe in appsheet or not . Generally I have two tables , one is person and another one is appointment.

In the person table, without security filter, there could be tens of thousands of rows which makes significant impact in syncing data. 

Appointment is the child table of person table, person_id is the foreign key here . So, not all persons will have appointment .

What I want to do is to create a security filter for person table to show only the rows matched by person_id which is present in appointment. For eg, to show only Chan, John and Musk in the person table in appsheet. 

Is there any formula or work around to do this function in appsheet?

Thanks 

Nyein Chan

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357277-in

[NyeinChan]

Thank you, Marc.

I try to use In() in the security filter in the person table. 

IN(appointment[personID],person[personID])

It's showing me the following error. expression is correct but it doesn't work actually.

Table 'person' has an invalid security filter '=IN(appointment[personID],person[personID])'. The filter expression cannot reference the table being filtered.

[Marc_Dillon]

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...

[NyeinChan]

Thanks, Marc,

I've made a few changes to the expression and this one works now in the security filter of the person table. 

IN([personID],appointment[personID])