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

Tämä projekti sai 6 tarjousta lahjakkailta freelancereilta ja sen keskivertotarjous oli %project_bid_stats_avg_sub_45% %project_currencyDetails_sign_sub_46% (USD) .

Pyydä ilmaisia tarjouksia samanlaisesta projektista
Projektin budjetti
$30 - $250 USD
Huutoja yhteensä
Projektin kuvaus

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

[url removed, login to view]

Google Form Response

Thank you

Vaaditut taidot

Haluatko ansaita rahaa?

  • Aseta budjettisi ja määräaika
  • Hahmottele tarjouksesi
  • Saa maksu työstäsi

Palkkaa freelancereita, jotka tekivät myös tarjouksen tästä projektista

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online