update fusion table from google maps API

Question

I've linked a fusion table with google maps API and each point within my map has html code for the balloon to display attributes from the fusion table.

What I'd like to do is allow a user to update information in the fusion table directly from within the balloon after clicking a placemark. Say there are three attributes that could be updated: Type, Condition, and Visibility.

I can't seem to find any instructions on how to do this but I imagine it should be possible... has anyone done something like this? Essentially I'd like to find a way to get the Fusion Table "edit row" feature embedded in the balloon.

Thanks!

AniV AniV · Accepted Answer · 2014-12-18T18:39:21

You can always use an UPDATE query to update the data in the Google Fusion Table through front end which is your map.

UPDATE <table_id>
SET <column_name> = <value> {, <column_name> = <value> }*
WHERE ROWID = <row_id>

This is the pseudo code for the to update the attributes in your table. For more information regarding updating the coordinates please refer to the following document. https://developers.google.com/fusiontables/docs/v1/sql-reference#updateRow

update fusion table from google maps API

1 Answers