Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to check for errors in forms before they can be submitted ?

Solved
Jump to Solution
1392 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Soly
7 - App Architect
7 - App Architect

Hello, 

On an airtable registration form that has a required field for DOB, some users have made error on their years of birth (for example 2023 instead of 2003) . Then they submit it and it fills the table with wrong data without them being aware of it. 

Is there a way that I can set the minimum date of birth to 01/01/2007 for example, so that the forms can alert the user that the date is incorrect at the time of form submission ? 

If not, which other way is possible ?

1 Solution

Accepted Solutions
siliceous
6 - Interface Innovator
6 - Interface Innovator

Hi @Soly,

It isn't possible to set this up right now within the Airtable form.

If notifying the user post-submission is ok, you can:

1. Set up a formula field to detect if the information entered in the date field is wrong, or

2. Use filters in a view to filter by dates earlier than the minmum date,

and trigger an automation to send an email to the user to update their form submission if the date entered is before the minimum date.

In the email, you could include a link to a form to update their submission according to this thread comment - https://community.airtable.com/t5/other-questions/editing-existing-airtable-form-submission/m-p/1440...

See Solution in Thread

2 Replies 2
siliceous
6 - Interface Innovator
6 - Interface Innovator

Hi @Soly,

It isn't possible to set this up right now within the Airtable form.

If notifying the user post-submission is ok, you can:

1. Set up a formula field to detect if the information entered in the date field is wrong, or

2. Use filters in a view to filter by dates earlier than the minmum date,

and trigger an automation to send an email to the user to update their form submission if the date entered is before the minimum date.

In the email, you could include a link to a form to update their submission according to this thread comment - https://community.airtable.com/t5/other-questions/editing-existing-airtable-form-submission/m-p/1440...

Soly
7 - App Architect
7 - App Architect

Hi @siliceous ,

Awesome, since it is not possible I will go with the formula + trigger method you have shared then, as I have another formula field that calculates ages based on DOB. That way it can trigger an email automation if the age is lower than the minimum age. 

Thanks for your support 🚀