Advertisement
safwan092

code.gs

Oct 6th, 2023
12
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. function doGet(e) {
  2. return HtmlService.createTemplateFromFile("form").evaluate()
  3. .setTitle("webpp_simple")
  4. .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  5. .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
  6. }
  7.  
  8. function setAutomatically(){
  9.  
  10. let ss = SpreadsheetApp.getActiveSpreadsheet();
  11. let sheet = ss.getSheetByName('Data');
  12. let val1 = sheet.getRange('A2').getValue();
  13. let val2 = sheet.getRange('B2').getValue();
  14. let val3 = sheet.getRange('C2').getValue();
  15. let val4 = sheet.getRange('D2').getValue();
  16. let val5 = sheet.getRange('E2').getValue();
  17. let val6 = sheet.getRange('F2').getValue();
  18.  
  19. return [val1 , val2 , val3 , val4 , val5 , val6];
  20.  
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement