🟩 [FREE] Google Sheets for AppInventor (replicant) using Google Apps Script

I've tried that before but it still doesn't appear in my listpicker.

I'm confused because the data can appear in the "Label" component
but not in the "ListPicker" component

I've done something like you said but it didn't work, here's the block

Can you show us what is the data of output?

1 Like

Only a few name sir

This is what I did to get that row

And then

I mean to show the data on a label, not the data in the spreadsheet.

1 Like

Here you go :wink:

this is a list of list. after JsonTextDecode, you need to pick item 1 from it, and set it as ListPicker's Elements


Thank you @Kevinkun now it works :wink:

try again

I've found the problem, apparently that the get event variable doesn't return "readColumn" but returns "readCol" :rofl: