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
const PARENT_FOLDER_ID = "1_VyAmlhdZwcnb0iefewY1vPp71hIz4nP"; | |
const initialize = () => { | |
const form = FormApp.getActiveForm(); | |
ScriptApp.newTrigger("onFormSubmit").forForm(form).onFormSubmit().create(); | |
}; | |
const onFormSubmit = ({ response } = {}) => { | |
try { | |
// Get a list of all files uploaded with the response |
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 onFormSubmit() { | |
var form = FormApp.openById('xxx'); // ***ใส่ form id*** | |
var fRes = form.getResponses(); | |
var formResponse = fRes[fRes.length - 1]; | |
var itemResponses = formResponse.getItemResponses(); | |
var msg = '📣นักเรียนส่งงานครูอภิวัฒน์ '; | |
msg += ' \n' + itemResponses[0].getItem().getTitle() + ': ' + itemResponses[0].getResponse() + |
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 ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheet = ss.getSheetByName('ทำรายการ');//แผ่นงาน ทำรายการ | |
var data = sheet.getRange(2, 2, 1, 3).getValues()[0]; //ดึงข้อมูลเมื่อทำรายการ | |
var sheetName = sheet.getRange('A2').getValue()//ดึงชื่อผู้ทำรายการ จากแถว 2 คอลัมน์ 1 | |
var sheetNew = ss.getSheetByName(sheetName);//เอาชื่อที่ได้ไปอ้างอิงกับชีต | |
sheetNew.appendRow(data);//เพิ่มข้อมูลใส่เข้าไปในชีตนั้น | |
sheet.deleteRow(2);//ลบข้อมูลที่รับเข้ามาจากชีตทำรายการทิ้งไป |
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 sendLineNotify() { | |
var form = FormApp.openById('xxx'); | |
var tokens = ['xxx','xxx']; | |
var form_res = form.getResponses() | |
var formResponse = form_res[form_res.length - 1]; | |
var itemResponses = formResponse.getItemResponses(); |
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 onEdit(e) { | |
var token = 'xxx' | |
var range = e.range; | |
var row = range.getRow() | |
var column = range.getColumn() | |
var header = SpreadsheetApp.getActiveSheet().getRange(1,column).getValue() | |
var rowEdit = SpreadsheetApp.getActiveSheet().getRange(row,column).getValue() | |
var date = Utilities.formatDate(new Date(),'GMT+7','dd/MM/yyyy') | |
if(e.oldValue != e.newValue){ | |
SpreadsheetApp.getActiveSheet().getRange(row,4).setValue('วันที่ '+date+' แก้ไข '+header+' จาก '+e.oldValue+' เป็น '+rowEdit) |
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
var ss = SpreadsheetApp.openById("xxx"); | |
var sheet = ss.getSheetByName("xxx"); | |
function doPost(e) { | |
var data = JSON.parse(e.postData.contents) | |
var userMsg = data.originalDetectIntentRequest.payload.data.message.text; | |
var values = sheet.getRange(2, 1, sheet.getLastRow(),sheet.getLastColumn()).getValues(); | |
for(var i = 0;i<values.length; i++){ | |
if(values[i][0] == userMsg ){ |
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 message = 'ทดสอบส่งแจ้งเตือนแบบหลายกลุ่ม' | |
sendLineNotify(message) | |
} | |
function sendLineNotify(message) { | |
var tokens = ['token1', 'token2']; | |
for (var i = 0; i < tokens.length; i++) { | |
var options = { | |
"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
function doPost(e) { | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheet = ss.getSheetByName("เมนู"); | |
var data = JSON.parse(e.postData.contents) | |
var userMsg = data.originalDetectIntentRequest.payload.data.message.text; | |
var values = sheet.getDataRange().getValues(); | |
var info = values.find(function seek(row) { | |
return row[0] == userMsg; | |
}) | |
var result |
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 doGet(e) { | |
var template = HtmlService.createTemplateFromFile('index') | |
return template.evaluate().setSandboxMode(HtmlService.SandboxMode.IFRAME) | |
.addMetaTag('viewport', 'width=device-width , initial-scale=1') | |
} | |
function uploadFiles(form) { | |
try { | |
var dropbox = "xxx" |
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 doGet() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
} | |
function include(filename){ | |
return HtmlService.createHtmlOutputFromFile(filename).getContent() | |
} |