Only user can view their own data and one mail address can view all data

I have one table with names logs and following column values

Iwould like to display only user can view their own data by comparing with their email
I just tried on this syntax
[Team Member]=Usermail()
TEAM MEMBER initial value set as Usermail()
but this will worked on users data filtering, but one email can view all data for verification so there is any hope in this issue???

Hi

You may want to have a look to this:

To do so:

This:

will be:

OR(
  USEREMAIL()="authorized@email.com",
  USEREMAIL()=[Team Member]
)
2 Likes

Sorry @Aurelien . As I was active on this page, I did not see , you have already replied. :slight_smile:

2 Likes

:rofl:
@Suvrutt_Gurjar
I was on something else, I did not even notice you answered. Just got an email notification.
Actually to me that’s ok if we both answer, I don’t know if there is some kind of implicit rule about replying together to the same post ?

1 Like

Thank you @Aurelien. No, I do not think there is any implicit rule not to reply together, especially if the reply adds more value, different insight. I just noticed that my answer was on similar lines as yours, so it did not do any value add. :slight_smile: That is why I deleted.

Keep contributing :+1:

3 Likes
2 Likes

thnkss @Steve :hugs:

1 Like

thnkss :hugs: