LinkedIn
Twitter
Hello everyone,
I'm trying to match an Id and a password by using a formula that check if it's the really password or not depending on the mail (USERMAIL()) and the id.
So we have two tables, one is for data register information "LOGIN" and the second is for the input on AppSheet"LOG".
First of all, I tried to use LOOKUP like this :
IF(AND(LOOKUP([Identifiant_log], LOGIN, Identifiant_login, Mot de passe_login)=[Mot de passe_log],NOT(ISBLANK(Mot de passe_log))),TRUE, FALSE).
But one criteria is missing the match between email connexion column and USERMAIL())...
After that I used SELECT :
ANY(SELECT(LOGIN[Mot de passe_login],
AND(([email connexion] = USEREMAIL()),
([Identifiant_login] = LOG[Identifiant_log]),FALSE)))
But it did not work...
Thanks a lot in advance for your response !!!
