Write 2 scripts for Google Sheets
- or -
Post a project like this3016
$250
- Posted:
- Proposals: 2
- Remote
- #1002753
- Awarded
Description
Experience Level: Intermediate
General information for the business: We make videos
Description of requirements/functionality: Hello,
I need 2 scripts written for a Google Sheet.
Script 1: Copies data from one Google Sheet (source) into another (destination)
Script 2: When cells are updated in one sheet (destination) then the equivalent cell is updated (source)
To understand the details more fully,
1. Open this Workbook:
https://docs.google.com/spreadsheets/d/1Wmx0sMqyLU5rX1pRKu-1mY4-VRse904hg3Z4K_VsTE4/edit#gid=0
2. Review the data on the sheet: "Input 1:Source Data"
3. Open this workbook: https://docs.google.com/spreadsheets/d/1zjI5yMJ2sweeCcsFvhTe1DZH6aBMXP29bnb_kcaEuMU/edit#gid=1326970169
4. Review the data on the sheet: "Input 2: Destination"
5. Notice the condition in cell A1: K="LV" -- This means that Script 1 should only pull data from the source where column K="LV" (the condition will always be in cell A1)
6. Notice the columns. Only SOME of the columns from the "Source" are in the "Destination". Only these columns should be populated.
7. Script 1 should pull the data from the SOURCE and populate the DESTINATION:
8. Notice the tab: "Correct Output: Script 1". This is the correct output of script 1
9. Now, imagine a user edits the DESTINATION. For example, let's say she makes the changes in red shown on the sheet "Examples of a data Update"
10. Script 2 should update the data in the SOURCE per this update.
11. Go back to the first workbook (Source). Notice the tab: "Correct Output: Script 2". This is the correct output of script 2.
NOTE: For step 11, assume that ColumnA represents a unique value (like a PRIMARY KEY). Update rows based on that value. DO NOT assume that the rows are in the same places because someone may sort the source data, changing the position of the rows.
NOTE: I'm pretty sure I can deploy the scripts once you write them, but I may need a bit of help to get them running the first time.
All bids below $250 will be considered
Specific technologies required: Google Apps Scripts
Extra notes:
Description of requirements/functionality: Hello,
I need 2 scripts written for a Google Sheet.
Script 1: Copies data from one Google Sheet (source) into another (destination)
Script 2: When cells are updated in one sheet (destination) then the equivalent cell is updated (source)
To understand the details more fully,
1. Open this Workbook:
https://docs.google.com/spreadsheets/d/1Wmx0sMqyLU5rX1pRKu-1mY4-VRse904hg3Z4K_VsTE4/edit#gid=0
2. Review the data on the sheet: "Input 1:Source Data"
3. Open this workbook: https://docs.google.com/spreadsheets/d/1zjI5yMJ2sweeCcsFvhTe1DZH6aBMXP29bnb_kcaEuMU/edit#gid=1326970169
4. Review the data on the sheet: "Input 2: Destination"
5. Notice the condition in cell A1: K="LV" -- This means that Script 1 should only pull data from the source where column K="LV" (the condition will always be in cell A1)
6. Notice the columns. Only SOME of the columns from the "Source" are in the "Destination". Only these columns should be populated.
7. Script 1 should pull the data from the SOURCE and populate the DESTINATION:
8. Notice the tab: "Correct Output: Script 1". This is the correct output of script 1
9. Now, imagine a user edits the DESTINATION. For example, let's say she makes the changes in red shown on the sheet "Examples of a data Update"
10. Script 2 should update the data in the SOURCE per this update.
11. Go back to the first workbook (Source). Notice the tab: "Correct Output: Script 2". This is the correct output of script 2.
NOTE: For step 11, assume that ColumnA represents a unique value (like a PRIMARY KEY). Update rows based on that value. DO NOT assume that the rows are in the same places because someone may sort the source data, changing the position of the rows.
NOTE: I'm pretty sure I can deploy the scripts once you write them, but I may need a bit of help to get them running the first time.
All bids below $250 will be considered
Specific technologies required: Google Apps Scripts
Extra notes:
Jonathan E.
100% (37)Projects Completed
42
Freelancers worked with
30
Projects awarded
62%
Last project
6 Jul 2017
United States
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