Please find the solution using the old forms, now called "Legacy Forms" here: Google Spreadsheet as Database (old solution)
Bryan asked in the AI forum Well, Google has introduced a new Form, and it is unclear when the old Form [Legacy Form] will be deprecated.
I have tried various things to get it to work [but unfortunately without success.].
Please find the solution below. Thank you Bryan for being the sponsor of this solution!
Version2.1: I now updated the example with an email functionality.
For details, see here: How to send a 'Contact Us' mail to a predefined email address automatically
Version2.2: I now enhanced the example with an update and delete functionality.
For details, see here: How to UPDATE and DELETE rows in a Google Spreadsheet
Important again is the correct preparation and to find the correct link to use. You need a Google spreadsheet,
which also needs to be published as webpage in the internet and you need the webform to be able to enter data in the internet.
With the GET command you will get all the data of the spreadsheet. If you prefer to work with select statements,
you can use the Google Visualisation API example (see below). After posting data you have to wait until
the published spreadsheet in the internet is updated before pressing GET to get the data back else you will not see your latest data.
The Google Visualisation API works for public spreadsheets and the best is,
you can use it with SQLish commands. The example uses the Guardian datastore's MPs expenses spreadsheet 2007-8. Just try the different select statements yourself...
The syntax is described here. Thank you
And another example from Scott see here.
If you find this example helpful and you are using it in one of your projects,
be nice and donate a small amount!
Thank you! Taifun
This work by Pura Vida Apps is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License
with attribution (name=Pura Vida Apps and link to the source site) required.