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.
Solved
How to restrict email input value to addresses that end in ".edu" ?
+3Best answer by ScottWorld
This is not available in Airtable, but this is possible with Fillout’s advanced forms for Airtable.
Fillout lets you validate an email address by condition or by using a RegEx expression or even by requiring a login to certain domains that you specify!
You can even create a login page that only allows people to use your form if their email exists in your Airtable base… or if they successfully login via SSO… or much more.
Many of these features are 100% free, and Fillout also offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+31Hmm, 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"?
+35This is not available in Airtable, but this is possible with Fillout’s advanced forms for Airtable.
Fillout lets you validate an email address by condition or by using a RegEx expression or even by requiring a login to certain domains that you specify!
You can even create a login page that only allows people to use your form if their email exists in your Airtable base… or if they successfully login via SSO… or much more.
Many of these features are 100% free, and Fillout also offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+13Hey 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! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.