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
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
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
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
Hi Jason
- No - on the scores table the team-judge is a formula field, so autopopulates based on the team and judge selection:
Team & '-' & Judge
- 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
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.
Hi Jason
- No - on the scores table the team-judge is a formula field, so autopopulates based on the team and judge selection:
Team & '-' & Judge
- 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
@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.
@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:
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
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 Jason
- No - on the scores table the team-judge is a formula field, so autopopulates based on the team and judge selection:
Team & '-' & Judge
- 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
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!
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?
