How to restrict email input value to addresses that end in ".edu" ?

[Addie_Dunham]

We are setting up a form that will be filled out by campus staff at many different colleges/universities, so there is no one @ domain. We want to ensure that no one submits a non-campus email address, however, so we want to make sure that regardless of the rest of the domain, it ends in .edu. Is there a way to do that ? They won't be logging in or anything, I just need the form to reject anything that ends in .com, etc.

[TheTimeSavingCo]

Hmm, there's no native functionality for this I'm afraid.  As a workaround, what if we used the conditional visibility of the fields to prevent users from proceeding unless the email field contained ".edu"? 

 

[ScottWorld · Accepted solution]

@Addie_Dunham 

This is not available in Airtable, but this is possible with Fillout’s advanced forms for Airtable. You can validate an email address by condition or by using a RegEx expression or even by requiring a login to certain domains that you specify!

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.

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 

[HannesK-ME]

Hey there! I just wanted to add that our miniExtensions form allows for validation of input fields. For your use case you could simply use a "contains" condition (or a combination of several of them using "or" logic). Alternatively, you could also ask ChatGPT to come up with an appropriate regEx. Using regEx, you can force the input to be in any specific format you need, but for this use case "normal" conditions should be sufficient.

Using this in the miniExtensions form is super easy. You just set up your field and add the relevant condition to the field's validation settings! The form will then only accept submissions with valid values according to the validation conditions you have provided and show an error if the condition is not met!

You can try this out now by creating a free account! 🙂