I switched from Airtable from Google Sheets/Forms a while ago and while I love it, I am really missing having the data validation features of Google Forms. I have a lot of forms that have very specific formatting for how data needs to be entered and it would be great to force my users to enter it correctly instead of expecting them to follow the help text, because they don’t.
Yeah, the forms in Airtable are extremely basic. But you could still use Google Forms to collect your data, and then have the information automatically sent into Airtable afterwards.
Unfortunately I use the linked records feature extensively so I need the Airtable forms for now
Hey Kiera, totally get where you’re coming from. Airtable’s lack of form validation is a big adjustment, especially when you’re used to Google Forms enforcing strict formatting.
You might want to try the DataGuard extension—it lets you set up rules so fields can follow specific formats, like using regex patterns for phone numbers, emails, or other structured data. You can also mark fields as required and set limits on values or lengths, so users can’t submit incorrect info in the first place.
Might help you get that form control back!
Hey there! I just wanted to add that our miniExtensions form allows for regEx (and more conventional conditions) validation of input fields. ChatGPT is really good at generating regEx these days, so you don't really have to know much about it. Just describe your desired format and maybe have it tweak the results a couple of times to get the desired functionality. Using regEx, you can force the input to be in any specific format you need!
Using this in the miniExtensions form is super easy. You just set up your field and add the "matches regex" condition to the field's validation settings! The form will then only accept submissions with valid values according to the regex that's provided and show an error if it the condition is not met!
You can try this out now by creating a free account! 🙂
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.