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

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.

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

1 Like

Hi Aleksi,

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

You’re welcome