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]
This is not hard but looks a bit tedious.
Relevant Skills and Experience
sample related demo
[login to view URL]
Proposed Milestones
$100 USD - basic project
$100 USD ใน 10 วัน
4.7 (5 รีวิว)
3.6
3.6
5 freelancers are bidding on average $83 USD for this job
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.
Hi, i have a script developed that do your work. It is a form that take options from a spreadsheet and when is send save the form in another spreadsheet, i can show you this work.
Habilidades y experiencia relevante
Google AppScript Html Javascrip
Htos propuestos
$55 USD - Develop the script that you need