Help

Re: Filtering just for a variable Email ending

636 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Symp1236
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
Sho
11 - Venus
11 - Venus

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())