
Google Script for Google Spreadsheets, 90% done - need expert for last 10% (onEdit)
- or -
Post a project like this3219
$30
- Posted:
- Proposals: 2
- Remote
- #1546818
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
General information for the business: Only experienced Google Script programmers
Kind of development: Customization of existing program
Num. of modules: 1
Description of requirements/functionality: Current code does the following
- monitor colums with header name STATUS using onEdit in Google Script
- if data changed in that column, then look for rows with header CHNGDT and NEWDT and set timestamp
Program currently works fine for 1 row onEdit change
Required changes
- if data is pasted to multiple rows (or a range) then
- traverse the range
- for every row check if column with header STATUS was changed
- update corresponding columns of these rows with header CHNGDT and NEWDT and set timestamp
And in short. What already works for 1 row. Now change and make it work when we paste a range too.
Specific technologies required: Google script, Google Sheets
Extra notes: - See image for example
- Upon acceptation you will receive our WORKING code (we will share a Google Spread Sheet that you can work in
- Please make it work for the Spreadsheet
- Write code directly in shared spreadsheet and save
- Make the code fast so no unnecessary checks and loops are done
- Upon delivery we will test first
- And if it works then release payment
EASY JOB for experience Google Script programmer
Kind of development: Customization of existing program
Num. of modules: 1
Description of requirements/functionality: Current code does the following
- monitor colums with header name STATUS using onEdit in Google Script
- if data changed in that column, then look for rows with header CHNGDT and NEWDT and set timestamp
Program currently works fine for 1 row onEdit change
Required changes
- if data is pasted to multiple rows (or a range) then
- traverse the range
- for every row check if column with header STATUS was changed
- update corresponding columns of these rows with header CHNGDT and NEWDT and set timestamp
And in short. What already works for 1 row. Now change and make it work when we paste a range too.
Specific technologies required: Google script, Google Sheets
Extra notes: - See image for example
- Upon acceptation you will receive our WORKING code (we will share a Google Spread Sheet that you can work in
- Please make it work for the Spreadsheet
- Write code directly in shared spreadsheet and save
- Make the code fast so no unnecessary checks and loops are done
- Upon delivery we will test first
- And if it works then release payment
EASY JOB for experience Google Script programmer
Mark B.
99% (36)Projects Completed
17
Freelancers worked with
15
Projects awarded
26%
Last project
25 Apr 2018
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies