Slide 15
Slide 15 text
ۈଵهɿ("4
function doPost(e) {
// ରͷΛநग़
var pattern = /(?:\d{4}\/|)([1-9]|0[1-9]|1[0-2])\/([1-9]|0[1-9]|[12][0-9]|3[01])/;
var matchResult = e.parameter.text.match(pattern);
var date = new Date().getFullYear() + "/" + matchResult[1] + "/" + matchResult[2];
// εϓϨουγʔτʹɺ໊લɺຊจΛه
var sheet = getCurrentYearSpreadsheet().getSheets()[0];
var kintaiValues = sheet.getSheetValues(1, 1, maxRowCount, 3);
var newLineRow = -1;
for (var row = 0; row < 10000; row++) {
var dateCell = kintaiValues[row][0];
if (dateCell == "") {
newLineRow = row + 1;
break;
}
}
arrData = [
[date, e.parameter.user_name, e.parameter.text]
];
sheet.getRange(newLineRow, 1, 1, 3).setValues(arrData);
}