G Suite Stack Overflow

How it works?

The application works on Google Apps Script application development platform. It's simple forum, similar to Stack Overflow. All data is stored in Spreadsheet file on your Google Drive. It's been desinged for G Suite users in given company, login to the app is not required.

User can:

• ask questions
• add answers
• add comments and sub answers
• share all entries (as unique urls)
• vote questions and answers
• add/remove watchers in given question (watchers get email notification about all changes done in question). In private forum watcher get access to the question.
• create own forum (also private forum for selected users only)

Demo

G Suite Stack Overflow - demo

How to install?

1. Install Clasp from https://github.com/google/clasp

2. Enable Apps Script API by visiting https://script.google.com/home/usersettings

3. In a console window execute commands listed below:

   • clone this repository

     git clone https://github.com/aorczyk/g-suite-stack-overflow.git
     

   • Enter to created folder

     cd .\g-suite-stack-overflow\
     

   • log by Clasp to your Google Account

     clasp login
     

   • create Google App Script project

     clasp create 'G Suite Stack Overflow'
     

   • fetch created project

     clasp pull
     

   • push code to the new created Google App Script project

     clasp push
     

   • open your Google App Script project in a browser editor

     clasp open
     

4. In Google App Script editor:

   • open file "Config.gs" and run function "Install" (accept all permissions) - it will create new folder "G Suite Stack Overflow" on your Google Drive and two Spreadsheet files,
   • in the menu select "Publish" and "Deploy as web app",
   • select "Project version" as "New", add some description, "Execute the app as": Me, "Who has access to the app": "Only myself" or if you want to publish it in your company select "Anyone within ...",
   • copy "Current web app URL" and run it in a browser or click link in "Test web app for your latest code".
   • after first deploy set a web app URL in "Config.gs" in APP_CONFIG.appUrl, save the file and deploy the app again.

In the project I used:

• Google Apps Script - backend and running environment
• Google Apps Script SQL Abstract - database
• Vue.js - JavaScript Framework
• Vue Router - official router for Vue.js
• Vue I18n - internationalization plugin of Vue.js
• Bulma - CSS framework
• Less - language extension for CSS
• Quill - a free, open source WYSIWYG editor
• Font Awesome - icon set