Check in a table before letting the user submit the form

Hello,
I would like to make a form that will check in a table before letting the user submit the form.

The use case:

I have a list of coupon code that exists with a status field
I send by email the coupon code to the user
The user submits the form and the status field changes from notused to used.
This is not automation because I don’t want the user to be able to submit the form if I understand correctly.

How do I do this? I have the impression that this is not possible with airtable form, another tool I can use with airtable or a link please?

Page 1 / 1

Are you trying to prevent people from submitting a duplicate coupon code before pressing submit?

That is not possible with Airtable’s forms, but your #1 best bet for this is to use Fillout’s advanced forms for Airtable because it communicates directly with Airtable and it lets you prevent duplicate form submissions based on any text fields (or email fields) that you specify.

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to prevent duplicate form submissions, update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I 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

Sign up