Hello everyone! I am having trouble with a s...

[Aparicio_Pineyr]

Hello everyone!

I am having trouble with a security filter. In a single table I had 4 [Email] columns. I add an OR(USEREMAIL()=[Email1],USEREMAIL()=[Email2]…) but is not working. Any advise on this?

Thanks!

[Aleksi_Alkio]

In what way it’s not working?

[Aparicio_Piney2]

@Aleksi_Alkio

This is the formula that I add in the security table: OR((USEREMAIL()=[Email1]),(USEREMAIL()=[Email2]),(USEREMAIL()=[Email3]),(USEREMAIL()=[Email4]))

I enter in the App with an email that is not inside thouse columns and is still showing all the data for that table.

[Aparicio_Pineyr]

@Steven_Coile

I am looking at the App itself

[Steven_Coile]

@Aparicio_Pineyrua1 Is this in a prototype app, or a deployed app? If deployed, your licence may not permit the use of security filters.

[Aparicio_Pineyr]

@Steven_Coile

Is it not deployed and I believe the owner of the App has a Premium account.

[Steven_Coile]

@Aparicio_Pineyrua1 did you try using the in() expression I gave you above?

[Aparicio_Pineyr]

@Steven_Coile

I will try when I get home

[Steven_Coile]

@Aparicio_Pineyrua1 I’m gonna guess you’ve been bitten by the odd behavior of the = operator: if one of the operands is blank, the result is always true! So if any of the email columns is blank, the entire or() expression is true, regardless of the user’s email address. in() doesn’t suffer this problem.

[Aparicio_Pineyr]

@Steven_Coile

I belief that could be the issue. I will check it later on. I’ll keep you update.

Many thanks!

[Aleksi_Alkio]

What is the app name and account ID? I will check it. Thanks

[Aparicio_Pineyr]

@Steven_Coile

Many Thanks! This works perfect!

[Aleksi_Alkio]

Try… OR(USEREMAIL()=[Email1],USEREMAIL()=[Email2],USEREMAIL()=[Email3],USEREMAIL()=[Email4])

[Aparicio_Pineyr]

@Aleksi_Alkio

Not working Translate

[Bellave_Jayaram]

Try:

IF( OR((USEREMAIL()=[Email1]),(USEREMAIL()=[Email2]),(USEREMAIL()=[Email3]),(USEREMAIL()=[Email4])), TRUE, FALSE)

[Aparicio_Pineyr]

@Bellave_Jayaram

Not working

[Steven_Coile]

@Aparicio_Pineyrua1 in(useremail(), list([Email1], [Email2], …))

[Steven_Coile]

@Aparicio_Pineyrua1 Can you elaborate on “not working”? Is Expression Builder giving an error? Or are all rows making it through? Or no rows? In what way is it “not working”?

[Aparicio_Pineyr]

@Steven_Coile

Hi Steven, I enter in the App as a co-author. The email that I’m using as a co-author is not enter in any of the 4 [Email] columns in the table that I add te security filter, and when I enter in the App it still showing me the rows inside that table when it shouldn’t.

[Steven_Coile]

@Aparicio_Pineyrua1 That you are a co-author shouldn’t matter, unless you’re telling me you’re looking into the workbench/editor rather than the app itself, and the workbench is showing you the rows despite the security filter. Could you clarify for me?

I would expect the security filter to omit all rows within the app based on what you’ve said.