Limit Response Data to only user's submissions

[airind]

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?

[Marc_Dillon]

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?

[airind]

Can you tell I’m new?
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:

[airind]

The error

[airind]

Finally the view without showif.

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

[Marc_Dillon · Accepted solution]

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.

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…

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

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[airind]

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?

[airind]

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

[Aleksi]

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.