neno-tech

function onEdit(e) {

  var ss = SpreadsheetApp.getActive()
  var sheet = ss.getSheetByName("Sheet1");

  var SendNotify = sheet.getRange('G2').getValue();//ช่องติ๊กส่งแจ้งเตือน

  if (SendNotify == true) {
    for (var i = 0; i < 5; i++) {
      var Selected = sheet.getRange(i + 2, 5).getValue();//เช็คว่าช่องไหนบ้างโดนติ๊ก

neno-tech

function doGet() {
  return HtmlService.createTemplateFromFile('index').evaluate()
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
  
}
function saveData(obj){
  var ss = SpreadsheetApp.openById('xxx').getSheetByName('ชีต1')
  var header = ss.getRange(1,1,1,ss.getLastColumn()).getValues()[0]
  var row = []

neno-tech

  * {
    padding: 0;
    margin: 0;
    box-sizing: border-box;
}

body {
    font-family: 'Poppins', sans-serif;
    background-color: #f0f2f5;

neno-tech

function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('สร้างรายงาน')
    .addItem('PDF','myPDF')
    .addToUi();
}

function myPDF(){
   const data = checkSel();
   if(data.sName == 'ชีต1' && data.results){

neno-tech

//ครูอภิวัฒน์ "สอนสร้างสื่อ"
function myFunction() {
  var token = 'xxx'
  var ss = SpreadsheetApp.openById('xxx')
  var sh = ss.getSheetByName('xxx')
  var row = sh.getLastRow();

  var today = Utilities.formatDate(new Date(), "GMT+7", "dd/MM/yyyy")
  var time = Utilities.formatDate(new Date(), "GMT+7", "HH:mm")
 Logger.log(time)

neno-tech

<style>
.btn-group-xs > .btn, .btn-xs {
  padding: .25rem .4rem;
  font-size: .875rem;
  line-height: .5;
  border-radius: .2rem;
}
</style>

neno-tech

function doGet(e) {
  return HtmlService.createTemplateFromFile("index").evaluate()
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}

function checkLogin(username, password) {
  var url = 'xxx';
  var ss= SpreadsheetApp.openByUrl(url);
  var webAppSheet = ss.getSheetByName("xxx");

neno-tech

var SHEET_NAME = "xxx";//ชื่อชีต
var SpreadsheetID = 'xxx'
var SCRIPT_PROP = PropertiesService.getScriptProperties();

function doGet(e) {
    var template = HtmlService.createTemplateFromFile('forms')
  return  template.evaluate().setSandboxMode(HtmlService.SandboxMode.IFRAME)
  .addMetaTag('viewport', 'width=device-width , initial-scale=1')
}
function setup() {

neno-tech

function doGet(e) {
  var htmlOutput =  HtmlService.createTemplateFromFile('index');
  htmlOutput.message = '';
  return htmlOutput.evaluate();
}

function doPost(e) {
  var folder = DriveApp.getFolderById('xxx');//เปลี่ยนเป็นไอดีโฟลเดอร์เก็บไฟล์ของท่าน;
  var data = Utilities.base64Decode(e.parameter.fileData);
  var blob = Utilities.newBlob(data, e.parameter.mimeType, e.parameter.fileName);

neno-tech

function doGet() {
  return HtmlService.createTemplateFromFile('index').evaluate()
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
}