- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Hi, I discovered Airtable just a few weeks ago and instantly fell in love with this application. Itโs so cool! I am still new to it, but Iโm learning so much.
However, as a former Access user, Iโm surprised it doesnโt feature almost any advanced rules for data input and validation in fields. Iโm even more surprised that so very few people are asking for them.
Data validation is important. For a solid database, itโs a core feature. Say I want to record a customerโs IBAN for money transfers. An IBAN always has exactly 27 characters; itโs not all right if someone by mistake inputs 25 or 28 characters or puts spaces into it. I need to set the IBAN fieldโs lenght to 27 characters and request that you fill out those 27 characters, not one less, not one more!
Same goes for zip/postal codes, or tax codes. Validation rules are needed for such fields. A lot of stuff can get messed up if this kind of data is not recorded correctly, such as payments, shipments, fees. Itโs a serious matter!
Phone numbers and email fields should be validated, too, because they should not accept invalid characters.
I should be able to set Date fields to accept only certain ranges of data. Such as: โyou cannot input a delivery date that is before todayโ.
I canโt even find such a thing as setting a field to โrequiredโ.
Even though the application is fantastic, these shortcomings are a major kickback for Airtable. Please consider introducing these features, Iโm sure many users will be grateful!
As I said, I am new to the application so pardon me if Iโve said something wrong or I missed out on issues that have already been addressed.
Love ๏ธ