Email Validation

[Oscar Obians]

Hi, I recently started using FormEmailer and I must say it is extremely powerful and well thought out. Kudos to the genius developer Henrique Abreu. You deserve a cookie ;)

I've been able to set it up to send form results to specific emails (already listed in the spreadsheet) based on certain multiple-choice answers. So the user doesn't have to type the emails themselves. But the problem is with the only field where the user has to type in their own email address. It all works perfectly if the user types in their email correctly... Until a certain user mistypes their email address. The other back-end emails receive notifications and results as usual except the mistyped email address - which is fine. 

But is there a way to validate or verify the user's email from the form?

[Henrique Abreu]

You could try to write a spreadsheet formula like RegexMatch to check if the field looks like an email, but, officially, there's no silver-bullet way to check if an email-address is valid else from trying to send an email to it. Here's some links with discussions:

http://stackoverflow.com/questions/201323/using-a-regular-expression-to-validate-an-email-address

http://www.regular-expressions.info/email.html

Thanks for the cookie ;-)

Henrique G. Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer+unsubscribe@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Oscar Obians]

I see... I thought as much. Thanks a lot

On Monday, January 30, 2017 at 6:19:03 PM UTC+5:30, Henrique Abreu wrote:

You could try to write a spreadsheet formula like RegexMatch to check if the field looks like an email, but, officially, there's no silver-bullet way to check if an email-address is valid else from trying to send an email to it. Here's some links with discussions:

http://stackoverflow.com/questions/201323/using-a-regular-expression-to-validate-an-email-address

http://www.regular-expressions.info/email.html

Thanks for the cookie ;-)

Henrique G. Abreu

On Sat, Jan 21, 2017 at 4:02 PM, Oscar Obians via FormEmailer <formemailer+APn2wQddibWujhG60XUbdaFRw5R1f3McigcO-GEtASFyvSBvuRUQ@googlegroups.com> wrote:

Hi, I recently started using FormEmailer and I must say it is extremely powerful and well thought out. Kudos to the genius developer Henrique Abreu. You deserve a cookie ;)

I've been able to set it up to send form results to specific emails (already listed in the spreadsheet) based on certain multiple-choice answers. So the user doesn't have to type the emails themselves. But the problem is with the only field where the user has to type in their own email address. It all works perfectly if the user types in their email correctly... Until a certain user mistypes their email address. The other back-end emails receive notifications and results as usual except the mistyped email address - which is fine. 

But is there a way to validate or verify the user's email from the form?

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.

To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.