I want to send different people emails containing a link to a form that they can only submit once. Once submitted, if they click the form link to the form again, they wouldn’t be able to do another submission. How do I do this? Ideally, the form would be tied to a record in airtable, and if the status column of the record is no longer “new” and transitioned to “progress” or “finished”, the form would no longer work.
Page 1 / 1
You could use this system + let one of the automations control (is it empty?) and add (the first time they fill in the form) a checkmark to an extra field.
We are experiencing the same issue. We have a prefilled form that we send to users for approval, but some users are submitting the same approval multiple times. We have an automation in place to check if they’ve already submitted the form, but they’re still able to resubmit it. Is there a way to restrict access so that, upon a second attempt, users see a message like "Form already submitted"?
Hi there!
You can easily do this using miniExtensions. We've built a third-party form that offers various flexible options to get more out of Airtable, including several ways to control or disable form submissions. These include allowing users to create only one record, setting a scheduled date to disable submissions, and restricting submissions based on specific conditions.
My favorite way of creating a single-use restriction for forms is to use Fillout’s advanced forms for Airtable.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to create a login page that restricts the form to single-use logins.
Their login page also gives you lots of other advanced options as well, such as limiting logins to SSO sign-ins, or limiting logins to only the email addresses that you specify in an Airtable table.
There are many other advanced features as well, such as the ability to update Airtable records using a form, create new linked records on a form, display Airtable lookup fields on a form and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.