Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function doGet(e) {
- Logger.log( JSON.stringify(e) ); // view parameters
- var result = 'Ok'; // assume success
- if (e.parameter == 'undefined') {
- result = 'No Parameters';
- }
- else {
- var sheet_id = 'id formuly google'; // Spreadsheet ID
- var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet(); // get Active sheet //getSheetByName('naam') voor ander blad
- var newRow = sheet.getLastRow() + 1;
- var rowData = [];
- var sheet2=SpreadsheetApp.openById(sheet_id).getSheetByName('Sheet2');
- var newRow2=sheet2.getLastRow() + 1;
- var rowData2 = [];
- rowData[0] = new Date(); // Timestamp in column A
- rowData2[0] = new Date();
- for (var param in e.parameter) {
- Logger.log('In for loop, param=' + param);
- var value = stripQuotes(e.parameter[param]);
- Logger.log(param + ':' + e.parameter[param]);
- switch (param) {
- case 'Temperature': //Parameter
- rowData[1] = value; //Value in column B
- result = 'Written on Column B';
- rowData2[1]= value;
- break;
- case 'Humidity': //Parameter
- rowData[2] = value; //Value in column C
- result += ', Written on column 3';
- break;
- case 'Light' :
- rowData[3]=value;
- result += ', Written in Column D';
- break;
- case 'Soil' :
- rowData[4]=value;
- result += ', Written in Column E';
- break;
- default:
- result = "unsupported parameter";
- }
- }
- Logger.log(JSON.stringify(rowData));
- // Write new row below
- var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
- var newRange2= sheet2.getRange(newRow2,1,1, rowData.length)
- newRange.setValues([rowData]);
- newRange2.setValues([rowData]);
- }
- // Return result of operation
- return ContentService.createTextOutput(result);
- }
- /**
- * Remove leading and trailing single or double quotes
- */
- function stripQuotes( value ) {
- return value.replace(/^["']|['"]$/g, "");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement