Appsheet Starting View Expression

Hi there, I have a question.

How do I want to set an expressions in my starting view like:

If the user not registered, they will go to "Sign UP' page, BUT if the user is registered, they will go to "Main Page". And I want it to detect by email.

I have table "User Details" which have column Name, Email, Role.

I try to create expressions like this but now I'm stuck;

if(
ANY(USER DETAILS[EMAIL])<>USEREMAIL(),"SIGN UP","MAIN PAGE"
)

 

Thank You

Solved Solved
0 2 123
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

This:

if(
ANY(USER DETAILS[EMAIL])<>USEREMAIL(),"SIGN UP","MAIN PAGE"
)

Should be this:

if(
IN(USEREMAIL(), USER DETAILS[EMAIL]),"SIGN UP","MAIN PAGE"
)

View solution in original post

2 REPLIES 2

Steve
Platinum 5
Platinum 5

This:

if(
ANY(USER DETAILS[EMAIL])<>USEREMAIL(),"SIGN UP","MAIN PAGE"
)

Should be this:

if(
IN(USEREMAIL(), USER DETAILS[EMAIL]),"SIGN UP","MAIN PAGE"
)

Hi sir,

It works! Thanks a lot

Top Labels in this Space