2017년 1월 8일 일요일

how to add google fusion table data to a list


Hi i've been trying lately to make an app that displays the names of the users and their emails in a list view as elements 
i started brainstorming but i'm really  stuck 

--
learn how to work with lists
⦁ How to work with Lists and Lists of lists (pdf) by appinventor.org

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

--
here's attached a screen shot , however as i told i got stuck 

 cde.png

--
first do the Pizza Party tutorial to learn how to work with fusiontables

then send a SELECT statement to the table like this
SELECT * FROM <tableid>

and in the fusiontable controls got result event convert the result into a list using the list from csv table block and assign the list to the listview.elements

--
I actually did the pizza tutorial and fixed my code however it shows this 
runtime error :The operation list to csv table cannot accept the arguments: [/sdcard/AppInventor/assets: open failed: EISDIR (Is a directory)]
Note: You will not see another error reported for 5 seconds. 

 yess,png

--
I would use the list from csv table block instead

--
first sorry for the very late response 
second it actually worked but i need to work on some modifications 
first i want to remove the parenthesis 
second i want to remove the first item which is nameandlastname
 you will find screensshots for both the blocks and the error that i got

 errorliste.png

 codelist.png

--
instead of using the list from csv table block for 1 column csv tables you better use the split block to split at ∖n (new line) to get a list
then just remove the first item, which is the header row

--

댓글 없음:

댓글 쓰기