Guest User

Untitled

a guest
Jun 22nd, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. function onFormSubmit() {
  2. // moves a row from a sheet to another when a magic value is entered in a column
  3. // adjust the following variables to fit your needs
  4. // see https://productforums.google.com/d/topic/docs/ehoCZjFPBao/discussion
  5.  
  6. var sheetNameToWatch = "Form Results";
  7.  
  8. var sheetNameToMoveTheRowTo = "Job List";
  9.  
  10. var ss = SpreadsheetApp.getActiveSpreadsheet();
  11. var sheet = SpreadsheetApp.getActiveSheet();
  12. var range = sheet.getActiveCell();
  13.  
  14.  
  15. if (sheet.getName() == sheetNameToWatch && range.getColumn()) {
  16.  
  17. var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
  18. var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
  19. sheet.getRange(range.getRow(), 1, 1,
  20. sheet.getLastColumn()).copyTo(targetRange), {contentsOnly:true};
  21. }
  22. }
Add Comment
Please, Sign In to add comment