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
///////////code.gs/////////// | |
function doGet(e) { | |
var htmlOutput = HtmlService.createTemplateFromFile('index'); | |
htmlOutput.search=''; | |
return htmlOutput.evaluate(); | |
} | |
function doPost(e) { | |
var search =e.parameter.search; | |
var htmlOutput = HtmlService.createTemplateFromFile('index'); |
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 Tempfolder ; | |
var fileSlide ; | |
var copyFile; | |
function myFunction() { | |
var form = FormApp.openById('aaa'); // ***ใส่ form id*** | |
var fRes = form.getResponses(); | |
var fRes = fRes[fRes.length - 1]; | |
var item = fRes.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
รหัส ชื่อ สกุล เบอร์โทร อีเมล ชื่อเล่น วันเกิด | |
1111 สมชาย เรียนดี 0811234567 somchaey@gmail.com ชาย 1 มกราคม 2550 | |
2222 สมพงษ์ คนขยัน 0811234568 sompoang@gmail.com พงษ์ 2 กุมภาพันธ์ 2550 | |
3333 สมปอง คนเก่ง 0811234569 sompong@gmail.com ปอง 3 มีนาคม 2550 | |
4444 สมศักดิ์ รักเรียน 0811234570 somsak@gmail.com ศักดิ์ 4 เมษายน 2550 | |
5555 สมศรี คนสวย 0811234571 somsri@gmail.com ศรี 5 พฤษภาคม 2550 | |
6666 สมใจ ใฝ่เรียน 0811234572 somjai@gmail.com ใจ 6 มิถุนายน 2550 | |
7777 สมชัย ใจดี 0811234573 somchai@gmail.com ชัย 7 กรกฎาคม 2550 | |
8888 สมฤดี รักเรียน 0811234574 somrudee@gmail.com ฤดี 8 สิงหาคม 2550 | |
9999 สมฤทัย ใฝ่รู้ 0811234575 somruthai@gmail.com ทัย 9 กันยายน 2550 |
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
<!DOCTYPE html> | |
<html> | |
<head> | |
<base target="_top"> | |
</head> | |
<body> | |
<h1>ข้อมูลนักเรียน</h1> | |
<?var url = getUrl();?> | |
<form method="post" action="<?= url ?>" > | |
<label>ค้นหาข้อมูล</label><br> |
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 token='ใส่TokenLine'; | |
var url=''; | |
function myFunction() { | |
var ss = SpreadsheetApp.openById('ใส่ชีตID'); | |
var sheet = ss.getSheetByName('ใส่ชื่อแผ่นงาน'); | |
var name = sheet.getRange(sheet.getLastRow(), 2,1).getValue(); | |
url = sheet.getRange(sheet.getLastRow(), 3,1).getValue().split('=')[1]; | |
var date = Utilities.formatDate(new Date(), 'GMT+7', 'dd/MM/YYYY'); |
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
////// app script | |
function doGet(e) { | |
return HtmlService.createHtmlOutputFromFile("index"); | |
} | |
function saveData(name,phone){ | |
var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); | |
ss.appendRow([new Date(),name,"'"+phone]); |
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 sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; | |
var sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[1]; | |
var data1 = sheet1.getRange(sheet1.getLastRow(), 2,1,sheet1.getLastColumn()).getValues()[0]; | |
//===================================================" | |
let data,output1 ="",output2 ="",output3 ="",output4 ="" | |
data = sheet2.getDataRange().getDisplayValues() |
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 token = 'token line'; | |
var sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; | |
var sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[1]; | |
var name = sheet2.getRange('ระบุเรนจ์รายชื่อนักเรียน').getValues(); | |
var data = sheet1.getRange(sheet1.getLastRow(), 2,1,sheet1.getLastColumn()).getValues()[0]; | |
var date = Utilities.formatDate(new Date(), 'GMT+7', 'dd/MM/YYYY'); | |
var msg = 'สรุปการมาเรียนวันที่ '+date; | |
for(var i = 0;i<name.length;i++){ | |
msg+='\n'+name[i]+':'+data[i]; |
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 token1 = ["token1"];//โทเค่นไลน์ผู้มีสิทธิ์อนุมัติ | |
var form = FormApp.openById('id form'); | |
var fRes = form.getResponses(); | |
var formResponse = fRes[fRes.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 onFormSubmit() { | |
var form = FormApp.openById('ไอดีฟอร์ม'); | |
var fRes = form.getResponses(); | |
var formResponse = fRes[fRes.length - 1]; | |
var itemResponses = formResponse.getItemResponses(); | |
var ss = SpreadsheetApp.openById('ไอดีชีต'); | |
var sheet = ss.getSheetByName('การตอบแบบฟอร์ม 1'); |