An app to share interviewer feedback on potential job candidates.
How we built this appWe built this app using two spreadsheets: a Feedback table and a Candidates table. 1. We added two tables to the app using the Advanced Editor > Data > Tables > +Table. You’ll notice there are tiny “chain” icons next to each candidate name-- that’s because we created a reference (Ref) from the Candidates field in the Feedback table to the Candidates table. You can see this in Advanced Editor > Data > Column Structure. When clicking on the chain icon, we’re taken to a view that shows all the information about that candidate: information contained in the Candidates table we’re referencing from the Feedback view. 2. We also created a Candidates view to easily view data about each potential hire. When clicking into a candidate, you’ll notice at the bottom a “View” button-- that’s the Ref at work (a reverse ref in this case). That will take you back to all of the feedback given by the employees that submitted it. 3. The form inside the Feedback view allows employees to record their opinions about the candidates quickly and easily. Notice for many of the questions we chose a Yes/No field type-- this enables interviewers to rapidly answer yes or no questions without having to manually type in “Yes” and “No”.