This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
.addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); | |
} | |
function getData() { | |
var spreadSheetId = "xxx"; //แก้ 1 | |
var range = SpreadsheetApp.openById(spreadSheetId).getRange('A2:E')//แก้ 2 | |
var values = range.getDisplayValues().filter(r=>r[0]!='') |
This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
.addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); | |
} | |
function getData() { | |
var spreadSheetId = "xxx"; //แก้ 1 | |
var dataRange = "Data!A2:F"; //แก้ 2 | |
var range = Sheets.Spreadsheets.Values.get(spreadSheetId, dataRange); |
This file contains hidden or 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.openById('xxx') | |
var sheet = ss.getSheetByName('xxx') | |
function doGet(e) { | |
var action = e.parameter.action | |
if (action == 'getUsers') { | |
return getUsers(e) | |
} | |
} |
This file contains hidden or 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
<style> | |
.btn-group-xs > .btn, .btn-xs { | |
padding: .25rem .4rem; | |
font-size: .875rem; | |
line-height: .5; | |
border-radius: .2rem; | |
} | |
</style> |
This file contains hidden or 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 HtmlService.createTemplateFromFile("Index").evaluate() | |
.setTitle("WebApp: Search By Password") | |
.addMetaTag('viewport', 'width=device-width, initial-scale=1') | |
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); | |
} | |
/* PROCESS FORM */ |
This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
} | |
function processForm(formObject){ | |
var result = ""; | |
if(formObject.searchtext){ | |
result = search(formObject.searchtext); | |
} | |
return result; |
This file contains hidden or 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
/* | |
* ABSENSI GOOGLE SCRIPT | |
* *********************************************************************************** | |
* Code by : fahroni|ganteng | |
* contact me : [email protected] | |
* Date : Mar 2021 | |
* License : MIT | |
* | |
*/ | |
This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
.setTitle("Responsive web app") | |
.addMetaTag('viewport','width=device-width , initial-scale=1') | |
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL) | |
} | |
function include(filename){ | |
return HtmlService.createHtmlOutputFromFile(filename).getContent() | |
} |
This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
} | |
function include(filename){ | |
return HtmlService.createHtmlOutputFromFile(filename).getContent() | |
} |
This file contains hidden or 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() { | |
return HtmlService.createTemplateFromFile('index').evaluate() | |
} | |
function include(filename){ | |
return HtmlService.createHtmlOutputFromFile(filename).getContent(); | |
} |