Hi,
I have a table with a unique code.
I’m looking for a way to provide the public with a form where they can enter a code and check if it’s already been entered to the table or not.
How can I achieve this?
Thanks
Solved
Form with duplicates validating key field
Best answer by ScottWorld
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:
- 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
+35Your #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:
- 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
Thanks for the quick reply, appreciate it.
Is it possible to use MIniExtensions form as only a search form, without allowing data been entered to the system?
For example, I want people to search for the code and get a message only, saying it’s already registered or not. It shouldn’t enter any data to the table.
Do you think this is possible.
Thanks
+35Yes, that’s the behavior you get with Fillout. More details here:
- ScottWorld, Expert Airtable Consultant
+35You’re welcome! This should be extremely easy for you to setup on your own in just a few minutes of your time, but if you ever need to hire an expert Airtable consultant in the future, feel free to contact me through my website: Airtable consultant — ScottWorld
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.