I am creating a dispatch app that is used to assign students to volunteer opportunities. Ultimately, I would will be using a security filter so that each student only sees the opportunities they have been assigned to. I have read the following article and watched the app demo video below, but still have a question.
Suppose I am assigning John and Jane to an opportunity together. When I am assigning a student to an opportunity I select which student(s) I want to assign from an enumlist in a column called [confirmed student]. Once the students are selected, their email addresses automatically appear in [Team email]. [Team Email] is the column I would like to use to use as the security filter so that John only sees opportunities assigned to him and Jane only sees opportunities assigned to her.
My question is:
How do I write the expression for the security filter so that it recognizes when [Team Email] contains a useremail instead of when it = useremail.
Thank you for you help!