Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onFormSubmit() {
- // moves a row from a sheet to another when a magic value is entered in a column
- // adjust the following variables to fit your needs
- // see https://productforums.google.com/d/topic/docs/ehoCZjFPBao/discussion
- var sheetNameToWatch = "Form Results";
- var sheetNameToMoveTheRowTo = "Job List";
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = SpreadsheetApp.getActiveSheet();
- var range = sheet.getActiveCell();
- if (sheet.getName() == sheetNameToWatch && range.getColumn()) {
- var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
- var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
- sheet.getRange(range.getRow(), 1, 1,
- sheet.getLastColumn()).copyTo(targetRange), {contentsOnly:true};
- }
- }
Add Comment
Please, Sign In to add comment