Advertisement
safwan092

Untitled

May 13th, 2023
25
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1. function doGet(e){
  2. Logger.log("--- doGet ---");
  3.  
  4. var tag = "",
  5. value = "";
  6.  
  7. try {
  8.  
  9. // this helps during debuggin
  10. if (e == null){e={}; e.parameters = {tag:"test",value:"-1"};}
  11.  
  12. tag = e.parameters.tag;
  13. value = e.parameters.value;
  14.  
  15. // save the data to spreadsheet
  16. save_data(tag, value);
  17.  
  18.  
  19. return ContentService.createTextOutput("Wrote:\n tag: " + tag + "\n value: " + value);
  20.  
  21. } catch(error) {
  22. Logger.log(error);
  23. return ContentService.createTextOutput("oops...." + error.message
  24. + "\n" + new Date()
  25. + "\ntag: " + tag +
  26. + "\nvalue: " + value);
  27. }
  28. }
  29.  
  30. // Method to save given data to a sheet
  31. function save_data(tag, value){
  32. Logger.log("--- save_data ---");
  33.  
  34.  
  35. try {
  36. var dateTime = new Date();
  37.  
  38. // Paste the URL of the Google Sheets starting from https thru /edit
  39. // For e.g.: https://docs.google.com/..../edit
  40. var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1QnTT18fdBRw_mkN28bhb0fLbeX682U2LiYNQsgktkyc/edit");
  41. var dataLoggerSheet = ss.getSheetByName("DataCollector");
  42.  
  43.  
  44. // Get last edited row from DataLogger sheet
  45. var row = dataLoggerSheet.getLastRow() + 1;
  46.  
  47.  
  48. // Start Populating the data
  49. dataLoggerSheet.getRange("A" + row).setValue(row -1); // ID
  50. dataLoggerSheet.getRange("B" + row).setValue(dateTime); // dateTime
  51. dataLoggerSheet.getRange("C" + row).setValue(tag); // tag
  52. dataLoggerSheet.getRange("D" + row).setValue(value); // value
  53.  
  54.  
  55. // Update summary sheet
  56. summarySheet.getRange("B1").setValue(dateTime); // Last modified date
  57. // summarySheet.getRange("B2").setValue(row - 1); // Count
  58. }
  59.  
  60. catch(error) {
  61. Logger.log(JSON.stringify(error));
  62. }
  63.  
  64. Logger.log("--- save_data end---");
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement