I want my app to show me Only the users i created + show each user his data

i want my app to show data only to those who are listed in my Users sheet list (check the image '2'), then i want it to show only the rows that contain the name of that user. i tries this but seems that my logique is wrong
app capture 1.JPGapp capture 2.JPGapp capture 3.JPG

0 4 125
4 REPLIES 4

Are you sure that your Users[Email] data type is Email?
After that you can use IN(USERMAIL(), Users[Email])

https://support.google.com/appsheet/answer/10107681

Hi @Mo396 

Maybe you need to check if the USERMAIL is IN() the Users[Email] list.

Steve
Platinum 4
Platinum 4
Top Labels in this Space