For context, I’m creating a leaderboard for my fishing club management app. We fish 8 tournaments throughout the season. Each tournament, teams are scored on their best 5 fish (weight). So first place get’s 50 points, second place gets 46, third gets 44, fourth gets 42, etc…
Along with that, the team that weighs in the biggest fish for the night get’s an extra two points added to their score. So since I’m technically making two different leaderboards (one for total points and the other for big bass), I’ve already gone and created the series of array columns in order to make the leaderboard like in this video:Glide: Create a RANKED Leaderboard! - YouTube
What I’m now stuck on is what formula I need to use in order to take into account the extra 2 points for the winner of the big bass. At first, I thought it was just a simple MATH formula, but the formulas in Glide are way different than Airtable and I have zero idea how to create a formula for this scenario. Another option I saw was using Javascript, but I have zero clue what I’m doing there. I’ve tried asking ChatGPT, but had no luck there either.
If anyone can help me come up with a formula on how to add the extra 2 points to their overall points IF they won the big bass award, that would be a huge help!
Hi Mike,
Assuming you have a structure like this:
Tournaments
| RowID |
Tournament Name |
Date |
| f5c392c9-b0a1-4d17-b26a-26c2d9c6e764 |
Bassmaster Classic |
June 10, 2023 |
| 941a0e7f-2351-4d7f-88f6-319e312f34df |
Fishing Frenzy |
July 15, 2023 |
| 73e69a84-5f3e-4e9a-b3f0-8c1f8e3be829 |
Angler’s Challenge |
August 5, 2023 |
| 05e0c9b8-c9cd-4de1-aece-38b35a3c2537 |
Big Catch Tournament |
September 2, 2023 |
| d62854f3-68f1-4c4c-83a7-122ec6e69d45 |
Trout Slam |
October 21, 2023 |
Teams
| Team UUID |
Team Name |
| 52647d72-6514-4b91-80e4-462c0f3b3e5a |
Team A |
| 94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
Team B |
| d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
Team C |
Players
| Player UUID |
Player Name |
Team UUID |
| 29c2e89f-457b-4e7f-ae3b-03e614f6238a |
John Doe |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
| 3a4e5197-0dc3-4e8a-bc8c-b6c7d8893295 |
Jane Smith |
94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
| 9f51c0f9-3b5f-4c7d-876e-7a4023d7245a |
Alex Johnson |
d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
| 8252ef0a-9d9f-48e6-9c6e-fbb8d11e076e |
Emily Davis |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
| e78087a1-4772-4b73-b222-c4d3545c802a |
Michael Brown |
94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
| 702f5b1c-857d-4374-befe-c38f52ff6ab6 |
Sarah Wilson |
d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
| 61432923-8db3-4369-967f-6c6716d6b7e2 |
David Lee |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
| d319aad2-efde-4f59-a759-4a4de7bc67e7 |
Olivia Taylor |
94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
| 5367e383-d5e4-44ed-b9e3-0c44f98a94a1 |
Ethan Clark |
d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
| 74f1e5a9-67cc-4814-8d9f-c11921be4e48 |
Sophia Moore |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
Then, in the records table, we would have something like this, assuming we have only taken records from the first tournament. The “name” columns below are results of relation + lookup combos.
| RecordID |
TournamentID |
Tournament Name |
PlayerID |
Player Name |
TeamID |
Team Name |
Fish Size |
| 4e17a49c-2a87-4c83-9aeb-789bfa4ebabd |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
29c2e89f-457b-4e7f-ae3b-03e614f6238a |
John Doe |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
Team A |
12.5 |
| 835ae9ce-61c4-4fa5-a7e0-93e3c6ee1dd5 |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
3a4e5197-0dc3-4e8a-bc8c-b6c7d8893295 |
Jane Smith |
94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
Team B |
14.2 |
| b1b9d4eb-3eef-4913-9233-4e372dbb1091 |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
9f51c0f9-3b5f-4c7d-876e-7a4023d7245a |
Alex Johnson |
d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
Team C |
10.8 |
| f0a7425d-10c0-4151-aa72-43b54e726f7d |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
8252ef0a-9d9f-48e6-9c6e-fbb8d11e076e |
Emily Davis |
52647d72-6514-4b91-80e4-462c0f3b3e5a |
Team A |
13.9 |
| 9f35db6f-09df-4d89-91c9-5be2df68eb69 |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
702f5b1c-857d-4374-befe-c38f52ff6ab6 |
Michael Brown |
94718b24-5f1a-45ed-a6e7-4d4e2f4e79c2 |
Team B |
16.3 |
| 7512c894-3fb2-447b-88e2-3d352fd0c72e |
3db45a42-4eae-4a3e-8395-678be99744d7 |
Bassmaster Classic |
61432923-8db3-4369-967f-6c6716d6b7e2 |
Sarah Wilson |
d2d9ce91-90ee-4329-91b2-0b0a9c95c47a |
Team C |
9.7 |
What you would do next in the Records table:
1 Like