Search and Fill

[Ben_H]

Hello Everyone,

I think this should be fairly simple. I have two tables. Customers (auto populated when an order is made) and the Quiz Results (auto populated when a quiz is taken on the website.)

I would be simple to link records and look up the appropriate data.

We want it all to be automated though.
The email address is most likely to match can I search(email) to link records then look up the fields.

Thanks in advance @Mohamed_Swellam @Justin_Barrett

BH

[Ben_H]

The problem is that Zapier is asking for a specific record id to be updated. So the search function won’t integrate. Any ideas?

[Justin_Barrett]

I wrote an automation script recently for another user that feels like it might be adaptable to your situation. It sounds like a similar use case (matching emails between tables and auto-linking the records). Here’s the thread. Let me know if you have any questions.

Pulling Name on a separate table from Email Base design

Fairly new to AirTable. I currently am trying to build two surveys for my org’s membership. My goal is to automatically link the records in Survey2 (Email, Organization, Role…) to Survey1 (Name, Email, Age…), but I don’t want users to be able to see the names of everyone who has submitted a response to Survey1. Is there a way to have them input their emails in Survey2, and then to automate AirTable to look up the record associated with that email in the table for Survey1, and update the name fi…