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

[Salman_Dev]

@TIMAI2

JSONTextDecode block

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

[Kevinkun]

Can you show us what is the data of output?

[Salman_Dev]

Only a few name sir

This is what I did to get that row

And then

[Kevinkun]

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

[Salman_Dev]

Here you go

[Kevinkun]

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

[Salman_Dev]

Thank you @Kevinkun now it works

[Kevinkun]

try again

[Salman_Dev]

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