A good place to start learning Apps Script is by starting to manipulate data in your Google Spreadsheets. It’s often the case that you have used a Form to gather data but now you want to “tidy up” the data you’ve gathered and archive the items you have dealt with.
Creating something like this means you have to be able to move rows of data from one sheet to another. Once you can achieve this, you can make your spreadsheets do almost anything you want, perhaps moving data from a “Pending” to a “Current” sheet, or from a “Requested” sheet to an “Approved” sheet.
TO DO: A video showing this in action