You are viewing limited content. For full access, please sign in.

Question

Question

Validating Fields inside Collection

Forms
Updated December 5, 2024
asked on December 5, 2024

How can I check if email entered in a field inside of a collection is same as another email field that is outside the collection?

0 0

Answer

APPROVED ANSWER
replied on December 5, 2024

Hi Priya,

You can do this using a calculation with a if statement.

Ex. =IF(INDEX(Collection.E_mail,ROW())=E_mail,"MATCH","NO MATCH")

On my test form I have:

Add the calculation to the email address in the collection and update the variable names.

Good Luck!

1 0

Replies

replied on December 5, 2024

Thanks. In my case, they enter the collection emails first and the email outside the collection is entered at the end.

0 0
replied on December 5, 2024 • Show version history

Gotcha.

So then you could:

1. move the email outside the collection to the bottom

Like so:

2. change the calculation to:

=IF(E_mail="","",IF(INDEX(Collection.E_mail,ROW())=E_mail,"MATCH","NO MATCH"))

Looking like:

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...