CODEWITHSUNDEEP
app-inventorlistpicker
Timmey83
Timmey83

Reputation: 31

App Inventor - How to fill listpicker element with Google Spreadsheet query

I'm trying to query a Google Spreadsheet with its API and fill the results into listpicker elements. Unfortunately I do not get any result and no error message. It just happens nothing.

When I call the notifier with the result it is showing the right ones and also when I use the spreadsheets API directly through the browser I see the right results. But in App Inventor it is not filling the Listpicker Elements. I hope you can help me.

Here is an Image of my App Inventor Blocks enter image description here

Thanks a lot for your help in advance

Upvotes: 1

Views: 1772

Answers (1)

Taifun
Taifun

Reputation: 6293

Remove the red warning in the Web.GotText event, else that block will not fire!
And check, if the URL is correct, see also my example here.

Also you are selecting 1 column, which means, you get back a 1 column csv table as result... which means, you should use the split block and split at \n (new line) to convert the result into a list instead of using the list from csv row block...

enter image description here

Upvotes: 0

Related Questions