Dear all appsheet creators,
How do I limit data (main table and ref table) isolated within certain people than others?
What I could do now only main table, while I have a column with user email stated, so only same email login could access main table, but ref table doesn’t have this user email, other users can still see other details in ref table except ref column.
Any trick in solving this? Thank you very much
Solved! Go to Solution.
OK here’s a working example:
https://www.appsheet.com/samples/Sample-App?appGuidString=01f8207c-c010-43bd-bd6b-e92f82857609
More info on security filters is here: https://help.appsheet.com/en/articles/954497-security-filters-the-essentials
Hope this helps! -Ty
it’s a nested calculation, something like
in([YourRefKeyField],select(usertable[YourRefKeyField,[userTableEmailField] = useremail() ) )
Sorry to do this abstractly. if you have exact names and columns from your tables, including the ref columns, I could retype it.
Dear TyAlevizos,
Thank you for your help.
The exact names and columns are in Chinese naming, but let’s take example in the sample app “Orders”.
Email for Salesman A = salesa@gmail.com
Orders[Order ID] was created, and Details[Details ID] was created for items to be purchased. I need to limit access of Salesman B for this particular Order ID and Details ID.
OK here’s a working example:
https://www.appsheet.com/samples/Sample-App?appGuidString=01f8207c-c010-43bd-bd6b-e92f82857609
More info on security filters is here: https://help.appsheet.com/en/articles/954497-security-filters-the-essentials
Hope this helps! -Ty
Thank you so so so much
Please don’t tell me you built the module purposely for me
OK I won’t
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |