Advertisement
toxarz

Untitled

Feb 19th, 2020
361
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1.  
  2. function doGet(e) {
  3. Logger.log( JSON.stringify(e) ); // view parameters
  4. var result = 'Ok'; // assume success
  5. if (e.parameter == 'undefined') {
  6. result = 'No Parameters';
  7. }
  8. else {
  9. var sheet_id = 'id formuly google'; // Spreadsheet ID
  10. var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet(); // get Active sheet //getSheetByName('naam') voor ander blad
  11. var newRow = sheet.getLastRow() + 1;
  12. var rowData = [];
  13. var sheet2=SpreadsheetApp.openById(sheet_id).getSheetByName('Sheet2');
  14. var newRow2=sheet2.getLastRow() + 1;
  15. var rowData2 = [];
  16. rowData[0] = new Date(); // Timestamp in column A
  17. rowData2[0] = new Date();
  18. for (var param in e.parameter) {
  19. Logger.log('In for loop, param=' + param);
  20. var value = stripQuotes(e.parameter[param]);
  21. Logger.log(param + ':' + e.parameter[param]);
  22. switch (param) {
  23. case 'Temperature': //Parameter
  24. rowData[1] = value; //Value in column B
  25. result = 'Written on Column B';
  26. rowData2[1]= value;
  27. break;
  28. case 'Humidity': //Parameter
  29. rowData[2] = value; //Value in column C
  30. result += ', Written on column 3';
  31. break;
  32. case 'Light' :
  33. rowData[3]=value;
  34. result += ', Written in Column D';
  35. break;
  36. case 'Soil' :
  37. rowData[4]=value;
  38. result += ', Written in Column E';
  39. break;
  40. default:
  41. result = "unsupported parameter";
  42. }
  43. }
  44. Logger.log(JSON.stringify(rowData));
  45. // Write new row below
  46. var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
  47. var newRange2= sheet2.getRange(newRow2,1,1, rowData.length)
  48. newRange.setValues([rowData]);
  49. newRange2.setValues([rowData]);
  50. }
  51. // Return result of operation
  52. return ContentService.createTextOutput(result);
  53. }
  54. /**
  55. * Remove leading and trailing single or double quotes
  56. */
  57. function stripQuotes( value ) {
  58. return value.replace(/^["']|['"]$/g, "");
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement