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

[Arjun032]

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???

[Aurelien]

Hi

You may want to have a look to this:

help.appsheet.com

Security Filters: The Essentials

You can use Security Filters to control which records a user can see and update.

To do so:

• go into the Security panel
  
  
• type your filter expression

This:

Arjun032:

[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???

will be:

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

[Suvrutt_Gurjar]

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

[Aurelien]

@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 ?

[Suvrutt_Gurjar]

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. That is why I deleted.

Keep contributing

[Arjun032]

thnkss

[Steve]

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

[Arjun032]

thnkss @Steve