Help with checking if an element exists in a dereferenced list

AppSheet AppSheet Q&A
1

I have 3 tables with the following relationship:
Tables:
Candidate
Project
PersonInCharge

Relationship:
1 Candidate can invovle in 1 and only 1 Project
1 Project can have multiple PersonInCharge

Each PeronInCharge have its own email which I wish to use it to create security filters.
When a PersonInCharge is using my app, I wish to add a security filter to the Candidate table so that it only shows Candidate in which its Project’s PersonInCharge is the current user.

I have tried IN(USEREMAIL(), [Project].[PersonInCharge])but it does not perform the filter.

The way I setup my PersonInCharge column in Project Table is as follows:
Type: EnumList
BaseType: Ref
ReferenceTable: PersonInCharge
Data IF_VALID: PersonInCharge[Email]

What am I doing wrong?

2

That sounds like it should be working. Can you provide more details, and maybe some screenshots?

Like, Candidate has a Ref column to Project, correct?

Can you confirm the values actually stored in the [PersonInCharge] column?

What are the results when "test"ing the expression?

What exactly do you mean by “it does not perform the filter”? There is an error, or it just does nothing, or…?

2 Likes
3

Thanks for the reply, when i wrote “it does not perform the filter” i meant that the filter causes the app to show no candidate at all.

It turns out when I tried to replicate the issue in a new app, it does works.

I then went back to my original app and re setup the columns and table, it miraclously worked again.

I think the first time it doesnt work was because the PersonInCharge column in Project is a virtual column instead of an actual column

2 Likes