Hi Adalo Community,
I’m building a golf scorecard app in Adalo and need some help integrating my databases properly. I’d like the player logged into the app to be able to create a scorecard, enter their buddy’s names, and track the scores.
Here’s a quick rundown of what I’ve built so far:
Collections:
- Game Sessions (tracks each round of golf)
- Players (stores player names, linked to a Game Session)
- Scores (intended to store hole-by-hole scores, linked to both Players and Game Sessions)
- Screens:
- New Game Screen: Users enter player names and start a new round. Player names are successfully saved in the Players collection and linked to the correct Game Session.
- Scorecard Screen: This should display a grid where users can enter scores per hole and see calculated results. However, I’m struggling to get the list to correctly filter and display the right players and scores for the current game session.
- Game Summary Screen: This is where I want to display the final results of the round—total scores per player, over/under par calculations, and other summary details.
Where I’m Stuck:
- How do I properly filter and display players and their scores so that only the ones linked to the current game session appear?
- How should I structure the Score collection so that each player’s score is stored correctly for each hole in that session?
- Any best practices for creating a grid-style input system where users can enter scores per hole and see calculations (over/under par, total score)?
I appreciate any guidance or insights—thanks in advance!