Parameter in one DataPage effects choice in another

[JohnJ]

Just getting started with Caspio and am stumped. I have 2 DataPages that I am using on the same webpage that creates a 'Game'. A Game consists of a team, players and various statistics. One of the forms allows the user to create a new game and select a team from a dropdown that is populated from a view consisting of player names with various info like the team they are on and their player number. The second DataPage is were the stats get entered. On there is a drop down to display player numbers. I use the player number to link the stats to the player.

What I need it to do is update the player number dropdown with all the numbers that are linked to the team that is selected in other DataPage. Hopefully that makes sense.

 

Thanks.  

[Mathilda]

On 1/27/2017 at 4:10 AM, JohnJ said:

Just getting started with Caspio and am stumped. I have 2 DataPages that I am using on the same webpage that creates a 'Game'. A Game consists of a team, players and various statistics. One of the forms allows the user to create a new game and select a team from a dropdown that is populated from a view consisting of player names with various info like the team they are on and their player number. The second DataPage is were the stats get entered. On there is a drop down to display player numbers. I use the player number to link the stats to the player.

What I need it to do is update the player number dropdown with all the numbers that are linked to the team that is selected in other DataPage. Hopefully that makes sense.

 

Thanks.  

You need to pass Team ID from the first datapage to the second one. On the second datapage create a virtual field and receive parameter. Then you may use that virtual field as a parent field for the player field. You may find more info here and here