Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Validating end-user input values

Solved
Jump to Solution
3192 3
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.