Google Sheet CRUDQ II

All selections are based upon the row id, in order to edit a specific record.

You can re-write / enhance your own script / blocks if you want to select by column id, but this will work across multiple records ?

im trying to let the listview as a spinner
i success to got first row to show on listview
when i try to pick one item its will choose the whole list
if its possible to fix
when listview after picking
i can use list index to show next selection
image

hello tim if it possible to make it?

Which column you are printing in list view?

im just show the first row on listview
but i want it be a autocephaly item to choose from listview

Sorry, i didn't get this one

independent?

now i choose the list like this i want to choose by 1 item eg.type1


this is how i get the data

If so, after list picking, split the list selection at /n so now type1,2&3 will become as list items. And by using select list item with index 1 or 2 take the required thing

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