Hello I would like to make a simple verification process with a form (where after stored on successful verification further steps follow)
In a form the email is queried - which will end up in the same row as another email (from a database) -> can I build a view which filters only by the end of the email address?
Field 1 (submitted field)= @123.com
Field 2( which is in my databank) =@123.com
When field 1 ending of emailadress contains something of field 2 -> Success, enters new View
Maybe I think too complicated, would be glad about help.
Page 1 / 1
Hi @Symp1236 ,
Create a new formula field and input a formula like this
FIND({Field 2},{Field 1})
You can filter only those that show 1.
IF function can be used to display strings.
IF(FIND({Field 2},{Field 1}),"TRUE",BLANK())
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.