Is there a way to automatically link responses that come in from an airtable form, to a database that already exists?
In my use case, we have a database of customers and their information (including their email address) on Airtable. I would like to send them all an Airtable form to complete. If they also supply their email address in this form, would it be able to automatically link to their record on the database without me going in and linking each one individually?
So an automation in the form table, checking whether this email address exists in the database and then automatically linked to their customer record in the database if it does?
Hopefully this makes sense!