Setup Fusion Table as Database: Customize Your Table by Adding More Column to Store Data

To get more smartphones able to pushing sensor data to the same table, make sure to add more credential API KEY, different phone with different API KEY. 

Query that are use by the Fusion Table are 

INSERT INTO (TABLE ID)(,,...)VALUES(,,...)

The words in CAPS are part of the query's syntax. The words in parentheses are values that need to plug in. First there is a (column names) followed by VALUES followed by a list of (value names). The order of the column names and value must be in the same order so they match up. An example of what this might look like is shown below. Notice that the values must be enclosed in single quotes:

INSERT INTO 191GJakyqWHsan(Name,Date)VALUES('Sam','10/10/2012')

Gateway apps will push this query, and with the help of TABLE ID and API KEY. Those data will arrive to your table, and when arriving, a new ROW will be added to the existing column. Your columns name need to be similar between the name you assign at your query and table. To get that you need to.....

..... customize your table by:

1. Give a name to your table, by click the current name "New Table" and change table name at it setting
2. Add more or edit existing columns by going to Edit > Change Columns. You'll rename all the columns and select suitable data type for each of the column. 
3. Since you using this SensorGate app. You need to add 4 extra columns at the end of your table. Column for Date, Time, Latitude and Longitude. If you don't do that, there will be an error and failure in pushing data to the cloud. So please add it. This is to make your life easy as you know exactly where and when those data are collected and generate.