Help with linked records / formula

[Dennis_Petrou]

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!

[Zack_S · Accepted solution]

Hey @Dennis_Petrou,

This is possible. You will need to set up an Automation.

1. Use the trigger - “When a form is submitted”
2. 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
   
3. 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!

[Dennis_Petrou]

Thanks so much, this should work!