Apps Developer Blog

Information for Google Apps Developers

Crowd Sourcing with Google Forms and Fusion Tables

April 13, 2012
Share on Google+ Share on Twitter Share on Facebook
Google
Labels: Apps Script , Fusion Tables , Google Forms

8 comments :

Steve Webster said...

Please enable Fusion Tables for Google Apps for Business so it can be seen within the Docs List and used by SMB and large enterprises. The issue has been reported and starred by many. For planning purposes, will it be available by EOQ 2, 2012?

April 13, 2012 at 1:04 PM
Peter Sitterly said...

Maybe I'm missing something, but is there really a need for Fusion Tables and Apps Script for this particular example? One could just use the built-in charts in Google Spreadsheets, right?

I recognize that Fusion Tables has other charting options and apps script would give more flexibility in terms of automatically identifying the tossing out bad data, but the particular charts shown in this example just don't scream the need for Fusion Tables in this application.

April 13, 2012 at 3:04 PM
April Johnson said...

nice post! can't wait to try it out on my own project. Thanks!

April 15, 2012 at 8:35 PM
IctCalimero said...

I agree with Peter. The main advantage of Fusion Tables is geocoding : to display data geographically. The main disadvantage of Fusion Tables (and cloud computing) in general is the lack of trust of SMEs in cloud computing. I proposed SMEs to help displaying their customer's data to allow them improving their mailing campaigns. They are entirely positive on the functionality but are so afraid of putting their data in the cloud. Any suggestion on how to tackle this (rather irrational) argument?

April 15, 2012 at 11:36 PM
Kris said...

Can you programatically post from another web page on my personal site? I already have a web form to capture the details but want to store the details in Google Fusion tables. Are there any special HTTP headers I should be aware of for the POST to work? Thanks.

April 16, 2012 at 11:32 AM
Kathryn Brisbin said...

@Peter Sitterly and @IctCalimero - Yes, Google Spreadsheets are another option. Fusion Tables strengths are its Merging and Mapping capabilities. The example in this blog post was just a token sample intended to highlight the capabilities of Apps Scripts' ability to sync Form data to Fusion Tables. My hope was to help people think of new and interesting way to get their data into Fusion Tables for visualization purposes.

@IctCalimero - What are the SMEs main concerns?

April 17, 2012 at 4:08 PM
Unknown said...

Great Article! I am trying to use your Crowd Sourcing with Google Forms and Fusion Tables paper to create a google maps application which gathers GPS Data from my users and updates the public Fusion Tables. I basically want to be able to capture a GPS point, an image and some field data. Would Apps Scripts be the way to go? Or am I moving in the wrong direction. I am trying to make the jump from the Flex/ArcServer world so any information will be greatly appreciated.

May 11, 2012 at 10:22 AM
Bob Torzynski said...

Hi Kathryn,

I just found this article. Looks very useful to me! I will try it on some of my projects as an alternative to using PHP and MySQL as a crowd-sourcing mechanism.

Cheers!

Bob Torzynski,
Rochester, NY

July 25, 2013 at 6:59 AM

Post a Comment

  

Labels


  • .NET 3
  • #io15 1
  • Administrative APIs 26
  • Admin SDK 4
  • AdSense 1
  • analytics 4
  • Android 5
  • App Engine 5
  • Apps Script 98
  • Auth 1
  • billing 4
  • Charts 1
  • Chrome OS 1
  • classroom 1
  • Cloud Storage API 1
  • Community 1
  • Developers 5
  • Directory API 1
  • Drive 2
  • Drive SDK 38
  • execution API 1
  • Firebase 1
  • Freemium 1
  • Fusion Tables 2
  • Gadgets 5
  • Gmail APIs 16
  • Google+ 3
  • Google APIs 3
  • Google Apps 3
  • Google Apps Directory API 1
  • Google Apps Marketplace 3
  • Google Apps Script 1
  • Google Calendar API 20
  • Google Contacts API 3
  • Google Data Protocol 7
  • google docs 3
  • Google Docs API 20
  • Google Drive 2
  • Google Forms 4
  • Google I/O 3
  • googlenew 1
  • Google Prediction API 3
  • Google Profiles API 2
  • Google sheets 2
  • Google Sites API 4
  • Google Spreadsheets API 4
  • Google Talk 1
  • Google Tasks API 6
  • Groups 2
  • Guest Post 42
  • ISVs 2
  • java 1
  • JavaScript 3
  • marketing 3
  • Marketplace 47
  • Marketplace ISV Guest 21
  • Migration 1
  • Mobile 1
  • mpstaffpick 1
  • oauth 11
  • OpenID 7
  • PHP 1
  • python 4
  • realtime API 1
  • Resellers 2
  • Ruby 1
  • SaaS 1
  • security 1
  • Staff Picks 2
  • webinar 2


Archive


  •     2015
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Apr
    • Mar
    • Feb
  •     2014
    • Dec
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Mar
    • Feb
    • Jan
  •     2013
    • Dec
    • Nov
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Apr
    • Mar
    • Feb
    • Jan
  •     2012
    • Dec
    • Nov
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Apr
    • Mar
    • Feb
    • Jan
  •     2011
    • Dec
    • Nov
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Apr
    • Mar
    • Feb
    • Jan
  •     2010
    • Dec
    • Nov
    • Oct
    • Sep
    • Aug
    • Jul
    • Jun
    • May
    • Apr
    • Mar
    • Feb

Feed

Company-wide

  • Official Google Blog
  • Public Policy Blog
  • Student Blog

Products

  • Android Blog
  • Chrome Blog
  • Lat Long Blog

Developers

  • Developers Blog
  • Ads Developer Blog
  • Android Developers Blog
  • Google
  • Privacy
  • Terms