Jun 06, 2019 12:03 AM
I am trying to create a scoring system using Airtable where judges can score a team (with the different metrics in columns).
What I have done:
What I need help with:
However, I want to create a new table which gives a summary of the overall score for each team for each judge (i.e. looking across a particular record, I will be able to see the overall score for judges A, B and C). And I want this table to be updated AUTOMATICALLY whenever each judge finish scoring the team.
What I have achieved thus far is using linked tables and lookup function. However, this is very inefficient as I have to manually choose which the team (or record) to be linked manually before I can lookup the overall score. Moreover, I have to do this N times for N number of judges (since each judge has his/her own table).
Is there a way to automatically update the overall score column for the respective judge each time they complete scoring a particular team? Cheers!
Solved! Go to Solution.
Jun 06, 2019 01:14 AM
Hi @Jason_Tay - I would recommend a different base structure to the one you have as the problem with it is that you need to explicitly make links (manually) to get another table to sum or group records.
I recommend something more like this:
A teams table:
A judges table:
And a scores table which links teams and judges:
You can see the total for each team/judge and with a grouped view you can see the score for each team for all judges:
Appreciate you’ve already integrated your external software into a specific base config, but this set-up gives you the updated totals without having to make any manual links, so might be worth looking at. Generally speaking, when I’ve got multiple “things” of the same type (judges in this case), I would tend to put them in the same table if I can.
Hope this helps!
JB
Jun 06, 2019 01:14 AM
Hi @Jason_Tay - I would recommend a different base structure to the one you have as the problem with it is that you need to explicitly make links (manually) to get another table to sum or group records.
I recommend something more like this:
A teams table:
A judges table:
And a scores table which links teams and judges:
You can see the total for each team/judge and with a grouped view you can see the score for each team for all judges:
Appreciate you’ve already integrated your external software into a specific base config, but this set-up gives you the updated totals without having to make any manual links, so might be worth looking at. Generally speaking, when I’ve got multiple “things” of the same type (judges in this case), I would tend to put them in the same table if I can.
Hope this helps!
JB
Jun 06, 2019 01:22 AM
Appreciate this alot! Definitely helps but I have 2 questions when using this structure:
I guess I have to manually name the teams with a suffix -Judge X? (Or any recommended efficient way of doing this will help!)
is the “Team” and “Judge” column populated automatically or has to be entered manually? This is not a very big issue but just checking.
Thanks again
Jun 06, 2019 01:35 AM
Hi Jason
Team & '-' & Judge
Here’s a link to my mockup:
Copy it into your workspace to see the underlying field settings.
JB
Apr 03, 2020 04:11 PM
I’m thinking this solution is similar to what I would need for abstract scoring - multiple presentation proposals scored by several people. But I can’t see quite how to get the “team” or abstract item to copy down beyond team 1.
Jan 03, 2022 07:00 PM
@JonathanBowen - would you mind sharing this “Score” base again? Also wondering if in this scenario it is possible to also have answers that are being scored linked so that the judge has a unified view instead of juggling multiple Airtable tabs (looking back and forth between answer and score)?..ie: Team 1 > Answers 1 a,b,c > Score 1 >Judge A.
Jan 04, 2022 01:21 AM
Hi @Kitara_Samuel - I don’t have that base any more I’m afraid (did a clear out a while back as my workspaces were getting too messy), but you can pretty much copy everything from what you can see here:
Jun 04, 2022 01:08 PM
This is great - thank you. I’m doing something similar, and stuck.
How would I create a separate judge sheet for each judge automatically, whereby each judge I enter on the Judges table gets their own table with all relevant projects (similar to Teams) shown automatically?
Furthermore, we have categories whereby judges only rate certain projects within a category the judges and projects are assigned to.
So I have the following tables:
I’m trying to create judging sheets with each judge’s relevant projects so they can rate only those projects. Thank you!
Apr 11, 2023 04:02 PM
Hi Jonathan, I'm trying to create a scoreboard for golfers. I could figure it out manually choosing records but I need it automatic and that's where I'm struggling. Would like to take a look at any other tables you have that would be similar to this. Thanks!
Apr 04, 2024 05:23 AM - edited Apr 04, 2024 05:24 AM
I'm having a similar issue with scoring a single piece of content across multiple criteria and categories.
Our scores must be imported from excel because we can't use the AT forms (not flexible enough).
With this situation, could I look up the score for each item from the table I'm importing into and then do the math in the the scores table as you suggest?