apivat60
apivat60
/ gist:6753f1ae1c74928c8785018b768f10ee
Created
October 13, 2020 05:55
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 Authentication(e) | |
| } | |
| function doPost(e) { | |
| return Authentication(e) | |
| } | |
| function Authentication(e) { | |
| if (e.parameter.func == "Create") { |
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 ManageSheet(e); | |
| } | |
| function doPost(e) { | |
| return ManageSheet(e); | |
| } | |
| function ManageSheet(e) { | |
apivat60
/ Scan_QR_IN_OUT
Created
September 25, 2020 08:30
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.openByUrl("ชีต URL"); | |
| var sheet = ss.getSheetByName("ชื่อชีต"); | |
| function doGet(e){ | |
| var action = e.parameter.action; | |
| if(action == "in") | |
| return inTime(e); | |
| if(action == "out") | |
| return outTime(e); |
apivat60
/ โค๊ดไลน์แชตบอต ค้นหาหลายชีต
Created
August 12, 2020 02:41
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) { |
apivat60
/ cod.gs ฟอร์มอัปเดท แก้ไข ค้นหา เพิ่มข้อมูล
Last active
February 13, 2022 06:37
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 op = e.parameter.action; | |
| var ss=SpreadsheetApp.openByUrl("ใส่ url ของชีต");////////////// | |
| var sheet = ss.getSheetByName("แผ่น1"); | |
| if(op=="insert") | |
| return insert_value(e,sheet); | |
| if(op=="read") |
apivat60
/ คำสั่งปิดข้อความ แอปพลิเคชั่นนี้สร้างโดยผู้ใช้อื่นซึ่งไม่ใช่ Google
Created
May 15, 2020 03:56
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 include(filename) { | |
| return HtmlService.createHtmlOutputFromFile(filename).getContent(); | |
| } | |
| function render(file, argsObject){ | |
| var tmp = HtmlService.createTemplateFromFile(file); | |
| if(argsObject) { | |
| var keys = Object.keys (argsObject); | |
| keys.forEach(function(key){ | |
| tmp[key] = argsObject[key]; | |
| }); |
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
| <html> | |
| <head> | |
| <style> | |
| table, th, td | |
| { | |
| margin:10px 0; | |
| border:solid 1px #333; | |
| padding:2px 4px; | |
| font:15px Verdana; | |
| } |
apivat60
/ code.gs การค้นหา แก้ไข อัปเดต ลบข้อมูล
Last active
September 6, 2022 06:39
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 op = e.parameter.action; | |
| var ss=SpreadsheetApp.openByUrl("ใส่ url ชีต"); | |
| var sheet = ss.getSheetByName("ใส่ชื่อแผ่นงาน"); | |
| if(op=="insert") | |
| return insert_value(e,sheet); | |
| if(op=="read") |
apivat60
/ code.gs การค้นหา แก้ไข อัปเดต ลบข้อมูล
Last active
May 14, 2020 09:17
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 op = e.parameter.action; | |
| var ss=SpreadsheetApp.openByUrl("ใส่ url ชีต"); | |
| var sheet = ss.getSheetByName("ใส่ชื่อแผ่นงาน"); | |
| if(op=="insert") | |
| return insert_value(e,sheet); | |
| if(op=="read") |
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
| /* สร้างเมนู pdf ใน Google Sheet */ | |
| function onOpen() { | |
| var ui = SpreadsheetApp.getUi(); | |
| ui.createMenu('PDF') | |
| .addItem('สร้างไฟล์ PDF','run_pdf') | |
| .addToUi(); | |
| } | |
| function run_pdf() { | |
| runPDFs(); | |
| } |