Solved: Starting View Questions - Page 2

Luke_Vancleave · 07-01-2020 11:06 AM

Hi, I want to set the starting view for new users to be the form to create a new personnel profile. I have a list of personnel with their emails that I can reference their useremail() against. I’m basically trying to say, "If the user’s useremail() isn’t currently in the list of Personnel (meaning they haven’t been added yet), have their view start on the Create New Personnel Profile view.

IF(
NOT(
IN(
Useremail(),Personnel[email])),Create New Personnel Profile,About)

I can’t seem to get this to work when I try to preview in the mini view to the right. Any advice?

Lucinda_Mason

try adding quotes around the form names. It shouldn’t matter but there are cases where it does.
AppSheet remembers where a user left off and SOP is to return to that view when the user returns to the app. If you are trying my trick with changing your email address in your users table, do that, remember to tab out of that field so it is saved, then
delete the app and AppSheet from your phone.
reinstall AppSheet and then load your app. that seems to clear issues when nothing else works.
when you open the app, since your email no longer exists in your users table, it should load Create New Personnel Profile view

View solution in original post