I want to send an email to a person assigned to interview a candidate. The candidates are in one table and the interviewer with their email addresses are in another table in the same base. The trigger is when an interviewer is assigned (the field is changed to add the interviewer’s name).
What’s the best way to set up the automation to find that interviewer’s email address and just send an email to that person?
Welcome to the community, @Host_Israelis!
I’m assuming that the interviewer is assigned via a linked record field? If so, then you would just need to add a lookup field for the interviewer’s email address to bring it into that table.
You might greatly benefit from my free Airtable training course, which covers linked record fields & lookup fields in depth. You will become an Airtable expert in only 90 minutes! 
Welcome to the community, @Host_Israelis!
I’m assuming that the interviewer is assigned via a linked record field? If so, then you would just need to add a lookup field for the interviewer’s email address to bring it into that table.
You might greatly benefit from my free Airtable training course, which covers linked record fields & lookup fields in depth. You will become an Airtable expert in only 90 minutes!
Oh, right. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.