2015년 1월 1일 목요일

Wrong format CSV from fusion table to List

I really need help. I programmed a app, that saves entries from three text boxes in a fusion table. I attached a picture of the fusion table.

In the app there is a button and I want it to load the information from the fusion table. Therefore you have to enter a number so that the app knows which row it has to load from the fusion table. Lets say, i want to load the casenumber, name and phonenumber for the row where the casenumber is 1. My blocks work for this problem, but the entries in the list are wrong. I expected the app to save the row into the list as followed (Index 1 = casenumber, index 2 = name, index 3 = number). but when i hit the button that loades the row, the textbox shows "(1 micha 367)" instead of just "micha". When i change the index to "1", the output is (casenumber name number) instead of "1". 

this means, that the programm saves the row extracted from fusion table like this: Index 1 = (casenumber, name, number), index 2 = (1 micha 367). How can i make the programm to save the fusion table in the apps list as followed "Index 1 = casenumber, index 2 = name, index 3 = number"?




HI, your result is a list of lists. The list you are looking for has index 2, so you could do:
set global qRez to ( select list item list ( list from csv table text ( get result) index 2))
If you find it easier, you can also use two steps, have a global called fusionresult or similar and set it to what you now set qRez to. Then set qRez to the second element of it.


댓글 없음:

댓글 쓰기