Valid if Expresions to Email Password Log In

[yastaaa]

Hi,

Have a form to enter Email and Password. Users have previously registered in another form entering [User Email] and [Password]. The Data Table is Users.

Now i have a View Form Log In, where the user is asked for [Email] and [Password].

I wanted to check that the Email entered is Valid, to be valid it must be in the Users Table.

The expression for Email is Working.

The second validation will be the password based on the Email entered.

Tried the expression above which shows to be valid but is not working.

[Steve]

ISBLANK([_THIS]) in both Valid If expressions is pointless: Valid If is not used if the column value is blank.

In the Valid If for password, remove the [_THIS]=[_THISROW].[password] expression.

[yastaaa]

But if i don’t use the ISBLANK the text box does not show. Maybe because when you open the form [_THIS] is blank and in consequence there will not be any User with a blank Email in the IN() Expression.

[Steve]

Ah, right. It’s because a Valid If expression containing just an IN() expression produces magic behavior, and you have to work around that magic. I suggest using FALSE rather than ISBLANK([_THIS]), if just to avoid any confusion that ISBLANK() is material. Or leave ISBLANK() as it was. Whatever the case, this doesn’t contribute to the problem validating the password.

Hi Folks, I have a scannable column which i... Questions

You’re getting bit by some AppSheet magic. If Valid_If consists of a column reference (e.g., ProductMaster[StockCodePrefix]) or entirely of an IN() expression (as you’re using), AppSheet makes the assumption that the list (the column reference or the list in the IN() expression) contains the entirety of the allowed values and presents the user with a dropdown menu containing only those values. In your case, you don’t want the magic and the auto-generated dropdown menu. The workaround, as @Alek…

[yastaaa]

Steve:

I suggest using FALSE rather than ISBLANK([_THIS]) ,

Did this.

[yastaaa · Accepted solution]

Tried this:

In the Invalid VAlue Error Message and it works.