Skip to content

Instantly share code, notes, and snippets.

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"
integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Prompt">
<style>body {font-family: "Prompt"; font-size: 16px;}th,td {text-align: center }</style>
สูตรรันเลขคิวอัตโนมัติ
={"ลำดับคิว";ARRAYFORMULA ("Q" & text (ROW (B1:INDEX (B:B, COUNTA (B:B)-1)), "000"))}
------------
โค้ด.gs
-------------
var data
var ss = SpreadsheetApp.openById('aaa')
var sheet = ss.getSheetByName('aaa')
var range = sheet.getDataRange().getDisplayValues()
function doGet(e) {
@k2003
k2003 / CodeMonk#pg_backup.bat
Created September 21, 2020 06:22 — forked from CodMonk/CodeMonk#pg_backup.bat
Batch file to backup PostgreSQL DB
@echo off
goto comment
Author: Code Monk
Description: This file use to backup the database using PostgreSQL backup utility "pg_dump".
Backup parameters should be setup before executing this file
File Format flags :
c = Custom
t = Tar
@k2003
k2003 / generator-installation.md
Created September 6, 2018 06:32 — forked from siteslave/generator-installation.md
ติดตั้ง Generator

รันคำสั่ง (อยู่นอกโฟลเดอร์ myKpi)

npm i -g nodemon typescript yo generator-express-ts

จากนั้น รันคำสั่ง

yo
{
"allergy": [
{
"request_id": "",
"uid": "",
"provider_code": "11053",
"provider_name": "รพ.กันทรวิชัย",
"drug_name": "",
"symptom": ""
}
{
"drugs": [
{
"request_id": "",
"uid": "",
"provider_code": "11053",
"provider_name": "รพ.กันทรวิชัย",
"seq": "",
"date_serv": "",
"time_serv": "",
@k2003
k2003 / slidespage.html
Created August 7, 2018 03:30 — forked from aarjithn/slidespage.html
Sliding Segments Ionic v2
<ion-toolbar>
<ion-segment [(ngModel)]="selectedSegment" (ionChange)="onSegmentChanged($event)">
<ion-segment-button value="first">
First
</ion-segment-button>
<ion-segment-button value="second">
Second
</ion-segment-button>
<ion-segment-button value="third">
Third