Context: Trying to build a document to capture interview candidate feedback
- candidate table has candidate contact details etc.
- candidate_evaluation_criteria has 25 rows of data on various aspects on which we’d like to evaluate the candidate.
Both tables have a common column called team’ the team that is hiring for the role and the team the candidate application is assign to.
I am trying to get the following equivalent SQL output in a tabular format in Coda
Select candidate_evaluation_criteria.*, new columns to capture evaluation
Where candidate.name = “Interviewee_Name” (Coming from an interactive filter)
And candidate.Team = candidate_evaluation_criteria.team
Basically, when we are trying to interview someone, we’d like to select an interviewee name and the fields to capture evaluation should be created automatically.
Anyone with suggestions for me?