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?
