Redirect based on email in Sheet not working

[Scott_Nesbitt]

I am trying to have app permission based on emails in a Sheet.  Here is my logic for Starting View:

IFS(IN(USEREMAIL(), SELECT(Options[Superusers], TRUE, TRUE)), "Home",
       IN(USEREMAIL(), SELECT(Options[Users], TRUE, TRUE)), "Home",
       TRUE, "Permission Lacking"
)

I have an Options tab in the Sheet, and in it are two columns, Superusers and Users.  Each row has an email address.  However, it never redirects to Home, always the Permission Lacking view.

Any  idea what is wrong?

Thanks

[graham_howe]

This exact scenario is answered here with several potential expressions  Solved: Starting View - Google Cloud Community  perhaps one of those would work?

[WillowMobileSys]

Please note that the above post was submitted, I think, BEFORE AppSheet introduced the "save the last visited view" feature.  It used to be that the Starting View was always honored each time a user launched the app.  But then you couldn't create a "first-time" view without some data capture to "remember" who saw the "first-time" view.

[WillowMobileSys]

The Starting View expression will only apply the very first time a user logins in to the app or after a re-install of the app.  After that, AppSheet "remembers" the user's last visited view and will return to that view the next time the user re-launches the app.

Testing Starting View changes from a device will require an uninstall and re-install of the app.

You can test these changes in the emulator by simply refreshing the browser page after Saving the change.  This will reload the emulator as a newly launched app.

------

By the way, you can simplify your expression into this:

IF(IN(USEREMAIL(), Options[Superusers] + Options[Users]), 
   "Home", 
   "Permission Lacking"
)     

[Scott_Nesbitt]

It caches that information forever?  There is no way to force it to re-evaluate the Starting view?  This seems crazy to me. 

I am specifically concerned about the browser view, since you cannot uninstall/reinstall there.   (Thanks for the expression simplification, btw.)

[WillowMobileSys]

I believe it is a saved user app setting - not just a cached value.   I don't know if it resides on the device only or somehow saved with the app.
As for the Browser, I had never really played with it but did just now.  For me, it seems to always open up to the Starting View.  I actually changed it and then it always opened to that Starting View.