Stuck and Lost – Need a Push in the Right Direction

I believe what I’m trying to do is quite ‘simple’ in comparison to how ‘robust’ PODS is, but I keep hitting walls that I can’t figure out how to break through.

In general I’m building a multi user application where users can track their ‘scores’ for different types of practice drills for games they want to improve in. Imagine I’m practicing tennis, and I have a drill to hit 100 backhands, so I want to track how many where successful and how many were not.

I’m using Elementor (although that may not be strictly ‘required’) and PODS.

I’ve tried to use the ‘normal ‘mode’ but couldn’t figure out some of the relationship stuff, so I shifted now to the “Advanced Content Types”, where I’m using separate DBase tables for my data.

I have 2 tables:
pds_pods_game
– id
– game_name
– game_description

pds_pods_score:
– id
– points_scored
– realted_game_id
– user_id

I have essentially 2 pages:
– List of Games (limited to the Games Created by the logged in user (I’m using a custom code snippet to accomplish the filtered list)
– Score “History” – a List of Scores “of” the Related Game (and the logged in user) – (THIS is where I’m currently Struggling)

I currently use Gravityforms for the user to ‘create’ a Game, which uses some custom fields to ‘set’ the logged in user as the author, and another form to create a ‘score’, which also uses some custom Gform short codes, to set the realted_game_id and user_id.

Where I’m struggling is, how to limit the ‘scores’ displayed on the ‘scores list’ page, to ONLY show the scores related to the game I’m drilling into.

So if I’m on the “Backgammon” page, and I click a button to “view score history”, I want to land on a page that displays “only” the scores related to game ID #1234 for example.

I’m currently “trying” to do this with passing a related_game_id parameter in the URL, then $_GET the value to inject into the query, but that seems not to be working.

I’ve tried so many things, that now, I’m super twisted up between how to solve the issue that I’ve painted myself in a corner….heh.

Would you have any ‘general’ strategic suggestions, and any specific items I should consider?