Check in a table before letting the user submit the form

[Eric_Pinar]

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?

[ScottWorld]

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

That is not possible with Airtable’s forms. You would need to use the duplicate prevention feature of JotForm:

Jotform

How to set Form Limits Based on a Unique Question

Let's suppose you are running a contest and would like to limit unique entries or values in a form. For example, you might want to...