Hi! I am using listview to organize all players in selected team. The Google sheet connected has two columns: the player and the team the player is in. If a certain team is selected, how can I set the listview to only the players apart of the specific team?
Since you get only col B and Col C index 2 of each item only we required. Add the above block at set listview elements to
Here the text box text is team Name.
You can set it in your style, but if you get col B and C (stored in the global list) then set team name in the place of tex box text you will get only the player name for the selected team.
I have done that I changed the code but this error appears:
RuntimeError. Irritants: (The operation select list item cannot accept the arguments: , [["Coach Barb's Bumblebees team", "Jemma"]], [2] Bad arguments to select list item)
I put the range as so because I want the app to read the two relevant columns (B and C) but I can change the code so it reads the whole sheet if that makes more sense.
Try to debug the obtained data from get global all playera
Connect in companion, once error is obtained drag one get variable from the drawer, change into allplayers, click right click on moise, select the Do it and share use the result
I could not deal with the start value, so I added a List Picker to let the user choose which team's roster to view. I think it's better that way, anyway.
I had to add a section to the incoming sheet data loading to also load the List Picker with the unique team names from the team name column. (I probably should have removed item 1 (the headings) from the sheet data before processing it.)
The List Picker sets the global team name to its selection, and asks for the sheet download again, leaving the team name filtering to that event.
It does not work when I test it on my IOS, the listpicker does not show any elements.
This is probably because the whenScreenInitilize block doesn't have a setListPickerElementsTo: and the sheet with the team names is not connected. How can I fix this?