Hi! I am trying to use join block to join two texts, but I want a line break separating them.
For instance:
text1="Sam's team:"
text2=
Sandra
Nicole
Monica"
and I wanted the final joined text to be
"Sam's team:
How would I separate the two text with line break using join block?
An html Label allows formatting using markup like
<br> for a line break, and
<li> at the front of list items.
That would be an awful place to do that.
That JOIN is creating a URL for uploading data to a spreadsheet.
Formatting that you asked for should be done only after receiving data and just for setting it up to display.
I am guessing that because you are asking this question you are new to the idea of linked sheets, with the sheet listing the players having an extra column identifying the team name where that player plays?
I originally had two columns: 1 for team name and corresponding column for player list, but I do not know how to find specific column that corresponds to team name. For example, if value was team name, the corresponding roster in sheets would appear on screen.
Give us a link we could follow to see the sheet with the player names and their teams, for better advice.
Before the data disappeared, I saw that you had crammed the team name and the player names into a single spreadsheet cell.
That's not a tabular arrangement, and it rules out any chance to filter the data or search by team name or player name.
The Computer Science approach is to keep a sheet with separate columns for team name and player name, repeating the team name in each column, to allow filtering and grouping of players by team name or by player name.
Study the advanced list blocks at
https://ai2.appinventor.mit.edu/reference/concepts/pholo.html
If you can't read it because it's in English, copy it to this board to enable translation.
Ok, I have decided to make a listview to view individual players on team. The spreadsheet with have the player name, then the team assigned on the corresponding column. How can I set listview to all players that are in the same team?
Get the spreadsheet in csv format, convert into list using the block list from csv table
Using for each item from the list block separate the players using the index. Index 1 prefers 1st col, 2nd prefers 2nd col. Add these col in another separate lust using the block add items to the list, finally add this list to the listview
Can I filter players on the list that are apart of a certain team? If so, how if players in column B have corresponding teams they belong to on column C?
You mean if the palyer say Sameera in col A, you want to find whether she is in any other team like col B/C/D in the gsheet? If exists want to get such team name?
If ye, it is possible either by mit app block or by using script url GET request
While making the list in the above said process itself you can achieve it
For example: (not actual sheet"
If value was blue team, Sophia and jannat would be on listviewer.
Yes possible.
Get CSV data and add into global list
Add team names in the list picker.
Once selected use the above said list preparatiin but based on the team selection from the liat picker in to the list using the condition
If the team name col A = list picker
Add items to the list from col B
And lass thia list to listview
How can I filter players? What blocks or code do I need to implement?
You can use the above said process or simply can run gviz query to return the player names based in the team selection
https://docs.google.com/spreadsheets/d/<YOYR_SPREADSHEET_ID/gviz/tq?tqx=out:csv&tq=SELECT B where A = ListPickerVakue
This listpicker value only team name and the col B is the player name. Just try, meanwhile your apreadsheet should have the minimum permission anyone can view
For more details refer @TIMAI2 guide 🟩 Use gviz to get and query google sheet data given in this link
To answer the original question (I knew I had covered it somewhere):
How do you join 2 texts and separate with a new line?
You can do it with google forms prefilled data upload, but you will still need a script to handle the data when it arrives at the sheet.
I do not understand how to run gviz query. I read the tutorial but am confused about what SELECT B = and more in the link outline you provided. These are the blocks I have added:
What do I add to these?
Hmm ok, this too you can try. So you have stored all the names in file. Then when will it get trigger to get data from file?
There is no supportive blocks in the image to read from file
If your query is different than the topic better make a new one.
