Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Special help needed with form building!

Topic Labels: Base design
209 1
Showing results for 
Search instead for 
Did you mean: 

Hey everyone, I’m new to Airtable.

I’m looking to create a form for an event. Each customer at the event will be given a unique card ID number. We’d like them to enter in their details (including the ID number) into a form.

How do I create a form whereby if someone enters in ID number 0001, no one else can enter in 0001?

1 Reply 1

You can’t limit entries to be unique unless you use a linked record field trick, where they choose from a pre-existing list of records that you have already populated in another table, and then the list can get smaller & smaller as people submit records.

A better, easier, simpler option would be to use JotForm, which lets you set a “unique question” which would requires unique answers for a specific field: