Google api

使用 url get 新增資料到 google sheet

googel sheet https://docs.google.com/spreadsheets/d/1a03XIhkgDMx8TGmUm7xH_o8kOePJMLs3M4_Gf0I-4JA/edit#gid=0

TempLog_Script https://script.google.com/d/1bMihPMzf1UGy3s193t7Hvg51t0mAdmylcGVzjPE07heAvLUXQsGTOk-y/edit?usp=drive_web

var SS = SpreadsheetApp.openById('1a03XIhkgDMx8TGmUm7xH_o8kOePJMLs3M4_Gf0I-4JA'); //Enter Your Sheet ID Got From Sheet URL Link

var sheet = SS.getSheetByName('TempSheet'); // Enter your sheet name here, In my case it is TempSheet

var str = "";

function doGet(e){

var tmp = SS.getSheetByName('TempSheet');

var val1 = e.parameter.value1;

var val2 = e.parameter.value2;

var nextFreeRow = tmp.getLastRow() + 1;

if (e.parameter.value1 === undefined)

return ContentService.createTextOutput("No value passed as argument to script Url.");

var now = Utilities.formatDate(new Date(), "GMT+8", "yyyy-MM-dd'T'hh:mm a'Z'").slice(11,19);

tmp.appendRow([val1, val2, now]);

return ContentService.createTextOutput("Successfully wrote: one record into spreadsheet.");

}

url get

https://script.google.com/macros/s/AKfycbyyXHZTxO69CoRLLZ3b9ofD_1YLK_CtD9at641bomIZ1uzREZs/exec?value1=22.8&value2=27.9

Web Scan barcode and QRcode to google sheet (android 可用，ios不能用)

https://3.114.197.59/test/scan.php?gs=AKfycbyp-gxLXuXNZReXw46ZYLqSQQCFDW5GuEjPF4m2v2-B58rlszIb

googel sheet https://docs.google.com/spreadsheets/d/1AqclHQp73m-3HV4whd2_3XIvC56CbyfuOkMhMi-lghI/edit#gid=149226104

barcode Script https://script.google.com/d/15aRUnTmquzzGkD-EYDruFqTHb0pKKZrmp1TfgBC6fTe6m97fpHT4a2sg/edit?usp=drive_web&folder=0AEpD1yeyJPKsUk9PVA&splash=yes

//程式碼開始

//URL https://script.google.com/macros/s/AKfycbyp-gxLXuXNZReXw46ZYLqSQQCFDW5GuEjPF4m2v2-B58rlszIb/exec?barcode=

var spreadSheetID = "1AqclHQp73m-3HV4whd2_3XIvC56CbyfuOkMhMi-lghI";

var spreadSheet = SpreadsheetApp.openById(spreadSheetID);

var sheet = spreadSheet.getActiveSheet();

var lastRow = sheet.getLastRow();

function doGet(e) {

var param = e.parameter;

var barcode = param.barcode;

sheet.getRange(lastRow+1, 2).setValue(barcode);

sheet.getRange(lastRow+1,1).setValue(Date());

return ContentService.createTextOutput(barcode);

}

html

<!doctype html>

<head>

<title>ZXing TypeScript | Decoding from camera stream</title>

href="https://fonts.googleapis.com/css?family=Roboto:300,300italic,700,700italic">

href="https://unpkg.com/normalize.css@8.0.0/normalize.css">

href="https://unpkg.com/milligram@1.3.0/dist/milligram.min.css">

</head>

<body>

<p>Scan barcode and QR Code from Camera</p>

<div>

<a class="button" id="startButton">Start</a>

<a class="button" id="resetButton">Reset</a>

</div>

<div>

</div>

<label for="sourceSelect">Change video source:</label>

</select>

</div>

<label>Result:</label>

</main>

window.addEventListener('load', function () {

let selectedDeviceId;

const codeReader = new ZXing.BrowserMultiFormatReader()

console.log('ZXing code reader initialized')

codeReader.getVideoInputDevices()

.then((videoInputDevices) => {

const sourceSelect = document.getElementById('sourceSelect')

selectedDeviceId = videoInputDevices[0].deviceId

if (videoInputDevices.length >= 1) {

videoInputDevices.forEach((element) => {

const sourceOption = document.createElement('option')

sourceOption.text = element.label

sourceOption.value = element.deviceId

sourceSelect.appendChild(sourceOption)

})

sourceSelect.onchange = () => {

selectedDeviceId = sourceSelect.value;

};

const sourceSelectPanel = document.getElementById('sourceSelectPanel')

sourceSelectPanel.style.display = 'block'

}

document.getElementById('startButton').addEventListener('click', () => {

update = Date.now();

milliseconds = 1500;

codeReader.decodeFromVideoDevice(selectedDeviceId, 'video', (result, err) => {

if (result) {

let currentDate = Date.now();

if(currentDate - update > milliseconds) {

update = Date.now();

fetch('https://script.google.com/macros/s/AKfycbyp-gxLXuXNZReXw46ZYLqSQQCFDW5GuEjPF4m2v2-B58rlszIb/exec?barcode='+ result.text)

.then(function(response) {

})

console.log(result);

beep();

document.getElementById('result').textContent = result.text

}

if (err && !(err instanceof ZXing.NotFoundException)) {

console.error(err)

document.getElementById('result').textContent = err

}

})

console.log(`Started continous decode from camera with id ${selectedDeviceId}`)

})

document.getElementById('resetButton').addEventListener('click', () => {

codeReader.reset()

document.getElementById('result').textContent = '';

console.log('Reset.')

})

.catch((err) => {

console.error(err)

})

function sleep(milliseconds) {

const date = Date.now();

let currentDate = null;

do {

currentDate = Date.now();

} while (currentDate - date < milliseconds);

}

function beep() {

var snd = new Audio("data:audio/wav;base64,//uQRAAAAWMSLwUIYAAsYkXgoQwAEaYLWfkWgAI0wWs/ItAAAGDgYtAgAyN+QWaAAihwMWm4G8QQRDiMcCBcH3Cc+CDv/7xA4Tvh9Rz/y8QADBwMWgQAZG/ILNAARQ4GLTcDeIIIhxGOBAuD7hOfBB3/94gcJ3w+o5/5eIAIAAAVwWgQAVQ2ORaIQwEMAJiDg95G4nQL7mQVWI6GwRcfsZAcsKkJvxgxEjzFUgfHoSQ9Qq7KNwqHwuB13MA4a1q/DmBrHgPcmjiGoh//EwC5nGPEmS4RcfkVKOhJf+WOgoxJclFz3kgn//dBA+ya1GhurNn8zb//9NNutNuhz31f////9vt///z+IdAEAAAK4LQIAKobHItEIYCGAExBwe8jcToF9zIKrEdDYIuP2MgOWFSE34wYiR5iqQPj0JIeoVdlG4VD4XA67mAcNa1fhzA1jwHuTRxDUQ//iYBczjHiTJcIuPyKlHQkv/LHQUYkuSi57yQT//uggfZNajQ3Vmz+Zt//+mm3Wm3Q576v////+32///5/EOgAAADVghQAAAAA//uQZAUAB1WI0PZugAAAAAoQwAAAEk3nRd2qAAAAACiDgAAAAAAABCqEEQRLCgwpBGMlJkIz8jKhGvj4k6jzRnqasNKIeoh5gI7BJaC1A1AoNBjJgbyApVS4IDlZgDU5WUAxEKDNmmALHzZp0Fkz1FMTmGFl1FMEyodIavcCAUHDWrKAIA4aa2oCgILEBupZgHvAhEBcZ6joQBxS76AgccrFlczBvKLC0QI2cBoCFvfTDAo7eoOQInqDPBtvrDEZBNYN5xwNwxQRfw8ZQ5wQVLvO8OYU+mHvFLlDh05Mdg7BT6YrRPpCBznMB2r//xKJjyyOh+cImr2/4doscwD6neZjuZR4AgAABYAAAABy1xcdQtxYBYYZdifkUDgzzXaXn98Z0oi9ILU5mBjFANmRwlVJ3/6jYDAmxaiDG3/6xjQQCCKkRb/6kg/wW+kSJ5//rLobkLSiKmqP/0ikJuDaSaSf/6JiLYLEYnW/+kXg1WRVJL/9EmQ1YZIsv/6Qzwy5qk7/+tEU0nkls3/zIUMPKNX/6yZLf+kFgAfgGyLFAUwY//uQZAUABcd5UiNPVXAAAApAAAAAE0VZQKw9ISAAACgAAAAAVQIygIElVrFkBS+Jhi+EAuu+lKAkYUEIsmEAEoMeDmCETMvfSHTGkF5RWH7kz/ESHWPAq/kcCRhqBtMdokPdM7vil7RG98A2sc7zO6ZvTdM7pmOUAZTnJW+NXxqmd41dqJ6mLTXxrPpnV8avaIf5SvL7pndPvPpndJR9Kuu8fePvuiuhorgWjp7Mf/PRjxcFCPDkW31srioCExivv9lcwKEaHsf/7ow2Fl1T/9RkXgEhYElAoCLFtMArxwivDJJ+bR1HTKJdlEoTELCIqgEwVGSQ+hIm0NbK8WXcTEI0UPoa2NbG4y2K00JEWbZavJXkYaqo9CRHS55FcZTjKEk3NKoCYUnSQ0rWxrZbFKbKIhOKPZe1cJKzZSaQrIyULHDZmV5K4xySsDRKWOruanGtjLJXFEmwaIbDLX0hIPBUQPVFVkQkDoUNfSoDgQGKPekoxeGzA4DUvnn4bxzcZrtJyipKfPNy5w+9lnXwgqsiyHNeSVpemw4bWb9psYeq//uQZBoABQt4yMVxYAIAAAkQoAAAHvYpL5m6AAgAACXDAAAAD59jblTirQe9upFsmZbpMudy7Lz1X1DYsxOOSWpfPqNX2WqktK0DMvuGwlbNj44TleLPQ+Gsfb+GOWOKJoIrWb3cIMeeON6lz2umTqMXV8Mj30yWPpjoSa9ujK8SyeJP5y5mOW1D6hvLepeveEAEDo0mgCRClOEgANv3B9a6fikgUSu/DmAMATrGx7nng5p5iimPNZsfQLYB2sDLIkzRKZOHGAaUyDcpFBSLG9MCQALgAIgQs2YunOszLSAyQYPVC2YdGGeHD2dTdJk1pAHGAWDjnkcLKFymS3RQZTInzySoBwMG0QueC3gMsCEYxUqlrcxK6k1LQQcsmyYeQPdC2YfuGPASCBkcVMQQqpVJshui1tkXQJQV0OXGAZMXSOEEBRirXbVRQW7ugq7IM7rPWSZyDlM3IuNEkxzCOJ0ny2ThNkyRai1b6ev//3dzNGzNb//4uAvHT5sURcZCFcuKLhOFs8mLAAEAt4UWAAIABAAAAAB4qbHo0tIjVkUU//uQZAwABfSFz3ZqQAAAAAngwAAAE1HjMp2qAAAAACZDgAAAD5UkTE1UgZEUExqYynN1qZvqIOREEFmBcJQkwdxiFtw0qEOkGYfRDifBui9MQg4QAHAqWtAWHoCxu1Yf4VfWLPIM2mHDFsbQEVGwyqQoQcwnfHeIkNt9YnkiaS1oizycqJrx4KOQjahZxWbcZgztj2c49nKmkId44S71j0c8eV9yDK6uPRzx5X18eDvjvQ6yKo9ZSS6l//8elePK/Lf//IInrOF/FvDoADYAGBMGb7FtErm5MXMlmPAJQVgWta7Zx2go+8xJ0UiCb8LHHdftWyLJE0QIAIsI+UbXu67dZMjmgDGCGl1H+vpF4NSDckSIkk7Vd+sxEhBQMRU8j/12UIRhzSaUdQ+rQU5kGeFxm+hb1oh6pWWmv3uvmReDl0UnvtapVaIzo1jZbf/pD6ElLqSX+rUmOQNpJFa/r+sa4e/pBlAABoAAAAA3CUgShLdGIxsY7AUABPRrgCABdDuQ5GC7DqPQCgbbJUAoRSUj+NIEig0YfyWUho1VBBBA//uQZB4ABZx5zfMakeAAAAmwAAAAF5F3P0w9GtAAACfAAAAAwLhMDmAYWMgVEG1U0FIGCBgXBXAtfMH10000EEEEEECUBYln03TTTdNBDZopopYvrTTdNa325mImNg3TTPV9q3pmY0xoO6bv3r00y+IDGid/9aaaZTGMuj9mpu9Mpio1dXrr5HERTZSmqU36A3CumzN/9Robv/Xx4v9ijkSRSNLQhAWumap82WRSBUqXStV/YcS+XVLnSS+WLDroqArFkMEsAS+eWmrUzrO0oEmE40RlMZ5+ODIkAyKAGUwZ3mVKmcamcJnMW26MRPgUw6j+LkhyHGVGYjSUUKNpuJUQoOIAyDvEyG8S5yfK6dhZc0Tx1KI/gviKL6qvvFs1+bWtaz58uUNnryq6kt5RzOCkPWlVqVX2a/EEBUdU1KrXLf40GoiiFXK///qpoiDXrOgqDR38JB0bw7SoL+ZB9o1RCkQjQ2CBYZKd/+VJxZRRZlqSkKiws0WFxUyCwsKiMy7hUVFhIaCrNQsKkTIsLivwKKigsj8XYlwt/WKi2N4d//uQRCSAAjURNIHpMZBGYiaQPSYyAAABLAAAAAAAACWAAAAApUF/Mg+0aohSIRobBAsMlO//Kk4soosy1JSFRYWaLC4qZBYWFRGZdwqKiwkNBVmoWFSJkWFxX4FFRQWR+LsS4W/rFRb/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////VEFHAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU291bmRib3kuZGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMjAwNGh0dHA6Ly93d3cuc291bmRib3kuZGUAAAAAAAAAACU=");

snd.play();

}

</script>

</body>

</html>

Google Sites

Report abuse