OK Interesting problem.
My app is a score tracking app. Functionally everything is working perfectly.
With this app each user has the ability enter a score independently of the next user. This is also true for their own score entries to be viewed in a table. The idea is that when they are in the app, they do not have to select who they are to submit. just enter and save, done deal.
I do this by creating a user Entry page for every user. Then using the “Showif” function with the formula CONTAINS(USEREMAIL().firstname.lastname@example.org) the only user that can see that particular Entry page is whom ever with the "email@example.com" email address. This works wonderfully if I’m never changing users.
I have setup an admin portion to the app which allows me to assign Users Name to a unique entry page. What I need now, is a formula for the Showif function to look up the name assigned or rather the email assigned in my table for that User to view and use the Entry page.
Believe I’ll need to run a LOOKUP command to find the specific table. Then tell it if it CONTAINS the USEREMAIL in that particular Row of the table.
In a Spreadsheet I can figure this out, with the appsheet Expressions on the other hand… Playing a lot of guess work.
Anybody able to help with this?