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: [url removed, login to view]
This is not hard but looks a bit tedious. Relevant Skills and Experience sample related demo [url removed, login to view] Proposed Milestones $100 USD - basic project
6 freelanceria on tarjonnut keskimäärin 77 $ tähän työhön
Check our many good reviews from our satisfied customers in software and websites development. We will make you happy Relevant Skills and Experience developer Stay tuned, I'm still working on this proposal.