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?