Proof of concept, using Google sheet as backend, datatable to make a webapp frontend.
The (simple) app itself does the following for a Google Sheet:
- Using a Google Sheet as a source, display it in a datatable
- Make a new google app standalone script on your domain, note the project ID.
- Clone this repo. Note that most of the code lives in
dev/
- Install node.js
npm install
- Authenticate with gapps, init with the project ID noted above
./upload
- Refresh your GAS script to see the code applied.
- In the "interface.gs" file change the ID of an example spreadsheet
- Select "Project" -> "Run as web app"
You can now display spreadsheet data through an instance of datatables
- Run the app, as above
- Install nodemon to your system path:
npm install nodemon -g
- Install mocha
npm install mocha
- Install the dependencies:
npm install
- Optionally (but recommended), open the project.sublime-project file which presents only the relevant files relevant for the web app development
- Run the app locally, running
test/server.sh
- Load
http://localhost:8888/Main
in your browser of choice (must support Proxy) - Any changes in the
dev/
folder automatically reflect in the browser (after refresh) - Publish to the cloud with
./upload
, which copies files tosrc/
and then rungapps upload
for you (which usessrc/
as the source to copy to the cloud) - Changes are now reflected in the cloud (reload and test)