Data validation


#22

+1 for data validation!


#23

I am evaluating Airtable for a project at my company and just discovered that it has no field validation on forms (or elsewhere). Without field validation, any form or database software is unusable if the quality if the data being input is important (when is it not important?).


#24

+100 for data validation (please, please, please)


#25

I was completely bamboozled when i discovered that airtable does not validate form data! especially the primitives like email and url!

it even makes it sound like it does when you click “customise field type”

Absolutely ridiculous! I could write these in a few minutes using redux forms.

In this example it is using a very standard regex for emails:

const email = value =>
  value && !/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$/i.test(value) ?
  'Invalid email address' : undefined

If you don’t understand js es2015 dont worry - this is basically saying:

variable email = the result of a function that takes "value" as input 
tests it is not 'null' && then tests that it passes the regex (!/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$/i). 
if it fails the function returns 'Invalid email address' 
if it passes it returns undefined 
(which makes sence when we are talking about validation errors
ie it passing means that there are no/undefined number of validation errors)

Now if I can write that into a comment in a couple of minutes and explain it in english for any airtable user to understand there is absolutely no reason why the product owners at Airtable cant prioritise this as a quick feature in the next sprint #strongsuggestion


#26

Is there any way to accomplish field validation in Airtable?! This seems like a basic feature for a database.


#28

How do I set up data validation on airtable fields? (Has this issue been addressed yet?)

Also, a more basic version of this question:

Why are email address not being validated in the form view, if you specifically select the “email” field. How do I validate email addresses?

Thanks.


#29

That standard regex is neither standard, nor will it work very well, as it accepts lots of invalid addresses while rejectings valid domains (TLDs have not been limited to 4 letters for what feels like ages, for one; even before vanity TLDs, the limit was 6). Before anybody starts copying this for, I dont know, whatever, please do read How to Find or Validate an Email Address.

Don’t get me wrong; I would love to see data validation in Airtable, but it is a highly complex topic and getting it right even for seemingly simple use cases is hard (see date parsing libraries et al); let’s cut Airtable some slack here.


#30

… and to expand on the other issue at stake here, i.e. user defined validation of data, while a feature I’d dearly love, I suspect the conumdrum ist that Airtable can either

  1. allow validation through its formula language only, which, barring a serious expansion / overhaul of the formula system, would probably be considered too primitive and coarse grained for many purposes (there isn’t even a regular expression match available, never mind real array searches), or

  2. set up a whole language runtime on top of the current Airtable stack to allow for fully programmable validations (e.g. in JavaScript), which opens a can of worms when it comes to security and performance.


#31

Realize that this is a hard feature to implement (for all reasons summarized above). Would still love to see it if possible. After all, a lot of what Airtable does already was hard, and that’s part of why we love it - plenty of inadequate competition handled the easy challenges well.

+1 to this request