Make IFTTT Date Format play nice with Google Spreadsheets
December 17, 2017 at 01:59PM
育児日記をDashボタンとAlexaでつける - Qiita
var SPREADSHEET_ID = '****'; | |
function onChange() { | |
var sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName('logs'); | |
var currentRow = sheet.getLastRow(); | |
if (currentRow<1) { | |
return; | |
} | |
var dateText = sheet.getRange(currentRow, 1).getValue(); | |
if (typeof dateText != "string") { | |
//文字列以外はスルー | |
return; | |
} | |
if (dateText == "") { | |
return; | |
} | |
try { | |
var date = convertDate(dateText); | |
//日付の値を設定 | |
sheet.getRange('A' + currentRow).setValue(date); | |
} catch(ex) { | |
Logger.log(ex); | |
return; | |
} | |
} | |
function convertDate(rawDateString) { | |
return Utilities.formatDate(parseDate(rawDateString), "JST", "yyyy/MM/dd HH:mm"); | |
} | |
function parseDate(rawDateString) { | |
// September 23, 2017 at 11:34PM | |
matched = rawDateString.match(/(\w+) (\d+), (\d+) at (\d+:\d+)(.*$)/); | |
// format for Aug 09 1995 00:00:00 PM GMT+0900 | |
return new Date(matched[1] + " " + matched[2] + " " + matched[3] + " " + matched[4] + " " + matched[5] + " GMT+0900"); | |
} | |
//Thanks: https://qiita.com/rechiba3/items/ef163b0fc21b37e869ef |