I am building a simple recruiting database in AirTable.
Here are the tables that I have
Candidates - (names, all information, name of recruiter linked to Recruiter table)
Recruiters - Name, Email
Position - Position, company, salary, etc.
Submission - This is where a candidate is linked to a position.
Link to Candidate Name, Link to Position. I also have the Recruiter Name here though Lookup.
How can I display recruiter’s email so it can be included in email automation?