Form Validation - where can i find them?

[joshtech]

Hi Community,

I have created a form to let user fill in the fields. After some time I notice that there are some errors. The errors come from user..

1. Miss out an alphabet or a number of a SKU

2. Key in the wrong the wrong word.

3. Select the wrong date

I'm trying to find some ways to validate the input.

Is there anything that allows me to prompt user:

1. Prompt user to key the field when he/she forgot.

2. Remind the user set the date at X days after the initial date, if the user instead set it at any other days.

Thank you!

[ScottWorld · Accepted solution]

If you're using Airtable's native forms, you can only make fields required. And that’s it in terms of validation.

However, if you'd like to create a form for Airtable that has unlimited validation capabilities, you would need to use an advanced form tool like Fillout's advanced forms for Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to add advanced validations & limitations to your form fields, update Airtable records directly 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. 

There are also other form apps that offer validations as well, such as JotForm. JotForm offers some very basic integrations with Airtable, but if you need advanced integration between JotForm and Airtable, then you would want to use Make’s JotForm integrations to get your form submissions into Airtable.

Other form apps like Cognito Forms have advanced validation options as well, and again, you would use Make to get the information into Airtable.

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

[joshtech]

Hi Scoot,

Thanks for the recommendation. May I ask one more thing, not sure if its possible.

Can I have store a field correct input answer somewhere inside airtable, and whenever, user key in in that field,

airtable will "scan" the field to see if that data matches to the one stored in airtable?

So if it matches, proceed. If not, prompt user.

Thank you.

[CristianCG]

Hello Josh! 

Advanced field validations and comparisons are supported by our miniExtensions form. To achieve this behavior you can use the Save & Continue mode. This enables formulas to be calculated before the form is submitted, thus allowing you to perform extra validations.

You can activate this mode from the Save & Continue section:

For your use case, you could have a formula field that fills the correct key for new records. Wether you use a formula or configure the keys manually, to perform the validation, you can use another formula field with the IF() function, like this:

• IF({Input}={Key field},'Y','N')

Then, to prevent users from submitting the form if the key is not correct, you can add a condition to 'Enable saving records if conditions are met'. You'll find this option under the Disable Form section, where you can also add a custom message to help users understand why their form can't be submitted. Use a condition that verifies the result of the IF() formula:

With the Save & Continue mode, the user will see the 'Save Button' to compute the formulas before submitting the form, enabling or disabling the submission depending on the selected conditions: