How to Update Fusion Map Dynamically From Google Response Spreadsheet of Google Form

Hi I am pretty new to google maps and fusion tables.

I am trying to update my Web Page(this) which contains the Google Form and Google IFrame of Map which linked from Google Fusion Table.

But, The Problem Is that after submitting the form the Location Column of Fusion table is Zipcode(Map Column) is Not updating in Fusion Table So, Depended Web Page IFrame also Not updating.

When I am doing 'Update Fusion Table' from my Form Response Spreadsheet, Fusion table is updating. But I Want Live update of Iframe in my webpage after submitting google Form.

I have Read the Tutorial of chrislkeller.

Thanks in advance for the help/smack-down (whichever it may be)!

Solution

Sounds like you've got the update portion of the script running like it should.

Now in the spreadsheet, go into the script editor (Tools > Script Editor) and choose the Resources menu item and go to All your triggers.

This will open up a "wizard" of sorts that will allow you to run specific functions when the form is submitted.

Here's an example... enter image description here

You'd be well to increase the range of data to be sent from the spreadsheet to the table, otherwise only the previous designated range will be sent.

Good luck and feel free to message me off-list if I can help…

Chris K.