click spinner and show only value in row b with the same value in spinner

34 views
Skip to first unread message

supriyadi

unread,
Jul 31, 2019, 3:46:47 AM7/31/19
to MIT App Inventor Forum
Hello all,

first i say thank you, because always reply my question,
i have data in google spreadsheet, like this 
ID Name
1234 Saya
1234 Mau
3452 test1
3452 test2
1234 Belajar
and in app invertor i have a spinner and, list view
i want, after select spinner, the listview can show only value of row b, with same id in spinner,

like this : if i click spinner value at 1234
the list view show, 

Saya
Mau
Belajar

anyone can help me for this,
and thank you for your answer,

test.JPG














best regards,


supriyadi

TimAI2

unread,
Jul 31, 2019, 5:50:40 AM7/31/19
to MIT App Inventor Forum
Will your spreadsheet be private or public (minimum Anyone with Link can view) ? - much easier if the latter....

ABG

unread,
Jul 31, 2019, 10:46:30 AM7/31/19
to MIT App Inventor Forum

supriyadi

unread,
Aug 1, 2019, 6:41:20 AM8/1/19
to MIT App Inventor Forum
@ timAi2 and @ABG,

thanks for the answer,
but i'm new in app invertor, so i no know how to create the right block
and my spreadsheet is anyone with Link can view, and this block i create to show in list view,
can you help me for create the correct block.

filter.JPG


best regards,

supriyadi


TimAI2

unread,
Aug 1, 2019, 6:52:54 AM8/1/19
to MIT App Inventor Forum
You can use google visualization query to do this

ABG

unread,
Aug 1, 2019, 11:40:53 AM8/1/19
to MIT App Inventor Forum
There is some required reading for this.

In the free online book http://www.appinventor.org/book2
read Chapter 18.

ABG

Reply all
Reply to author
Forward
0 new messages