Restrict users to only their records (by email)

[Gittel_Marcus]

Hi. I have an app where people can add records, and I’ve restricted the tables to filter out existing records. What I want is an ability to have the user see all and only their records, per view.

How can I acheive that. Is there a formula to enter in one of the views? Where?

Thank you.

[Suvrutt_Gurjar · Accepted solution]

Please go through the below. You could use slice or security filters. However, please do understand the difference between security filters and slice filters before choosing one.

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

help.appsheet.com

Security Filters: The Essentials

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

help.appsheet.com

Limiting Users to Particular Tables, Views, and Actions

How to make sure that your users can see and do only what they need to

[Gittel_Marcus]

Thank you! I definitely am interested in a security filter, but it’s a bit tricky.
I have a table of Growers that includes GrowerName, Email, Country, Company.
I have a table of Farms which include GrowerName, Farm details.

I want the Farm table to have a security filter that restricts to the GrowerName, based on useremail(), (which is technically contained in the Grower table, not the Farm table.

What would the syntax be?

• LOOKUP(Grower, Grower, Email) = username()

?

[Gittel_Marcus]

I tried this, and it’s not working:
LOOKUP(Grower, Growers, Grower,Email) = useremail()

[Lynn]

Hi @Gittel_Marcus

help.appsheet.com

LOOKUP()

Get column value from row in table or slice