
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 02, 2022 09:51 AM
Hello. This seems like it should be an easy solve but I cannot for the life of me figure it out.
I have a table in a base that automatically receives responses from a Typeform survey. It puts the email address (manually entered by person taking the survey) as the main record, and the responses follow in different columns.
There is another table in this base where the main record is an employee name, and then we have Department, and 3 columns of 3 different email addresses (there are potentially 3 different ones for each employee, or 2 or 3 can be the same).
I have linked the email base to the response base, and as the responses come in, I use a lookup to select the employee and pull in their department. I am trying to get this part to happen automatically.
So, when an entry comes in, if that email address matches any of the three emails in the other table, it will bring that employee name in.
Hopefully this makes sense and someone has a solution…
Thanks!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 02, 2022 01:36 PM
Hey @Dennis_Petrou,
This is possible. You will need to set up an Automation.
- Use the trigger - “When a form is submitted”
- The first action will be “Find records”
Table = The table that contains the list of emails for each user
Find records based on = condition
Each condition looks for the email submitted from the Form
- Second action “Update Record”
Table = Form Responses
Record ID = Record ID from the trigger
The linked field is the list of Airtable record ID’s from the Find records action.
Hopefully this makes sense!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 02, 2022 01:36 PM
Hey @Dennis_Petrou,
This is possible. You will need to set up an Automation.
- Use the trigger - “When a form is submitted”
- The first action will be “Find records”
Table = The table that contains the list of emails for each user
Find records based on = condition
Each condition looks for the email submitted from the Form
- Second action “Update Record”
Table = Form Responses
Record ID = Record ID from the trigger
The linked field is the list of Airtable record ID’s from the Find records action.
Hopefully this makes sense!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 06, 2022 10:50 AM
Thanks so much, this should work!
