I'm afraid that's not available natively with Airtable forms. Fillout has this functionality though and it integrates directly with Airtable: https://www.fillout.com/help/prevent-duplicate-submissions
Thanks Adam. That's unfortunate. The organisation I'm helping won't stretch to another $75/month just for that functionality. I'll have a re-think on my approach.
Thanks Adam. That's unfortunate. The organisation I'm helping won't stretch to another $75/month just for that functionality. I'll have a re-think on my approach.
Oof, yeah fair enough. Maybe you could set up a system that detects duplicates and then emails the creator and tells them to fix it?
I'm curious why you need the most expensive plan for Fillout as well actually; you're expecting more than 5000 form submissions a month?
Oof, yeah fair enough. Maybe you could set up a system that detects duplicates and then emails the creator and tells them to fix it?
I'm curious why you need the most expensive plan for Fillout as well actually; you're expecting more than 5000 form submissions a month?
Oh - the link you sent above says that feature is available on Business plans and above - which start at $75.
I found a dodgy, but workable workaround. Thanks though.
Oh - the link you sent above says that feature is available on Business plans and above - which start at $75.
I found a dodgy, but workable workaround. Thanks though.
Oh woah, so sorry, I thought that just came with the free plan, my apologies!
As mentioned above, the best way of solving this problem is to use Fillout’s advanced forms for Airtable because it lets you prevent duplicate form submissions based on any text fields (or email fields) that you specify.
However, if your duplicate records are ALREADY in Airtable, you can cleanup the duplicates afterwards through one of these methods:
- Use Airtable's DeDupe extension to manually merge duplicate records together.
- Use Airtable’s automations to automatically find & flag duplicate records.
- Use this Airtable trick that I demonstrate on this Airtable podcast episode: https://www.youtube.com/watch?v=Xc-0Jp6AvAs&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1
- Use a script to automatically merge or delete duplicate records.
- Use Make’s Airtable integrations to automatically find & flag (or find & delete) duplicate records. If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
- You could even collect new records in a secondary table, and then use an Airtable automation to determine whether the new record should be added into the main table where you don’t want the duplicates to appear.
Although it is typically best to prevent the duplicates from ever being created in the first place, which is why it’s recommended to use Fillout’s “prevent duplicate submissions” feature.
Fillout also offers hundreds of other 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:
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld