Custom filter

Hello friends, how are you ? I have a doubt that I can't solve at all. Not even reading the posts on the forum or the manuals I can understand. In my application I have two tables. The LOGISTICA table which contains the delivery information, and the  table which contains the username and e-mail. There is a column that is present in both tables and contains the same information, it is the Veรญculo column.

I would like that as soon as the user enters the program with his e-mail, the program only shows the visualizations that contain his Veรญculo, because both tables have this information. I have more than 20 vehicles and I think there is something easier than creating 20 different slices just for this filter.

Logรญstica.PNGUsuรกrios.PNG

Thank you very much!!!

Solved Solved
0 3 130
1 ACCEPTED SOLUTION

One slice with

[veiculo] = LOOKUP(USEREMAIL(),"USUARIOS","E-mail","Veiculo")

View solution in original post

3 REPLIES 3

Please take a look at the following article on security filters.

Limit users to their own data - AppSheet Help

 

One slice with

[veiculo] = LOOKUP(USEREMAIL(),"USUARIOS","E-mail","Veiculo")

Thank you so much! Everything working around here

Top Labels in this Space