How to lookup from a form

[Kari_Clark]

I would love your help! I basically have a form where people need to input their email address. I have all these users in a user table already, and would love to set up an automatic lookup that would match people’s answers to the right user.

Any ideas?

[Justin_Barrett]

Welcome to the community, @Kari_Clark! :grinning_face_with_big_eyes: Airtable’s native forms aren’t robust enough to do this. It would be possible to make the connection using a script (either manually run, or automatically via the scripting action beta) after the data has been added to Airtable, but not live while the form is being filled out. To make that kind of live connection, you might touch base with Dan at @openside to see if his On2Air Forms tool (which uses JotForm) has that capability.

[ScottWorld]

As @Justin_Barrett mentioned, On2Air Forms + JotForm is a great solution for this.

Also, @Moe has created multiple different form extensions that might help you as well. Here are 2 of them, but there are many other ones on his site as well:

miniExtensions

Update Existing Records with Airtable Forms - miniExtensions

This tool uses Airtable's native form and allows users to see existing data before editing. It doesn't require setting up a mirror table nor using Zapier.

miniExtensions

Conditional Redirect After Record Lookup - miniExtensions

Let people update their profiles or ask them to signup if they're new. This tool checks if a record exists or not and redirects the user based on that result