Help

Creating a Scoring System

Solved
Jump to Solution
9756 9
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Tay
4 - Data Explorer
4 - Data Explorer

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:

  • Created 3 different tables for each judge
  • Each judge’s table has a list of all the teams (teams are populated as new records across all judges’ tables automatically using external software)
  • Judges can manually key in the score for each metric and an overall score is automatically calculated in the respective record

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!

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

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:

Screenshot 2019-06-06 at 09.08.17.png

A judges table:

Screenshot 2019-06-06 at 09.08.54.png

And a scores table which links teams and judges:

Screenshot 2019-06-06 at 09.09.36.png

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:

Screenshot 2019-06-06 at 09.10.39.png

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

See Solution in Thread

9 Replies 9
JonathanBowen
13 - Mars
13 - Mars

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:

Screenshot 2019-06-06 at 09.08.17.png

A judges table:

Screenshot 2019-06-06 at 09.08.54.png

And a scores table which links teams and judges:

Screenshot 2019-06-06 at 09.09.36.png

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:

Screenshot 2019-06-06 at 09.10.39.png

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

Appreciate this alot! Definitely helps but I have 2 questions when using this structure:

  1. I guess I have to manually name the teams with a suffix -Judge X? (Or any recommended efficient way of doing this will help!)

  2. 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

Hi Jason

  1. No - on the scores table the team-judge is a formula field, so autopopulates based on the team and judge selection:

Team & '-' & Judge

Screenshot 2019-06-06 at 09.23.29.png

  1. Yes, when a judge wants to enter a score they choose the team and the judge, i.e. themself, and then enter the scores. You could get them to do this using an AT form if you don’t want them to see or have access to the underlying base.

Here’s a link to my mockup:

Copy it into your workspace to see the underlying field settings.

JB

Peg_Ivanyo
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

@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.

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:

Screenshot 2022-01-04 at 09.19.51

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:

  • Projects with a linked record to Categories
  • Judges with a linked record to Categories
  • Categories

I’m trying to create judging sheets with each judge’s relevant projects so they can rate only those projects. Thank you!

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!

annedoughertynm
5 - Automation Enthusiast
5 - Automation Enthusiast

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?