Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to update medal tally using another table

Solved
Jump to Solution
239 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Airtable Community. I’d like to create a medal tally for a school’s athletics meet where the results are counted by how many Gold, Silver and Bronze each school has. I’d like this medal tally to be automatically updated and sorted when I update an event table, e.g, if I update the winners for the table for 100m event by the school, the Medal Tally would automatically update.

1 Solution

Accepted Solutions

Hello @Aaron_Ah_Yuk!

I believer the setup you are looking for would take three tables, a School table, an Event table, and a Medals table which would be a many-to-many relationships / junction table between the School and Events table.

I created a basic example to show case how this would work. Below is the simple Event table (just listing a name):
Screen Shot 2021-04-13 at 9.58.30 AM

Here is the simple School table (I’ll cover the medal tally momentarily)Screen Shot 2021-04-13 at 9.59.43 AM

Then using a linked records field in our third table School Events you can connect each school to each event with any medals that school earned (this table will be where you enter how each school scored for each event):

Screen Shot 2021-04-13 at 10.00.24 AM

I then added a count field on the Schools table to count all occurrences of each school in the School Events table. The count
Screen Shot 2021-04-13 at 10.02.09 AM

Let me know if I can help provide any more information on the above, and if this helped answer your question please mark it as the solution :white_check_mark: .

See Solution in Thread

2 Replies 2

Hello @Aaron_Ah_Yuk!

I believer the setup you are looking for would take three tables, a School table, an Event table, and a Medals table which would be a many-to-many relationships / junction table between the School and Events table.

I created a basic example to show case how this would work. Below is the simple Event table (just listing a name):
Screen Shot 2021-04-13 at 9.58.30 AM

Here is the simple School table (I’ll cover the medal tally momentarily)Screen Shot 2021-04-13 at 9.59.43 AM

Then using a linked records field in our third table School Events you can connect each school to each event with any medals that school earned (this table will be where you enter how each school scored for each event):

Screen Shot 2021-04-13 at 10.00.24 AM

I then added a count field on the Schools table to count all occurrences of each school in the School Events table. The count
Screen Shot 2021-04-13 at 10.02.09 AM

Let me know if I can help provide any more information on the above, and if this helped answer your question please mark it as the solution :white_check_mark: .

Thank you Rose. Very helpful.