Google Sheet CRUDQ II

yes that's what i want to do ,but how ??
i had \n the list

Or use split text at space

Else use replace the item

could you show me with app inventor blocks?,please

i made it!
image

Since you are adding the items separately why don't you use directly the list view selection? Did you try? Forget about /n and all.

After listview picking
Set label text to list view selection

if it possible to split mulit line with a textbox spring to a single row for data to send gsheets
like this?
1
2
3

image

TY i will try to work with it tomorrow :grinning:

Google Sheets sees the content of global Data as an object. You need to stringify it, or parse the list.

If you have a function in Column B, and you want to use appendRow, then you need to include an empty value for column B

1 Like

sorry tim i try to find and think about the answer to do what you tell me
but i cant find it or too complication for me :persevere:
could you help me please

where should i put the block split text ?
i try many time and cant get the answer


image

Please show the data you are intending to send to google sheets, and show an example of how the data should look once it is appended to google sheets.

multi line textbox input


and i want to send like this ignore about the color
image
block :

script :

that's my final step to my project thanks a lot for your help

You can either send each item from the textbox, making three calls to the spreadsheet, or you can send all the items to the script, which would need a new internal function to handle the data when it is received....

Why do you keep deleting your posts ?

i found out im so stupid haha
all i need just use the spreadsheet fiction in app inventor
writecell

Shall we close this topic then ?

ah... im so sorry
maybe one more question
i read range by spreadsheet and i try to write range with the result
it show error 400 bad request