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.