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?

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:

1 Like