Skip to content

Instantly share code, notes, and snippets.

View davidmccoy's full-sized avatar

David McCoy davidmccoy

26 followers · 15 following
View GitHub Profile
@davidmccoy
davidmccoy / google_script_form_ajax.js
Last active October 31, 2020 09:56
var $form = $('form#test-form'),
url = 'https://script.google.com/macros/s/abcdefghijklmnopqrstuvwxyz1234567890/exec'
$('#submit-form').on('click', function(e) {
e.preventDefault();
var jqxhr = $.ajax({
url: url,
method: "GET",
dataType: "json",
data: $form.serializeObject()
@davidmccoy
davidmccoy / google_script_form.html
Last active April 14, 2019 01:20
<form id="test-form">
<div>
<label>Field 1</label>
<input type="text" name="form_field_1" placeholder="Field 1"/>
</div>
<div>
<label>Field 2</label>
<input type="text" name="form_field_2" placeholder="Field 2"/>
@davidmccoy
davidmccoy / google_script.gs
Last active February 26, 2022 23:17
// original from: http://mashe.hawksey.info/2014/07/google-sheets-as-a-database-insert-with-apps-script-using-postget-methods-with-ajax-example/
// original gist: https://gist.github.com/willpatera/ee41ae374d3c9839c2d6
function doGet(e){
return handleResponse(e);
}
// Enter sheet name where data is to be written below
var SHEET_NAME = "Sheet1";
@davidmccoy
davidmccoy / Google-Sheet-Form-Post.md
Created June 10, 2017 01:16 — forked from willpatera/Google-Sheet-Form-Post.md
Post to google spreadsheet from html form

Overview

This collection of files serves as a simple static demonstration of how to post to a google spreadsheet from an external html <form> following the example by Martin Hawksey

Run example

You should be able to just open index.html in your browser and test locally.

However if there are some permissions errors you can make a quick html server with python. Open terminal and cd to the directory where the gist files are located and enter python -m SimpleHTTPServer. By default this creates a local server at localhost:8000

@davidmccoy
davidmccoy / Contract Killer 3.md
Last active August 29, 2015 14:26
The latest version of my ‘killer contract’ for web designers and developers

Contract Killer

The popular open-source contract for web designers and developers by Stuff & Nonsense

  • Originally published: 23/12/2008
  • Revised date: 15/12/2013
  • Original post
@davidmccoy
davidmccoy / gist:cc5c9fc2d27c01f52b77
Last active August 29, 2015 14:08 — forked from CyrilKrylatov/gist:5520294
jQuery(document).ready(function() {
/*
Snippet from http://stackoverflow.com/a/5918791
*/
navigator.sayswho = (function(){
var N= navigator.appName, ua= navigator.userAgent, tem;
var M= ua.match(/(opera|chrome|safari|firefox|msie)\/?\s*(\.?\d+(\.\d+)*)/i);
if(M && (tem= ua.match(/version\/([\.\d]+)/i))!= null) M[2]= tem[1];
@davidmccoy
davidmccoy / database.yml
Created April 8, 2014 15:38 — forked from CH-JesseMa/database.yml
development: &defaults
adapter: postgresql
encoding: unicode
pool: 5
host: localhost
username: <%= `echo $USER`.chomp %>
password:
database: <%= File.basename(Rails.root) %>_development
test:
@davidmccoy
davidmccoy / Gem for Development and Test
Last active August 29, 2015 13:58 — forked from CH-JesseMa/Gem for Development and Test
group :development, :test do
gem 'pry-rails'
gem 'rspec'
gem 'rspec-rails'
gem 'guard'
gem 'guard-rspec'
gem 'guard-bundler', require: false
gem 'terminal-notifier-guard'
gem 'shoulda-matchers'
gem 'capybara'
@davidmccoy
davidmccoy / how_to_ask_a_question.md
Created March 28, 2014 14:16

CONTEXT

WHAT USER STORY YOU ARE WORKING ON:

I am working on the user story "User wants to log in."

WHAT YOU ARE TRYING TO DO:

I am trying to have the user update their profile.

@davidmccoy
davidmccoy / html sinatra layout
Created March 21, 2014 14:04
html layout for sinatra
<html>
<head>
<title></title>
<meta charset="utf-8">
</head>
<body>
<%= yield %>
</body>
</html>