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.
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.
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...](https://community.appsheet.com/t/hi-folks-i-have-a-scannable-column-which-i/914/3) 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…
