Help

Re: Validating end-user input values

Solved
Jump to Solution
310 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Shmuel_Preiszle
4 - Data Explorer
4 - Data Explorer

I’m new to Airtable, and have been browsing the help center and playing around with the features. One thing I didn’t see mentioned anywhere was input validation. For instance, for a numeric field requiring the value to be less than, greater than, or between values-- as an age field which must be 21 or greater. Or a date field which must not be a future date. Or a currency field limited to 10000. An so on.
How would these be done in Airtable ?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Shmuel_Preiszler! :grinning_face_with_big_eyes: In-field validation isn’t currently available in Airtable. The only way to pseudo-validate inside of Airtable itself is to provide feedback in another field using a formula. However, this won’t work with forms because formula fields can’t appear in forms, and Airtable forms also don’t provide native validation options. Another option is to use a third-party form tool like JotForm, which can validate input before the data is sent to Airtable.

See Solution in Thread

3 Replies 3
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Shmuel_Preiszler! :grinning_face_with_big_eyes: In-field validation isn’t currently available in Airtable. The only way to pseudo-validate inside of Airtable itself is to provide feedback in another field using a formula. However, this won’t work with forms because formula fields can’t appear in forms, and Airtable forms also don’t provide native validation options. Another option is to use a third-party form tool like JotForm, which can validate input before the data is sent to Airtable.

Moe
10 - Mercury
10 - Mercury

We built an input validation solution in miniExtensions Form. You can set it to validate against another formula field in your table or even use Regex. Here's a condition example where 'Age' is required to be 21 or greater.

Screenshot 2023-05-12 at 8.36.35 PM.png

 
QuantumStep
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey @Shmuel_Preiszle ,

Airtable doesn’t have native input validation like setting limits for numbers or dates, but you can use the DataGuard extension for that. It lets you set rules like minimum/maximum values for numeric or date fields, so you can enforce things like an age of 21+ or restrict future dates.

It’s a good way to keep your data accurate from the start.