Skip to content

Instantly share code, notes, and snippets.

View krooluang's full-sized avatar

Examblog64 krooluang

19 followers · 0 following
View GitHub Profile
@krooluang
krooluang / checkQuotaEmail
Last active May 6, 2020 10:52
function checkQuotaEmail () {
var emailQuota = MailApp.getRemainingDailyQuota();
Logger.log("โควต้าอีเมลคงเหลือ:" + emailQuota);
MailApp.sendEmail("your@gmail.com",
"แจ้งโควต้าการส่งอีเมล",
"สิทธิ์ในการส่งอีเมลของคุณวันนี้เหลือเท่ากับจำนวน "+emailQuota +"ฉบับ");
}
@krooluang
krooluang / button line
Created May 26, 2020 07:31
button line
{
"line": {
"altText": "This is a Flex Message",
"type": "flex",
"contents": {
"type": "bubble",
"body": {
"contents": [
{
"margin": "sm",
@krooluang
krooluang / quickReply
Created May 26, 2020 07:34
quickReply
{
"line": {
"text": "👉",
"quickReply": {
"items": [
{
"imageUrl": "https://www.apivat.com/line-chatbot/img-icon.png",
"action": {
"label": "ข้อมูลครู",
"text": "ข้อมูลครู",
@krooluang
krooluang / Main Menu quickReply
Created May 26, 2020 07:35
{
"line": {
"text": "👉",
"quickReply": {
"items": [
{
"imageUrl": "https://www.apivat.com/line-chatbot/img-icon.png",
"type": "action",
"action": {
"text": "เลือกรายการ",
@krooluang
krooluang / Boton link line
Created May 26, 2020 08:21
@krooluang
krooluang / linebot แยกชีท
Created May 28, 2020 04:44
var ss = SpreadsheetApp.openByUrl("sheetname");
var sheet = ss.getSheetByName("menu");
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 ){
@krooluang
krooluang / ข้อมูลนักเรียนครูรุ่ง
Created May 28, 2020 07:47
var ss = SpreadsheetApp.openByUrl("##");
var sheet = ss.getSheetByName("แผ่น1");
function doPost(e) {
var data = JSON.parse(e.postData.contents)
var userMsg = data.originalDetectIntentRequest.payload.data.message.text;
var values = sheet.getRange(2, 2, sheet.getLastRow(),sheet.getLastColumn()).getValues();
for(var i = 0;i<values.length; i++){
if(values[i][0] == userMsg ){
@krooluang
krooluang / webapp
Created May 29, 2020 12:06
function doGet(e) {
return render("index");
//return HtmlService.createHtmlOutputFromFile("index").setTitle('ระบบแจ้งอีเมล์โรงเรียน สพป.ชัยภูมิ เขต 1');
}
function getCode(code) {
var url = "https://docs.google.com/spreadsheets/d/1fzRHrFv7PEZ86qp_KKO492hbBeliWkjVTc9OczWi9mY/edit";
var ss = SpreadsheetApp.openByUrl(url);
var ws=ss.getSheetByName('แผ่น1')
var ws1=ss.getSheetByName('เมือง');
@krooluang
krooluang / html
Created May 29, 2020 12:25
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<base target="_top">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<link href='https://fonts.googleapis.com/css?family=Sarabun' rel='stylesheet' type='text/css'>
@krooluang
krooluang / ค้นหา2 sheet
Created June 5, 2020 12:51
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getSheetByName("แผ่น1");
function doPost(e) {
var data = JSON.parse(e.postData.contents)
var userMsg = data.originalDetectIntentRequest.payload.data.message.text;
var values = sheet.getDataRange().getDisplayValues()
let result = {
"fulfillmentMessages": [
{
"platform": "line",