I have been tasked with developing a system for individuals to evaluate (with a rubric) a series of proposals related to a strategic plan coming in.
Individuals are submitting ideas using a Form that feeds into an AirTable Base (Base 1). We are doing this because we also want to visualize the ideas.
The idea is that once individuals submit their ideas, a group of people will be able to evaluate them using a scored rubric (Base 2). Initially, I figured I would create another Base and then Sync the Two Bases (One Way) While also adding a form that would input the scores into the New Base (Base 2). I would link them based on either the AirTable ID or the Title of the Proposal. I was then going to create a third base (Base 3) that scores and averages the results of the evaluation.
The challenge I am running into is that MULTIPLE people will complete the evaluation – up to 15. I am trying to think of a way to use AirTable for the scoring phase, but there need to be MULTIPLE people evaluating it using the same form.
Maybe create a system that creates a new row for each score and then manually average them? Or have them score in a different program and manually link things up?
Thoughts? Can this even be done?