Designing A Judging System for Science Fair

Topic Labels: Base design
379 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi Everyone! 

I'm trying to design a judging system for a science fair styled event but I'm wondering if there's an easy way to do the judging assignment through airtable or if I can do it through Excel then transfer to airtable. 

Right now I have three tables: 

1. Judges (All the judges are named and given a unique number) 

2. Projects (Each team & their assigned table) 

3. Scoring (A grid + form view where each judge can select their name + the team they're assessing through the form - I use linked records to group the teams and get final score). 

Is there a way you would recommend assigning each team 3 judges with team receiving any one judge more than once. Maybe there's some trick by using a number to represent each judge and the random formula... Would love any ideas. 

0 Replies 0