Struggling with filling labels from google fusion table

my goal is to fill multiple labels with specific data from the google fusion table , I started  building some blocks as you see attached ,the label is filled not with the name of the user but with the column name. Another thing i have any labels to fill as you see in the screenshot so what do you suggest as an option 

--

You may want to check THIS blog post to see how to pull data from fusion table

GoogleFusionSpredsheet.aia

-- 

the label is filled not with the name of the user but with the column name.

the result from the fusiontable will be like this (assuming, the email has been found and the name is John)

Nameandlastname

John

and in case the email has not been found, only the column header will be returned like this

Nameandlastname

you might want to use Do it to debug your email and sql statement, see also tip 4 here

Top 5 Tips: How to learn App Inventor

-- 

IT WORKED , here is the blocks attached here however i am asking is there is anyway to fill the other blank , could i get many values from various columns and then split them 

, and could i remove the name of the column 

ps : the  mistake was that i followed to do the sign up screen the pizza tutoriel and added a procedure to reset the form so appinventor saved the empty box as a start value 

-- 

could i remove the name of the column

see here how to add google fusion table data to a list

-- 

thanks , i will do that to remove name and last name but how can i retrieve data from google fusion  in a different and be able to use it in different ways 

example as you can see here attached i want to fill 

i'll explain  more with the picture attached :

let's say i wanna fill the image with an image link in appinventor 

the label name from the column name

the button text from the column region ...etc 

-- 

use a for each in list loop together with the advanced blocks

How to work with the advanced features
checkbox.aia

A Multiple Choice Quiz: How to work with the advanced features
quiz.aia

-- 

didn't understand your response but here's what i tried , it only returns the names of the columns

-- 

None of the Fusion Table rows have whatever your appstart value was in the email column?

What's in start value, anyway?

-- 

The email that the user entered 

-- 

you will have to use the list from csv table block to convert the result from the fusiontable into a list of lists

⦁ How to work with Lists by Saj

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

-- 

Prove to us that the result from the Fusion Tables query is what you think it is.

Proof consists of a right Click DoIt showing the value from a label text or global variable

that you just assigned the result into.

Not after you try to grind it up in csv conversion.

Show it to us raw.

-- 

It worked , your tips helped me a lot ,thanks really 

-- 

Another thing please can you explain this error  ?

-- 

The UPDATE statement has at least three problems ...

The double quote (") before yes has no closing double quote.

It ate all the following text, including the WHERE clause.

The WHERE clause was not based on the ROWID.

(That's your next bug, when it finally sees that WHERE clause.)

A clause is repeated in the middle.

What is that?

There is an unbalanced ")" near the end.

What is that for?

See the SQL Syntax link in the Fusion Tables section of this FAQ ...

Fusion Tables

--

btw. usually to take a screenshot from your device, just press the Off and Volume down button simultaneously...

--