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.
Jul 11, 2022 07:42 AM
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?
Jul 11, 2022 08:31 AM
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: