search

mostaphaRoudsari / SettlementEmerge

Designing the renewable city and region using e[m]ergy accounting
http://mostapharoudsari.github.io/SettlementEmerge/
MIT License
4 stars 1 forks source link

Use GoogleSheets as the database using POST/GET methods #17

Closed mostaphaRoudsari closed 9 years ago

mostaphaRoudsari commented 9 years ago

It came up during my discussion with Jill. It can potentially save us so much time and eliminates the need to re-write the excel logic in javascript. Based on this post it should be doable: https://mashe.hawksey.info/2014/07/google-sheets-as-a-database-insert-with-apps-script-using-postget-methods-with-ajax-example/

PS: If we can get this to work it will be a game-changer! :tada:

mostaphaRoudsari commented 9 years ago

https://gist.github.com/mhawksey/1276293

mostaphaRoudsari commented 9 years ago

Best example that I found so far. Will test it later. https://github.com/misoproject/dataset/blob/7b40fffbf4803ef630e979594686c4401321ebfa/src/importers/google_spreadsheet.js

mostaphaRoudsari commented 9 years ago

Now I finally understand the process. I need to write a Google App and then use Google Forms to GET/POST data from the page. Writing the app looks to be straight forward but making the connection to work live is something that I need to test to see how it works.

mostaphaRoudsari commented 9 years ago

This is set!