Find Jobs
Hire Freelancers

Google App Script (GAS) for Google Sheet link to google form

$30-250 USD

Mbyllur
Postuar over 6 years ago

$30-250 USD

Paguhet në dorëzim
HI freelancer, Basically, I am after a GAS to 1. Auto Copy data for SELECTED Column from 'Form Responses 1' which are column C,E & F to other tab called 'COPY DATA' into column A,B,C (Maybe OnChange Trigger or Ontime Trigger- maybe checking every minutes?) when google form response is submitted. 2. The nature of the data to be copied to 'COPY DATA' tab is like a 'stamp'/data log. That means it is a one way data transfer from the 'Form Responses1' tab to 'COPY DATA' tab. 3. If in case column (A,B,C) from the 'COPY DATA' Tab is edited manually, it won't change the original google response sheet data (Form Response 1). (One way data transfer) 4. The way how the data for selected column to be copied from tab 'Form Response 1' to 'COPY DATA' is ROW by ROW. Its kind like a google form submission nature. You may set few conditions before the copy function data to be copied ; - Checking empty space in COPY DATA tab - Ensure to only copy new rows if new timestamp from 'Form responses 1' tab entered I think for this script, the trigger is not onEdit, but MUST be OnChange (most preferable) or OnTime (Checking every 1 minutes) trigger This is just dummy data anyway. Could you please write a very understanding google app script (GAS) in which I am expecting a quite detail explanation/comments where appropriate such as WHERE TO ADD OR CHANGE in the script so that later on I am easily able to add more column inclusion for 'COPY DATA' tab' in the future. Here is the sheet and google form submission Online google form [login to view URL] Google Form Response https://docs.google.com/spreadsheets/d/1NrU389iwrtJhQ_reep4kBJVAPsZPLxoXmSoxt4CMKco/edit#gid=1664056787 Thank you
ID e Projektit: 15839200

Rreth projektit

4 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
4 freelancers are bidding on average $183 USD for this job
Avatari i Përdoruesit
HI, I am good at Google scripts and Google formulas. I have referred the project description. I would like to discuss in detail in the chat to get the full scope of work. Looking forward to work Relevant Skills and Experience Google sheets, Google scripts Proposed Milestones $400 USD - Milestone
$400 USD në 7 ditë
4,9 (8 përshtypje)
4,1
4,1
Avatari i Përdoruesit
NO COPY PASTE BID LIKE OTHER SELLERS... !!! Please Read My Proposal For One Time !!!! I am having 6+ years of experience In This kind of Project. I Have Recently Completed Similar Project.. Relevant Skills and Experience NO COPY PASTE BID LIKE OTHER SELLERS... !!! Please Read My Proposal For One Time !!!! I am having 6+ years of experience In This kind of Project. I Have Recently Completed Similar Project.. Proposed Milestones $155 USD - .
$155 USD në 3 ditë
5,0 (3 përshtypje)
3,7
3,7

Rreth klientit

Flamuri i AUSTRALIA
REDFERN, Australia
0,0
0
Anëtar që nga korr 23, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.