Limit Response Data to only user's submissions

airind
New Member

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?

Solved Solved
0 8 610
1 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.

View solution in original post

8 REPLIES 8