Suoritettu

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]

Taidot: Google App Engine, Javascript, Ohjelmointi

Näytä lisää: 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, script process data online, import data google script, script sort data google spreadsheet, google spreadsheet valid data script, script gps data google maps api, php script process fedex ship data label, php process data add script

Tietoa työnantajasta:
( 22 arvostelua ) huntington beach, United States

Projektin tunnus: #15834865

Myönnetty käyttäjälle:

softtronicstech

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 päivässä
(5 Arvostelua)
3.6

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$83 USD 10 päivässä
(12 arvostelua)
4.9
Beannsofts

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.

$93 USD 7 päivässä
(1 arvostelu)
1.5
nubelo_uiGKeHcl

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 Lisää

$55 USD 3 päivässä
(0 arvostelua)
0.0
$83 USD 10 päivässä
(0 arvostelua)
0.0