Hiding Certain User based Data, PDF and URL

[CaptainKid406]

The app I created has user profile where they can upload PDF's and URL links and for privacy purposes I'd like to have only the user that submitted that data and the admin be able to see those PDF's and URL links. Best way to do this? Thanks in advance for any help!

[CaptainKid406]

Here is a screen capture of available columns and Databases

[Moniker]

It's not an error.
It's just letting you know that AppSheet changed the permission of that User Schema (From read only to Updates + Read only) may be.

[Steve]

BTW, if you're trying to implement logins within the app itself, you're violating the terms of use.

[CaptainKid406]

Nope, those will either be removed or replaced. They were placeholders until I knew how many users there would so I could purchase the correct amount of licenses without going over by too many. 

[AleksiAlkio]

You need to use Security Filter. Formula would be something like IN(USEREMAIL(),LIST("admin@domsin.com",[User Email]))

[Steve]

See also: Security filters: The Essentials

[CaptainKid406]

Thanks all, I did put in a security filter and added a Admin table with just my information however a signed in user can still see all the links. Please see the pictures and let me know if there is other information you need. 

Background: Creating a MTG budget league and I need users to be able to upload their decklists. However their decklists should only be viewed by the user who uploaded and the admin, myself. Currently anything shared is able to be viewed by all users. 

[Steve]

Not a security filter:

[CaptainKid406]

 

Ok, I found it in the link you provided under the Users Own Data. Do I have it in the wrong location?

[Steve · Accepted solution]

Here:

I looked over the docs on security filters. They need some work. @lizlynch, I submitted some comments.

[CaptainKid406]

Great, thank you! For the help with this one and the last question I had you also help answer it.

So if I wanted to restrict certain columns only within the table would I add in a Show_If expression? 

[Steve]

Yep!

[AleksiAlkio]

Buy please remember that hiding the column is not secured in any way. It just hides the column, nothing else.

[CaptainKid406]

Hey all, this technically solved my issues but raised a few more so I've reset the app back to before the security filter using OR(IN and would like to try and transition to a IF(_THISROW expression. 

If I wanted to only show these two rows to users that entered the data and the admin how would that go? IF(_THISROW=[Deck List PDF], ISNOTBLANK....?

Thanks again all. 

[Steve]

This:

OR(
  (USEREMAIL() = [User Email]),
  IN(USEREMAIL(), Admin[Email])
)