Solved: Limit Response Data to only user's submissions - Page 2

airind · 12-31-2020 01:07 PM

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

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.

View solution in original post