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?