Advertisement
nsaunders

Untitled

Oct 9th, 2022
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. function pullColumns() {
  2.  
  3. var sheetID = "1C-TqfI989-D-VWFe6Xdvc0LQoqAX2T2C9zUFbkPQSXw";
  4. var formID = "1E5RS0XI5zaSVrRmeKhjhuZ6fTbe9ORCvsbHQsvuD4-s";
  5.  
  6. var sheet = SpreadsheetApp.openById(sheetID);
  7. var form = FormApp.openById(formID);
  8.  
  9. var colors = ["red", "blue", "green", "black", "orange", "purple"];
  10. colors.forEach(logElement);
  11. function logElement(element) {
  12. Logger.log(element);
  13. }
  14.  
  15. var data = sheet.getSheetByName("data");
  16.  
  17. var foo = "bar";
  18. for (var i = 1; i < 9; i++) {
  19. foo = data.getRange(1, i).getValue();
  20. Logger.log(foo);
  21. }
  22.  
  23.  
  24.  
  25.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement