Skip to content

Instantly share code, notes, and snippets.

View arpeggio068's full-sized avatar

arpeggio068

5 followers · 0 following
View GitHub Profile
@arpeggio068
arpeggio068 / index.html
Created June 16, 2023 10:36
date input with check leap year validity
<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-Zenh87qX5JnK2Jl0vWa8Ck2rdkQ2Bzep5IDxbcnCeuOxjzrPF/et3URy9Bv1WTRi" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.6.0.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.13.0/themes/base/jquery-ui.css">
</head>
<body>
<div class="container">
@arpeggio068
arpeggio068 / gist:e167d41e08717944736513483525fb1d
Created October 24, 2022 13:22
Frontend Library
//// start Frontend Library code.gs ////////////////////////////////////////////////////////////
function includeLibrary(){
return HtmlService.createHtmlOutputFromFile("library-js").getContent();
}
//// end Frontend Library code.gs //////////////////////////////////////////////////////////////
//// start Frontend Library library-js.html ///////////////////////////////////////////////////
@arpeggio068
arpeggio068 / gist:d39d583f158a79f4ccc63a1e76e1367c
Last active February 20, 2024 09:03
User Booking
//Code.gs
const spreadsheetId = 'Your Google Sheet ID';
const ss = SpreadsheetApp.openById(spreadsheetId);
function doGet(e){
return HtmlService.createTemplateFromFile("main").evaluate()
.setTitle("User Booking")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}
@arpeggio068
arpeggio068 / gist:beaf56502b872870d41ef571ab4f25e8
Last active March 24, 2024 02:52
Booking Reservation CRUD
//code.gs
const spreadsheetId = 'Your Google Sheet ID';
const ss = SpreadsheetApp.openById(spreadsheetId);
function doGet(e){
return HtmlService.createTemplateFromFile("main").evaluate()
.setTitle("Admin Booking")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}
@arpeggio068
arpeggio068 / gist:d00dcdb07e69e9198b4deba5a7258008
Last active December 18, 2023 05:39
form upload pic
//Code.gs
var ss = SpreadsheetApp.getActive();
var folderId = "Your Google Drive Folder ID";
var sheet = ss.getSheets()[0];
var token='Your Line Token';
function doGet(e) {
return HtmlService.createTemplateFromFile("form").evaluate()
.setTitle("ฟอร์มรายงานจุดเสี่ยง")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
@arpeggio068
arpeggio068 / search_CRUD
Last active January 4, 2024 05:33
//code.gs
const spreadsheetId = '1eFacH7dqvPoT-LzWXQVNmTvpyJJ-B88y-dNlzHiro0U';
const ss = SpreadsheetApp.openById(spreadsheetId);
function doGet(e) {
var tmp = HtmlService.createTemplateFromFile("index");
return tmp.evaluate()
.setTitle("ค้นหาง่ายๆ")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
@arpeggio068
arpeggio068 / Refer_20210124
Last active February 6, 2021 13:47
แบบฟอร์มทะเบียนรีเฟอร์
//Code
var url = "xxx";
var ss = SpreadsheetApp.openByUrl(url);
function doGet(e) {
return loadForm()
.setTitle("ฟอร์มรีเฟอร์")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
@arpeggio068
arpeggio068 / code ระบบบันทึกเลขหนังสือออนไลน์ 5_2_2021
Last active January 4, 2024 05:27
code ระบบบันทึกเลขหนังสือออนไลน์ 5/2/2021
//Code.gs
var url = "xxx";
var ss = SpreadsheetApp.openByUrl(url);
function doGet(e) {
var tmp = HtmlService.createTemplateFromFile("uform");
return tmp.evaluate()
.setTitle("เลขหนังสือ")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);