Form with duplicates validating key field

[Charith_J_Abeyw]

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

[ScottWorld · Accepted solution]

Welcome to the community, @Charith_J_Abeywickra!

That is not possible with the native Airtable form, but you can do that by paying for the MIniExtensions form:

miniExtensions for Airtable

Prevent Duplicate Airtable Records in miniExtensions Form

Optional settings to require a unique field value. If the entry is valid, the record will be created/updated. If it's invalid, the user will get an error.

[Charith_J_Abeyw]

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

[ScottWorld]

Yes, that is one of the features of MiniExtensions:

miniExtensions for Airtable

Search Page for Airtable - miniExtensions for Airtable

Allow people to search your Airtable base. Decide which fields can be searched and which fields are shown in search results.

[Charith_J_Abeyw]

Thanks a lot, really appreciate your help.

[ScottWorld]

You’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:

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable Consulting,...

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable...

ScottWorld provides the world's best Airtable consultants, Airtable experts, Airtable developers, FileMaker consultants, and Airtable trainers. Airtable consulting, FileMaker development, and Airtable training.