Security Filters - switch to "no filter" if logic statement isnt true

[Jethro]

Another small puzzle:

Is there any way for me to do the following in Security filters:

Logic:

If the Users email contains the text “Enumerator” then the value in the column [enteredby] should be equal to users email. If not then no filter should be applied.

I use the following:

IFS(Contains(Useremail(),“Enumerator”),[enteredby]=Useremail())

However if Useremail doesnt contain “Enumerator” I want no filter applied and all data can pass.

The reason I want this is that I restrict data later in slices however I want to restrict what is synched to the enumerator phones.

[Aleksi]

At leaset IF(Contains(Useremail(),“Enumerator”),[enteredby]=Useremail(),TRUE) should work.

[Jethro]

Hi Aleksi,

The “TRUE” was what I needed. Once again my appreciation!

[Aleksi]

You’re welcome