I’m building a golf scorecard app. You can register for a round/match (this writes to the matchs table) when you start a match, it opens a new page where you select the hole number, then select hole gross score. (this will write to holescore table)
My challenge is passing some data form the matches table to the holescore table (matchID, playerID, teamID)
So at which point do you record the score? Is it when you click the Play Match button?
I imagine you can have a form button that is structured exactly like this.
You can use special form values to pass the matchID to the destination table.
You might need an extra choice component to choose the player.
I’m not sure how the player relates to the team (is it a team having multiple players and a player can only belong to a single team or something else).
Thanks for your response.
The match to be played is selected (and you can see the players involved)
When you click on play match button, it brings you to this
where you select the hole number, then select the score for that hole. (my plan is to make it a multi step form that will take you through all 18 holes of the game)
It is a singles and doubles. Yes a team can have multiple players, and a player can only belong to one doubles team and entre as a singles player.
“You can use special form values to pass the matchID to the destination table.” this is the main issue I’m trying to figure out. How do I go about this?
Hi,
You can use the Action, Add row, and set the RowID in the field of you Table
Is it just aesthetic that you plan to do a custom form for this? A form/form container can also help you add rows to the scores table.
You can check this section when you create a new form.
That should give you the option to choose the match ID. You can add choice components for playerID and teamID.
the problem is that, I am using a new screen (detail screen) when you click on the ‘play match’ button to build a custom form.
here you have the match detail screen (rowID can be displayed - this is for reference here) when you click on the play match button
It opens a new screen connected to matchscores table.
I need to pass that rowID from the match table (in the match details screen) to this one (match scores)
Yeah it relates to my question above. Does it have to be a custom form or can it be a native form? It’s much easier if it’s a native form in my opinion.
But if it has to be the custom form.
Then this might be a problem. Why do you have to create that screen in the match scores table, opposed to having it on the current table (Match Details), where you have direct access to the rowID?