How to lookup from a form

Topic Labels: Base design
2819 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2

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.

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: