A Google Apps Script to handle submissions sent to a Google Sheet via a webform, and send emails each time a submission is received.
Largely inspired by Google Sheets as a Database – INSERT with Apps Script using POST/GET methods.
This script must be added to your Google Sheet via 'Tools' -> 'Script Editor...'.
Your spreadsheet's column names must match the field names on your firm to properly submit data.
Gists for Make Your CSS Variable Names Suck Less on Fixate's blog.
Gists for Structuring Your Gulp Workflow on Fixate's blog.
Gists for CSS Display Properties: The Pillars Of Layout on Fixate's blog.
| #!/usr/bin/env bash | |
| set -eo pipefail | |
| DEPS='openssl build-essential libssl-dev libxrender-dev git-core libx11-dev libxext-dev libfontconfig1-dev libfreetype6-dev fontconfig xfonts-75dpi libjpeg-turbo8' | |
| echo $DEPS | xargs apt-get -y install | |
| rm -f /tmp/wkhtmltox-0.12.1_linux-trusty-amd64.deb | |
| wget http://download.gna.org/wkhtmltopdf/0.12/0.12.2.1/wkhtmltox-0.12.2.1_linux-trusty-amd64.deb -P /tmp | |
| dpkg -i /tmp/wkhtmltox-0.12.2.1_linux-trusty-amd64.deb |
| #!/usr/bin/env bash | |
| set -eo pipefail | |
| # Install rbenv | |
| if [[ ! -d ~/.rbenv ]]; then | |
| echo "Installing rbenv" | |
| git clone https://github.com/sstephenson/rbenv.git ~/.rbenv | |
| if [[ ! `grep 'eval "\$(rbenv init -)"' ~/.bashrc` ]]; then | |
| echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bashrc |
Taken from Navigating Postgresql with Psql Command Line – 10 Simple Commands and YoLinux Tutorial: The PostgreSQL Database and Linux
\l # List databases
\c database-name # Connect to database
\c # Show the database your are connected to
\d # List tables in database
\d table-name # Describe table