Skip to main content

I have created a form to create new Project records. Each project requires a unique ID which matches a particular format (XXXX-000).

How can I make sure that no-one uses an existing unique ID when filling out the form? I really need to avoid duplicate Projects, as creating a new Project has a lot of downstream actions which can get messed up if an ID already exists.

I have another form which can create new versions of an existing Project, which I can use as a redirect URL if necessary.

Many thanks in advance!

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:

  1. Use Airtable's DeDupe extension to manually merge duplicate records together.
  2. Use Airtable’s automations to automatically find & flag duplicate records.
  3. Use this Airtable trick that I demonstrate on this Airtable podcast episode: https://www.youtube.com/watch?v=Xc-0Jp6AvAs&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1
  4. Use a script to automatically merge or delete duplicate records.
  5. 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.
  6. 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 submissionsupdate Airtable records using a formcreate custom PDF files from a form submissionaccept 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