Program Google Script to Process Data

Requirements: 1. Must know how to program google script for google spreadsheet. 2. We'll provide you the google spreadsheet containing data that need processing. You'll be programing in this google spreadsheet. 3. Below are the specific requirements for the google script. ==> (1) Have drop down button called "Execute Script" to run the script ==> (2) The script takes data from google spreadsheet called “Form Responses 1" and format to another sheet called "Goal Form”. ==> (3) Only data without “0” quantity should get recorded in “Goal Form", including the section "Other Item Requests" at the end of each section. See sheet called "Goal Form" for examples. ==> (4) Grey out left side timestamp to indicate that we have processed the data already. ==> (5) Overwrite "Goal Form" data with new data (if old data exist) ==> (6) Convert spreadsheet to PDF format, and then export the PDF to google drive 4. Here is the google spreadsheet containing "Form Responses 1" and "Goal Form" sheets: [login to view URL]