Adding Restrictions for all tables based on email and table column value

[Fleet_Cruisin]

Hi,

I would like to add restrictions on my all tables based on user email and one column value in each table.
For example : app using email id is sample@test.com then need to show all the rows in each table where location is Alaska. Like this 4 combination. conditions for checking is both USEREMAIL() and Location Column in the table. This applies to all the tables.
Thanks in advance.

[JuneCorpuz]

This might help.

help.appsheet.com

User Settings: The Essentials

Give users more control to customize app behavior.

help.appsheet.com

Security Filters: The Essentials

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

[Fleet_Cruisin]

Hi thank you for the reply. Working well.

[MultiTech]

I just typed up a post explaining how you can build out a slice system that allows the app to know who is using the app (based on USEREMAIL() ).

Current_User (Slice) - How to conform your app around WHO is using the app Tips & Tricks 💡

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…