Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Help with linked records / formula

Topic Labels: Formulas
Solved
Jump to Solution
194 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!

Thanks so much, this should work!