neno-tech
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 htmlOutput = HtmlService.createTemplateFromFile('index'); | |
| htmlOutput.message = ''; | |
| return htmlOutput.evaluate(); | |
| } | |
| function doPost(e) { | |
| var folder = DriveApp.getFolderById('xxx');//เปลี่ยนเป็นไอดีโฟลเดอร์เก็บไฟล์ของท่าน; | |
| var data = Utilities.base64Decode(e.parameter.fileData); | |
| var blob = Utilities.newBlob(data, e.parameter.mimeType, e.parameter.fileName); |
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 htmlOutput = HtmlService.createTemplateFromFile('index'); | |
| htmlOutput.message = ''; | |
| return htmlOutput.evaluate(); | |
| } | |
| function doPost(e) { | |
| var folder = DriveApp.getFolderById('xxx');//เปลี่ยนเป็นไอดีโฟลเดอร์เก็บไฟล์ของท่าน; | |
| var data = Utilities.base64Decode(e.parameter.fileData); | |
| var blob = Utilities.newBlob(data, e.parameter.mimeType, e.parameter.fileName); |
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) { | |
| return HtmlService.createTemplateFromFile("index").evaluate() | |
| .addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
| .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); | |
| } | |
| function checkLogin(username, password) { | |
| var url = 'xxx'; | |
| var ss= SpreadsheetApp.openByUrl(url); | |
| var webAppSheet = ss.getSheetByName("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 analize() { | |
| var ss = SpreadsheetApp.openById('xxx').getSheets()[0]//ใส่ไอดีชีตแทน xxx | |
| var data = ss.getRange('E2:X69').getValues()//ใส่ช่วงข้อมูลของท่านให้ถูกต้อง | |
| var indexObj ={ ก: "1", ข: "2", ค: "3", ง: "4" } | |
| data = data.map((row,i)=>{ | |
| row = row.map(col=>{ | |
| col = col.split(".")[0] | |
| return indexObj[col] | |
| }) | |
| return [("00"+(i+1)).slice(-4)+" "+row.join("")] |
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) { | |
| return HtmlService.createTemplateFromFile('index').evaluate() | |
| .addMetaTag('viewport','width=device-width , initial-scale=1') | |
| .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL) | |
| } | |
| function include(filename) { | |
| return HtmlService.createHtmlOutputFromFile(filename).getContent(); | |
| } |
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
| //เครดิต อ.ดรัณภพ ยิ้มแย้ม ธ.กรุงศรีฯ 000-7-29578-3 | |
| //LibraryId : 1CcBYkrGSeBRgphHUE92vWInyULOcJ1Ub6eFUR0_gI1h9I6whLjXtDA-P | |
| function doGet() { | |
| return HtmlService.createTemplateFromFile('index').evaluate() | |
| .addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
| .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL) | |
| } | |
| var url = '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() | |
| .addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
| .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL) | |
| } | |
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"> | |
| <title>SheetRock - DataTable</title> | |
| <!-- Bootstrap CSS 5.1.1 --> | |
| <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-F3w7mX95PdgyTmZZMECAngseQB83DfGTowi0iMjiWaeVhAn4FJkqJByhZMI3AhiU" | |
| crossorigin="anonymous"> | |
| <!-- Fonts Awesome--> |
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) { | |
| return HtmlService.createHtmlOutputFromFile('login') | |
| .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL) | |
| .setSandboxMode(HtmlService.SandboxMode.IFRAME) | |
| .setTitle('FirebaseUI | Firebase Authentication'); | |
| } | |
| function webAppUrl() { | |
| return ScriptApp.getService().getUrl(); | |
| } |
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 CHANNEL_ACCESS_TOKEN = 'xxx'; | |
| var line_endpoint = 'https://api.line.me/v2/bot/message/reply'; | |
| function doGet(request) { | |
| return ContentService.createTextOutput(JSON.stringify({ | |
| post: "ok" | |
| })).setMimeType(ContentService.MimeType.JSON); | |
| } | |
| function doPost(e) { |