Slide 1
Slide 1 text
("4Ͱ4MBDL#PU
ߥ !BSB@UBDL
Slide 2
Slide 2 text
"CPVU.F
w ߥ !BSB@UBDL
w '63:6$PSQ
w "OESPJEͬͯ·͢
w ,PUMJOॻ͍ͯ·͢
Slide 3
Slide 3 text
࠷ۙͷۈଵཧ
4MBDLͰͬͯ·͢
Slide 4
Slide 4 text
͜Μͳײ͡
Slide 5
Slide 5 text
4MBDLͰͷۈଵཧ
w ϝʔϧΑΓָͰྑ͍ײ͡
w ࠓɺ୭͕ٳΉͷ͔ḪΒͳ͍ͱ͔Βͳ͍
w ேྱͰಉ͡νʔϜͷਓ͕Θ͟Θ͟ใࠂͯͨ͠
ˠࠓɺٳΉਓ͕4MBDLͰ௨͞ΕͨΒ͍͍ͳʔ
Slide 6
Slide 6 text
,JOUBJ#PU࡞Γ·ͨ͠
OBNF
OBNF
OBNF
OBNF
Slide 7
Slide 7 text
,JOUBJ#PU
w 4MBDLͰͷɺΈΜͳͷۈଵൃݴΛه
w ຖேɺͦͷͷରऀΛूܭ
w ໊લೖྗຊจΛ·ͱΊͯߘ
OBNF
OBNF
OBNF
OBNF
Slide 8
Slide 8 text
ͬͨͷ
w 4MBDL0VUHPJOH8FC)PPLT
w (PPHMF"QQT4DSJQU ("4
w (PPHMFεϓϨουγʔτ
Slide 9
Slide 9 text
0VUHPJOH8FC)PPLT
w 4MBDLͷಛఆͷจࣈΛؚΉߘʹԠ͢Δ
w ࢦఆͨ͠63-ʹ1045ϦΫΤετΛ͛Δ
w ϦΫΤετύϥϝʔλ͕ߘϢʔβʔ໊ɺ
ߘϝοηʔδͳͲΛؚΉ
Slide 10
Slide 10 text
(PPHMF"QQT4DSJQU
w +BWBTDSJQUޓͷεΫϦϓτݴޠ
w (PPHMFυΩϡϝϯτεϓϨουγʔτͳͲͷ
(PPHMF"QQTΛૢ࡞Ͱ͖Δ
w ࣌ؒ)551ϦΫΤετΛτϦΨʔʹͯ͠
ಈ͔͢͜ͱ͕Ͱ͖Δ
Slide 11
Slide 11 text
γεςϜߏ
("4
ۈଵه
(PPHMF
4QSFBE
4IFFU
("4
ۈଵूܭ
0VUHPJOH
8FC)PPLT
ۈଵೖྗ
ࠓͷۈଵʁ
ूܭ݁Ռදࣔ
1045
ϦΫΤετ
σʔλΛ
ه
σʔλΛ
औಘ
1045
ϦΫΤετ
ूܭ݁ՌΛ
4MBDLʹߘ
Slide 12
Slide 12 text
γεςϜߏ
("4
ۈଵه
(PPHMF
4QSFBE
4IFFU
("4
ۈଵूܭ
0VUHPJOH
8FC)PPLT
ۈଵೖྗ
ࠓͷۈଵʁ
ूܭ݁Ռදࣔ
1045
ϦΫΤετ
σʔλΛ
ه
σʔλΛ
औಘ
1045
ϦΫΤετ
ूܭ݁ՌΛ
4MBDLʹߘ
Slide 13
Slide 13 text
ۈଵهɿ4MBDL
w ۈଵൃݴશһ΄΅ಉ͡ϑΥʔϚοτͩͬͨ
ྫ
ʲશٳʳʢਫʣࢲ༻ͷͨΊ
w ʮʲʯΛτϦΨʔʹ0VUHPJOH8FC)PPLTͰ
ه༻ͷ("4ʹ1045ϦΫΤετΛૹ৴
w 1045ϦΫΤετʹߘऀͱຊจ͕ࡌ͍ͬͯΔ
Slide 14
Slide 14 text
ۈଵهɿ("4
w 4MBDL͔Β1045ϦΫΤετΛड͚Δ
w ຊจ͔Βਖ਼نදݱͰΛநग़͢Δ
͜ͷΛɺٳΉͱͯ͠ѻ͏
ྫ
ʲશٳʳʢਫʣࢲ༻ͷͨΊˠ
w ٳΉɺߘऀɺຊจΛεϓϨουγʔτʹه
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);
}
Slide 16
Slide 16 text
%FNP
ʮʲશٳʳʢਫʣࢲ༻ͷͨΊʯͱଧͬͯɺ
εϓϨουγʔτʹՃ͞ΕΔͷΛݟͯΈΔ
Slide 17
Slide 17 text
γεςϜߏ
("4
ۈଵه
(PPHMF
4QSFBE
4IFFU
("4
ۈଵूܭ
0VUHPJOH
8FC)PPLT
ۈଵೖྗ
ࠓͷۈଵʁ
ूܭ݁Ռදࣔ
1045
ϦΫΤετ
σʔλΛ
ه
σʔλΛ
औಘ
1045
ϦΫΤετ
ूܭ݁ՌΛ
4MBDLʹߘ
Slide 18
Slide 18 text
γεςϜߏ
("4
ۈଵه
(PPHMF
4QSFBE
4IFFU
("4
ۈଵूܭ
0VUHPJOH
8FC)PPLT
ۈଵೖྗ
ࠓͷۈଵʁ
ूܭ݁Ռදࣔ
1045
ϦΫΤετ
σʔλΛ
ه
σʔλΛ
औಘ
1045
ϦΫΤετ
ूܭ݁ՌΛ
4MBDLʹߘ
Slide 19
Slide 19 text
ۈଵूܭɿ4MBDL
w ࠓͷۈଵʁͱ͍͏4MBDLϦϚΠϯμʔΛ
࢝ۀͷલʹηοτ
SFNJOE,JOUBJUPࠓͷۈଵʁBUFWFSZXFFLEBZ
w ࠓͷۈଵʁΛτϦΨʔʹ0VUHPJOH8FC)PPL
Ͱूܭ༻ͷ("4ʹ1045ϦΫΤετ
Slide 20
Slide 20 text
ۈଵूܭɿ("4
w ۈଵهͷεϓϨουγʔτΛಡΈࠐΉ
σʔλɺߘऀɺຊจ
w ݱࡏͱಉ͡ͷσʔλ͚ͩநग़
w நग़ͨ͠σʔλ͔Β4MBDLߘ༻ͷจΛ࡞ͯ͠
4MBDLʹߘ͢Δ
Slide 21
Slide 21 text
ۈଵूܭɿ("4
function doPost(e) {
var now = new Date();
var slackMessage = "```\n”;
var sheet = getCurrentYearSpreadsheet().getSheets()[0];
var kintaiValues = sheet.getSheetValues(1, 1, maxRowCount, 3);
for (var row = 1; row < 10000; row++) {
var date = kintaiValues[row][0];
if (date == "") {
break;
}
// ݱࡏͱಉ͡σʔλ͚ͩநग़ͯ͠ɺߘ༻ϝοηʔδʹՃ
if (date.getFullYear() == now.getFullYear() && date.getMonth() ==
now.getMonth() && date.getDate() == now.getDate()) {
var name = kintaiValues[row][1];
var text = kintaiValues[row][2];
slackMessage += name + " " + text + "\n";
}
}
slackMessage += "```";
sendToSlack(slackMessage);
}
Slide 22
Slide 22 text
%FNP
ʮࠓͷۈଵʁʯͱଧͬͯɺ
ूܭ݁Ռ͕ߘ͞ΕΔͷΛݟͯΈΔ
Slide 23
Slide 23 text
࡞ͬͨײ
w (PPHMFυϥΠϒ্Ͱ݁ͨ͠ͷͰָͩͬͨ
w (PPHMF"QQT4DSJQU໘ന͍ɻ͍Ζ͍ΖͰ͖ͦ͏
w #PUՄѪ͍ɻ༊͞ΕΔ
࡞ͬͯΈ͍͔͕ͯʁ
Slide 24
Slide 24 text
ࠓޙΓ͍ͨ͜ͱ
w ՄѪ໊͍લͱΞΠίϯΛ͚͍ͭͨ
w ʹόάΔ͜ͱ͕Θ͔͍ͬͯΔͷͰͳΜͱ͔͢Δ
w ΑΓ៉ྷͳϑΥʔϚοτͰूܭΛߘ͢Δ
w औΓফ͠ػೳΛ͚ͭΔ
w ϒϩάʹ·ͱΊΔ