Google Sheet GUI

I originally wanted to build a webapp that interacts with databases such as Postgres or MySQL using Python, host it via Heroku, and display it with iframe, but it was too much work. (Mainly because I don’t know how to do that yet.) So I went with the dumb way and decided to use Google Sheet to build a GUI/Dashboard instead….

However, the problem being I can’t get the published version to interact with the audience. (See below) I also haven’t figure out how to allow users to edit values without them changing the format. In addition, I don’t think google sheet will be mobile friendly… I tried to use plot.ly, but it seems I can’t embed the dashboard with the free account. I tried iframe plot.ly’s chart and it didn’t work. Looks like I will have to build it with google app script for real now  :'( Let’s hope that it could interact with google sheet and DB nicely as I’d love to avoid PHP… It should still be simpler than building it with python because I would have to build the GUI with Django, which I don’t know Django at the moment, that displays the table as well. Furthermore, who know if Heroku would play well with WP… (Doesn’t seem like it the other way around…) This will be a good opportunity for me to familiarize myself with JavaScript, though PHP may be better if I have to interact with Big Data in WP.

https://docs.google.com/spreadsheets/d/16hJ11aB0kn4MwYthlXXdn7UD-9kyHmxDPUOySGF56YU/edit?usp=sharing

Google App Script is DUMB! First of all, I would have to recreate the same script if I want to convert it to Google Site Gadgets. In addition, the problem being Google now has two site system, the classic and site, and the new site system doesn’t seem to accept Gadgets…

WebApp using Google App Script:

Reference:

  1.  https://en.support.wordpress.com/google-docs/
  2. https://www.blockspring.com/blog/google-spreadsheet-as-database
  3. https://cloud.google.com/appengine/docs
  4. https://developers.google.com/apps-script/
  5. https://code.google.com/p/google-apps-script-issues/issues/detail?id=852

Non Related Reference:

  1. http://askubuntu.com/questions/2368/how-do-i-set-up-a-cron-job
  2. http://noeticforce.com/python-online-compiler-interpreter-code-editors
  3. https://www.smartsheet.com/product-tour/card-view
  4. https://www.eisbahn.jp/chrome_mysql_admin/
  5. https://www.geogebra.org/