Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Allow for Field Validation

cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Andrew
8 - Airtable Astronomer
8 - Airtable Astronomer
Status: New Ideas
Please allow for field validation (esp. numbers).  If not in the base, then at least in the interface.  For example, we may wish to limit numbers in a field from 0 to 10. 

 

2 Comments
TheTimeSavingCo
18 - Pluto
18 - Pluto

Might wanna checkout Fillout.com for that; they let you do really custom validation via regex:
https://www.fillout.com/help/input-validation

ScottWorld
18 - Pluto
18 - Pluto

Hi @Michael_Andrew,

Totally agree with your post! We need validations built into Airtable’s data entry.

Fortunately, there are 2 ways to get some validations at the moment:

1. Airtable’s interface forms (which offers very weak and limited validations), or
2. Fillout’s advanced forms for Airtable (which offers very powerful validations).

Almost everybody chooses to use Fillout over Airtable, because Fillout is 100% free and the field validations in Fillout are *INFINITELY MORE ADVANCED* than the field validations in Airtable.

Even more impressive, Fillout lets you update existing Airtable records from a form, so you can validate fields AFTER the record has already been created.

The previous person who responded to your message above made it seem like you can only use RegEx in Fillout, but this is not true.

While Fillout does support RegEx, RegEx is extremely complicated and most people don’t enjoy using it.

The great news is that Fillout supports normal conditions for validations, just like you would specify filter conditions in Airtable.

Please see my screenshot below for an example of how simple it is in Fillout to automatically limit a number field to a range between 1 and 10.

Additionally, Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

IMG_0460.jpeg