Security filter With 2 tabs in 1 sheet

AppSheet AppSheet Q&A
1

Hello!

I have a problem with the security filter. Can someone plan in a zoom call to explain how this works? Is that an option?

The problem is that in my google sheet I got a lot off data from a google form. And I have different users that only must have acces to that kind off data (I hope the picture will explain a lot.)

3X_e_5_e57cd24573016e4b349b1f8eee164c1cceb2e457.png
3X_e_5_e57cd24573016e4b349b1f8eee164c1cceb2e457.png703×155 9.46 KB

And this I our u-output of the google form.

3X_0_f_0f2c24693a60d191cdfae7f3fd84092ea9d987e9.png
3X_0_f_0f2c24693a60d191cdfae7f3fd84092ea9d987e9.png1282×548 99.3 KB

How can I fiks that Michiel@hmeventing.be will only see the data that contain “Leveren 4 euro (Lier - Duffel - Sint Katelijne waver - Mechelen - Rumst)”

Thanks again!

The reason why I ask this question because I can’t found an explanation for this topic (with 2 different tabs in a sheet)

1 Like
2

@Hinse_Wouters
Try with this:

CONTAINS(
	SELECT(
		TableName[Locatie],USEREMAIL() = [E-mail adress]
	),
	[_THISROW].[Locatie]
)
4 Likes
3

Hello Thank you for helping me!

I’m just a beginner.

2 Likes
4

You’re welcome.

1 Like