I’m new of this fantastic Bubble planet.
I’m designing a website in which there are 2 main Things (Players, Teams). I created also another Thing which represents the relationship between the two (a player can stay in N teams, a team can have M players) + some specific attributes like the season.
Now, I want to introduce another 2 Things called Drill and Performance. A Drill is an independent thing like Players and Teams, while Performance is the relationship between the tree + some specific attributes as the score of the performance.
At the moment I’m struggling with the page in which it is possible to record a new Performance for an existing drill made by a player for a specific team.
The fields to be filled in this page are:
Drill → dynamic dropdown that shows every drill created - NO ISSUE
Team → dynamic dropdown that shows every team created - NO ISSUE
Player → dynamic dropdown that shows every player of the team selected above - ISSUE
Score → input field - NO ISSUE
Date → date field - NO ISSUE
Here you can find the screenshots of the player’s dropdown settings:
where Giocatore = Player and Appartenenza is the relationship between a player and a team
Down here you can also see the “Search for Appartenenza” that I set:
My problematic dropdown shows a player in the case there is only one player in the team, otherwise it doesn’t have any value visible in the dropdown.
I used the debugger and it shows that the “search for giocatore” gets some results after the constraint, but none of them is shown as an option in the dropdown
How can I solve the problem?
Thank you in advance for your help!