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.
Hey Kiera, totally get where you’re coming from. Airtable’s lack of form validation is a big adjustment, especially when you’re used toGoogle Formsenforcing strict formatting.
You might want to try theDataGuardextension—it lets you set up rules so fields can follow specific formats, like usingregex patternsfor phone numbers, emails, or other structured data. You can also mark fields asrequiredand set limits on values or lengths, so users can’t submit incorrect info in the first place.
Hey there! I just wanted to add that ourminiExtensions 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!
