fusion table

Ok two things when ppl enter data into my apps fusion table it is posting at the bottom of the list I need all resent posts at the top where do I change that. Second is there a way of alerting users when a new entry is entered



are you talking about the webviewer displaying your table?

you always can define your own SELECT statement, for example if you have a column datetime, you could order the result by datetime like this:

SELECT * FROM <tableid> ORDER BY datetime

just modify the table URL acccordingly, example: https://www.google.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+col3%2C+col0%2C+col1%2C+col2%2C+col4+from+1Ty90w_LWJEgZHNwEWgoebigLDEXPYLAgJHVHSFkk&containerId=googft-gviz-canvas

There is no alert feature, you have to execute a SELECT statement regularly, then check in the FusiontableControls.GotResult event if there are new records

Forgot the DESC ...

SELECT * FROM <tableid> ORDER BY datetime DESC

to get latest at top.

thanks ABG for spotting this

please clarify some more gentleman im still lost as to what you are exactly saying i should do can you show me a screen pic of blocks if possible thank you

are you talking about the webviewer displaying your table?

no the table itself when someone posts anew post it is posting at the bottom of the list i want all new entries at the top

new records always will be added on the bottom of the table

as already mentioned, you can execute a SELECT statement and order your records descending...

How do I do that?

use a SELECT statement

How to INSERT, DELETE and SELECT a Fusiontable by  Viktor