Find Duplicate Email

Hmm, I'm assuming the new record is being created in "Table 1" with that email value, and you want to make sure that's the only record with that email?

If so, try adding a conditional logic step checking the length of the result from your "Find Record" action, and if it's more than 1 (i.e. it's found more than one record), then you'll know that there's another record with the same email

What's the next step of your automation going to be?

Thanks or your reply 🙂

"Hmm, I'm assuming the new record is being created in "Table 1" with that email value, and you want to make sure that's the only record with that email?"

Exactly. I want that someone cannot send this request more than once on my website so don't allow the same e-mail twice.

I add the conditional logic step at the end of the automation but I'm not sure how the "length" parameter works.

I still have the same options to choose from on the condition. I choose:

If "Email" is "Email"

but it's still comparing the email of the record being created with that record and not old records that I already have on my database.

Next step it's just to add a string like "Duplicated email" on another column on that record.

Thanks

Roger that, thanks for the details

Yeah, you need to set up your automation to check whether the length's more than 1:

If it is, mark the checkbox

I've set it up for you here to experiment with

Thanks a lot for the reply.

Actually I found another way to compare because I have another table where I have a column with some of those email. So all good 🙂

Although I'm curious about the length property.

Does this means the number of character a value have?

What does the length propriety specifies?

Oh that makes a lot of sense.

Thanks a lot for the explanation 😊🙏

I didn't get it before because I thought was something like the "length" in characters of a string or number.

Anyway, much thanks again 😊😊