Skip to main content

Filtering just for a variable Email ending

  • July 24, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+1

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

Forum|alt.badge.img+19
  • Inspiring
  • 560 replies
  • July 25, 2023

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