Okay - potentially a difficult question… I’m creating an app for my hockey league. I’ve had some good success thus far. I have two things I’m hung up on.
- First issues
I have a standings screen that shows me the teams. When you click on the team it shows the roster. When you click on the individual player it shows you stats for the 24-25 season. How can I best incorporate stats from 23/24 and 22/23 seasons? also would there be a way to have a running total?
- League leaders
I have table that has all of the players on their stats. I am able to create league leaders here. Buttt… I would like to have a league leaders’ icon that would have a button for “goals” that would take me into the top 10 goal scorers. And the same for “assists”. I haven’t found a way to effectively make this work
Your Stats table should have a column to denote the season that the stat is being recorded, then you allow users to choose which season to view, writing that to a user-specific coumn, and then filter the records accordingly.
For running totals, if you want to do it by player for example, assuming you have a column to denote the player, make a multiple relation to that same player in the same Stats table (or do it from a Players table if you have it), and rollup > sum to get the running total.
I think it just needs a collection > sort by goal/assist/point descendingly, and limit to 10 items?
Thank you for the feedback. On the first item, below is my data table. It does have 24/25. 1) would it be best to have henry hunsaker 3 times?
Henry 24-25
Henry 23-24
Henry 22-23
Also, I’d like to have all the stats in one place, not something that anyone would have to click on.
_ like this, but this is a table I manually updated everything, trying to prevent that.
second one - I will have to try this? I’m wanting clickable buttons thought like this
