Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Re: Form: Email input validation

4626 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Hirday_Gupta
4 - Data Explorer
4 - Data Explorer

Email fields in forms don’t seem to be validated very strongly. My form keeps accepting entries like “name. lastname@host.com” (notice the space).

How do I prevent the form from accepting badly formatted emails like this?

6 Replies 6
ScottWorld
18 - Pluto
18 - Pluto

You can perform email validation (and other types of validation) with Fillout's advanced forms for Airtable, which is an advanced form app for Airtable.

Fillout is 100% free, and it offers hundreds of advanced features that are not available with Airtable's native forms. Fillout gives tons of validation options that are all Airtable-specific.

It even gives you multiple options for validating email addresses, including the ability to verify email addresses in a number of different ways, including sending an email verification code to the user. And they have many other ways of validating email addresses as well, such as automatically "pinging" the email address to ensure that it is valid.

Fillout also offers hundreds of other features that aren't natively available in Airtable's forms, such as the ability to update Airtable records with a form.

I gave a very brief demo of Fillout on this episode of the BuiltOnAir podcast.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

They’re currently not validated at all. If validation is important, I second the suggestion from @ScottWorld to consider using a third-party form tool like TypeForm or JotForm. There are probably more, but those two come to mind right away, and both support email validation. JotForm also has a built-in option to connect to Airtable for form submission, and this is available in the free JotForm account. TypeForm has a similar feature, but it requires their lowest paid tier.

Had a slight workaround. But could be improved.

  1. Create a "single select" field displayed as a list with no options. (Basically a text box in your form)
  2. Configure the field in your form:
    Conditions if "Email" field does not contain "@" or "." & if field contains a " " (space)
    Make the field "required"
  3. You can add text saying something like "Error. Please check that your email address is entered correctly"

It's not the best workaround. If I could somehow implement ALL these conditions in

Email address

What makes it invalid

@domainsample.com

The recipient's name is missing.

johndoedomainsample.com

The @ symbol is missing between johndoe and domainsample.com.

john.doe@.net

The domain name (domainsample) is missing after the @ symbol and before the top level domain (.net).

john.doe43@domainsample

The top level domain (.co.uk) is missing.

Taken from validity.com


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

How can an email field not be validated? That is so basic?!

Agreed, I'm going to put in a feature request. I was surprised to find that this was not automatically when putting an email field on a form.

HannesK-ME
7 - App Architect
7 - App Architect

Hey there, I just wanted to point out that validating email addresses is very straightforward using our miniExtensions Form. Right out of the box email fields are validated to check for a valid format. Alternatively, you could also set up RegEx validation in a single line text field, for example, which can achieve the same result with more flexibility. ChatGPT is really good at creating the correct RegEx if you just describe the format that you require.

Screenshot 2024-11-08 at 14.30.15.jpg