Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Help with linked records / formula

Solved
Jump to Solution
1156 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dennis_Petrou
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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
    image
  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.
    image

Hopefully this makes sense!

See Solution in Thread

2 Replies 2
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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
    image
  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.
    image

Hopefully this makes sense!

Dennis_Petrou
7 - App Architect
7 - App Architect

Thanks so much, this should work!