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! Go to 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.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |