This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 最初にスクリプトエディタの "スクリプトのプロパティ" に情報を登録します。 | |
// ssId: 宛先リストが記載されているスプレッドシートの ID | |
// sheetName: 宛先リストが記載されているスプレッドシートのシート名 | |
// confSheet: 宛先リストが記載されているスプレッドシートに作成したセッティングが記載されているシート名 | |
// docId: メール本文のテンプレートになる文章が記載されている Document の ID | |
// "スクリプトのプロパティ" から設定を読み込む | |
var props = PropertiesService.getScriptProperties(); | |
// スクリプト内で使う設定を登録する |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function sendListToApi() { | |
var props, ssId, sheetName, url, params, ss, sheet, range, values, csv; | |
props = PropertiesService.getScriptProperties(); | |
ssId = props.getProperty('ssId'); // Spreadsheet ID | |
sheetName = props.getProperty('sheetName'); //Sheet Name | |
url = props.getProperty('url'); // API URL | |
ss = SpreadsheetApp.openById(ssId); | |
sheet = ss.getSheetByName(sheetName); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function getSeparatedNames() { | |
var ss = SpreadsheetApp.getActive(); | |
var sheet = ss.getActiveSheet(); | |
var range = sheet.getRange('A:A'); | |
var values = range.getValues(); | |
var data = Array.prototype.concat.apply([], values); | |
var params = { | |
method: 'post', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Install phpbrew | |
sudo apt-get update | |
sudo apt-get install libmcrypt-dev | |
curl -L -O https://github.com/phpbrew/phpbrew/raw/master/phpbrew | |
chmod +x phpbrew | |
sudo mv phpbrew /usr/local/bin/ | |
phpbrew init | |
[[ -e ~/.phpbrew/bashrc ]] && source ~/.phpbrew/bashrc |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "foobar", | |
"version": "1.0.0", | |
"description": "hage", | |
"main": "index.js", | |
"devDependencies": { | |
"babel": "^6.5.2", | |
"babel-core": "^6.10.4", | |
"babel-loader": "^6.2.4", | |
"babel-preset-es2015-riot": "^1.1.0", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function getFileListInFolder() { | |
var url = 'https://drive.google.com/drive/folders/(GoogleDrive folder ID)', // URL of Google Drive folder. | |
paths = url.split('/'), // Separate URL into an array of strings by separating the string into substrings. | |
folderId = paths.pop(), // Get a last element of paths array. | |
folder = DriveApp.getFolderById(folderId), | |
files = folder.getFiles(), | |
list = [], | |
rowIndex = 1, // The starting row of a range. | |
colIndex = 1, // The starting row of a column. | |
ss, sheet,range, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<img width=200 src=cid:banner> | |
{ お名前 } 様 | |
この度はお問い合わせいただき、ありがとうございます。 | |
後ほど担当者より回答いたします。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function myFunction() { | |
var config = {} | |
config['spreadsheet'] = { | |
ssId: 'スプレッドシートの ID', | |
sheetName: 'リスト', | |
messageSheet: 'メッセージ', | |
testSheet: 'テスト', | |
displayValues: true, | |
emailLabel: 'メールアドレス' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(function(global) { | |
function SetValueToToday(className) { | |
var date = new Date(), | |
year, | |
month, | |
day, | |
today; | |
this.className = className || 'set-value-to-today'; | |
this.className = this.className.replace(/^\./, ''); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RewriteEngine On | |
# Some hosts may require you to use the `RewriteBase` directive. | |
# If you need to use the `RewriteBase` directive, it should be the | |
# absolute physical path to the directory that contains this htaccess file. | |
# | |
# RewriteBase / | |
RewriteCond %{REQUEST_URI} !(^/public/) | |
RewriteRule ^ index.php [QSA,L] |
OlderNewer