Skip to content

Instantly share code, notes, and snippets.

View krooluang's full-sized avatar

Examblog64 krooluang

18 followers · 0 following
View GitHub Profile
@krooluang
krooluang / update-login 010366
Created March 2, 2023 02:05
function login(obj){
event.preventDefault()
error.innerHTML = "";
loadingStart()
if(userInput.value != text){
error.innerHTML = "Captcha ไม่ถูกต้อง!!"
loadingEnd()
}else{
google.script.run.withSuccessHandler((data)=>{
if(data && data !== undefined && data.length != 0){
@krooluang
krooluang / Edit dataTable
Last active June 21, 2023 13:36
CDN ภาษาไทย DataTAble
https://datatables.net/plug-ins/i18n/Thai.html#CDN
------------------------------------------------------------------------------------------
language:{
url: "https://cdn.datatables.net/plug-ins/1.11.4/i18n/th.json"
},
------------------------------------------------------------------------------------------
@krooluang
krooluang / Blogger Blank
Created January 15, 2022 09:24
Template blogger
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html>
<html dir='LTR' xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr'>
<head>
<b:include data='blog' name='all-head-content'/>
<title><data:blog.pageTitle/></title>
<!-- Created by Artisteer v4.3.0.60745 -->
<meta content='initial-scale = 1.0, maximum-scale = 1.0, user-scalable = no, width = device-width' name='viewport'/>
<b:skin><![CDATA[
@krooluang
krooluang / LOGIN LOGOUT
Last active January 6, 2023 19:40
LOGIN LOGOUT
Copy Sheet : https://docs.google.com/spreadsheets/d/1l-wdzwGpTwx7WMiHXdo7WKGdQAD1c0_f2z8-R8YVzck/copy
window.open("https://www.google.com/", "_blank",);
<!--Signin-->
<center>
<span id="spin1" class="spinner-grow spinner-grow-sm text-danger d-none" role="status" aria-hidden="true"></span>
<span id="spin2" class="spinner-grow spinner-grow-sm text-warning d-none" role="status" aria-hidden="true"></span>
@krooluang
krooluang / code gs แบบค้นหาsheet เดียว
Last active June 8, 2020 09:45
code gs แบบค้นหาsheet เดียว หรือหลาย sheet
function doGet(e) {
return render("index");
//return HtmlService.createHtmlOutputFromFile("index").setTitle('ระบบแจ้งอีเมล์โรงเรียน');
}
function getCode(code) {
var url = "xxxxxxxxx";
var ss = SpreadsheetApp.openByUrl(url);
var ws = ss.getSheetByName("การตอบแบบฟอร์ม 1");
var data = ws.getRange(1, 2, ws.getLastRow(), ws.getLastColumn()).getDisplayValues();
@krooluang
krooluang / line แจ้งเตือน
Created June 7, 2020 02:25
function onFormSubmit() {
var form = FormApp.openById('1-P7h5C3FXEW9PDCF6uy6exMIWgKbcT3dg17txH-jsz0'); // ***ใส่ form id***
var fRes = form.getResponses();
var formResponse = fRes[fRes.length - 1];
var itemResponses = formResponse.getItemResponses();
var msg = 'ผลการสอบ:http://gg.gg/exam63'; msg +=//+
@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",
@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 / 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 / ข้อมูลนักเรียนครูรุ่ง
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 ){