Limit Response Data to only user's submissions

Hello! I saw Limiting Users to Their Own Data | AppSheet Help Center and tried the suggestion of [EmailColumn] = USEREMAIL() in my show if statement.

I have a form, and I want users to see only the responses they’ve submitted.
I have two columns now that register submitter email address: one called Email Address and then one called SupportTM_Email. Email Address auto computes useremail(), SupportTM_Email has a formula that is =USEREMAIL(). The only reason I have two is because I can’t get it to work lol. The unrestricted response sheet populates with their email addresses in the response.

However when I use [Email Address] = USEREMAIL() or [SupportTM_Email] = USEREMAIL(), it says it cannot find the column. Yet both columns exist. I added them to the view thinking it was that, didn’t help.

I’m sure this is an easy fix but I’m lost. Can you tell me how I can limit a response view to only the user’s entries?

Are we talking about slices here?
What is a “response”?
Can you provide some screenshots of your data structure and wherever you are having issues with these expressions?

1 Like

Can you tell I’m new? :rofl:
It’s a primary view that I want restricted to only their own responses. But I’m open to another way of achieving this. I’m attaching screenshots of the view, columns, error. And I’ll show what it does without any show if (blurred so I don’t get in trouble with my work)! It’ll need to be one per reply as I’m restricted as a new forum user. Here is the view: 2020-12-31_14-34-53

The error

Finally the view without showif.


Though it’s blurred, the email address and supporttm_email columns populate with the form submitter’s info.

I see. Show_If on the UX->View definition is not the correct spot for this, that is for showing or not showing the entire View. What you’re wanting to do is to filter out only some records from the Table. That expression should be enter in for a Security Filter, or a Slice. Check out this thread it should give you a lot more info.

4 Likes

I told you I was new lol! Ok MUCH closer. If I use USEREMAIL() = [Email Address] in the security filter for the data table, it does exactly what i want. But if I create a slice and put that same formula in the row filter condition, it doesn’t filter the data.

Can I do something like USEREMAIL() = [Email Address], unless your role is admin then see everything?

Nevermind. I figured it out. Created a UX view with my slice.
Marc you are my HERO!!!

1 Like

Please remember if your Data is sensitive, and you need to be 100% sure others won’t see others data, you should use Security Filter.

2 Likes