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.
May 20, 2020 09:33 AM
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?
May 20, 2020 10:19 AM - edited Dec 30, 2024 07:53 AM
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
May 21, 2020 11:14 PM
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.
May 16, 2023 04:25 PM
Had a slight workaround. But could be improved.
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
Oct 16, 2023 02:00 AM
How can an email field not be validated? That is so basic?!
Jan 19, 2024 06:48 PM
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.
Nov 08, 2024 01:30 PM
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.