Skip to main content

Hi all,

 

Is it possible to prevent the creation of record under certain condition during form submission?

Like upon button click, there will be a check against the database for certain condition and throw back error message. 

Airtable’s forms can’t typically prevent somebody from submitting a form unless they make a simple mistake like leaving a required field blank.

For more advanced control over whether somebody can submit a form or not, you would need to do that with Fillout’s advanced forms for Airtable.

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to:

  • Conditionally show or hide the form’s submit button if certain logic isn’t met on your form,
  • Show an error message onscreen if certain logic isn’t met on your form.
  • Check for duplicate records in your Airtable base and prevent a duplicate submission from being submitted.
  • Pre-fetch a record from Airtable and compare the form submission’s data to the pre-fetched record’s data, and then you can prevent the submission (and/or show an error message) if it doesn’t meet the criteria you’re looking for.
  • If you have a linked record field on your form, you can then show or hide Airtable lookup fields on your form, and prevent submission (and/or show error messages) based on comparing the form data to those lookup fields
  • And much more.

I don’t specifically show how to prevent a form from being submitted in the 2 videos below, but I do show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey ​@Egkk,

Fully agree with Scott above. You can read more about Fillout vs. Airtable Native forms here.

Also, please feel free to submit this as a product ida/feature request. I’d love to see Airtable level up their game when it comes to forms!

Mike, Consultant @ Automatic Nation 

In Airtable forms, once the user hits Submit, a record is always created — there’s no logic or validation available beyond setting required fields.

Instead, try using Fillout. After form submission, you can set up workflows with conditions, such as approval steps, webhooks, or other actions.

I'd love to know more about your use case. What exactly are you trying to achieve?

Taha, Airtable Advisor

Reply


Terms & Conditions