Data Validator
Make sure new records only contain validated data.
Data Validator lets you quickly create accurate records with easy-to-set required fields, default values, and validation for emails, phone numbers, and URLs, along with maximum and minimum values for nearly every Airtable field type.
Users without a paid plan can create a fixed number of records every month. To create an unlimited number of records monthly, you can purchase a license at https://internaltools.gumroad.com/l/hdhdq.
Validation Types
Single Line Text Field
• Required
• Minimum required length
• Maximum allowed length
• Default value
Long Text Field
• Required
• Minimum required length
• Maximum allowed length
• Default value
Checkbox Field
• Default Value
Collaborator Field
• Required
• Maximum number of selections
• Default value
Date Field
• Required
• Earliest date
• Latest date
• Default date
Datetime Field
• Required
• Earliest datetime
• Latest datetime
• Default datetime
Phone Number Field
• Required
• Is valid phone number
• Default phone number
• Default country
Email Field
• Required
• Is valid email address
• Default email
URL Field
• Required
• Is valid URL
• Default URL
Number Field
• Required
• Minimum value
• Maximum value
• Default value
Currency Field
• Required
• Minimum value
• Maximum value
• Default value
Percent Field
• Required
• Minimum value
• Maximum value
• Default value
Duration Field
• Required
• Minimum duration
• Maximum duration
• Default duration
Rating Field
• Required
• Default rating