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: [url removed, login to view]

Compétences : Moteur Google App, Javascript, Programmation

en voir plus : script process data online, import data google script, script sort data google spreadsheet, google spreadsheet script get cell value, google sheets script examples, google apps script tutorial pdf, google script array, google spreadsheet script tutorial, google sheets script functions, google script for loop, google sheets script editor, google spreadsheet valid data script, script gps data google maps api, php script process fedex ship data label, php process data add script, perl script csv data google finance, job search engine script pull data simplyhired google, google finance comopany data script, script process data perl, perl script process data particular excel sheet

Concernant l'employeur :
( 22 commentaires ) huntington beach, United States

Nº du projet : #15834865

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 10 jours
(5 Commentaires)

5 freelance font une offre moyenne de $83 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(12 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)

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 G Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)