Hi everyone!
I have a problem with my APP, in a view with the formula [Checked on (date)]>(TODAY())-15 I display the data for the last 15 days. With a security filter [Station] = ANY(SELECT(User[Station], [Email] = USEREMAIL())) I only display the data of the correct station. Everything works perfectly but I have a problem with an Email address where only the formula [Checked on (date)]>(TODAY())-15 doesn’t work, it shows me all the data from the previous months the email is formatted like this
it.mxp.gse@…
It only happens to me with this email, the others all work
the account is Microsoft
Thank you
First.. change the email address with small letters and then test it.
1 Like
Only FIND Condition with AppSheet could be Case-sensitive, why do you wanna test with it?
1 Like
Hi, I tried but it doesn’t work
Hi, I tried but it doesn’t work
I have seen cases now and then when the email address was not identified when it started with upper case 
After writing it with all small letters, it has started to work. And those cases didn’t have anything to do with FIND().
2 Likes
So.. I assume the security filter works properly, right? Where are you using this formula? Is it with a slice?
What happens if you simplify your condition something like [Checked on(date)]>TODAY()? What about [Checked on(date)]>“06/01/2024”?
1 Like
I have started wrapping email fields and USEREMAIL() in LOWER() for this exact reason.
1 Like
Thanks to everyone, I solved it, rechecking the dates, practically some of them were in American format, so the filter was not hiding the data.
Thanks for your support
Good to hear!