conditional copy between sheets google docs spreadsheets

Posted by user1891545 on Stack Overflow See other posts from Stack Overflow or by user1891545
Published on 2012-12-10T12:26:51Z Indexed on 2012/12/10 17:03 UTC
Read the original article Hit count: 174

Filed under:

google-spreadsheet

|

google-spreadsheet-api

|

google-docs-script

I have this situation:

1 spreadsheet with another 8 sheets

The sheet1 have 16 column fill from a web form, so when the people fill in its created a new row.

So i want create a script which read the rows and copy determined data column from this row in the specifics sheets

A B C D E F G H I J K L M N O P

1 X X X X X X X X X X X X X X X X

SHEET1 SHEET(F) SHEET(G) SHEET(H) SHEET4(I)...

If theres some data in column E copy column A, column B, column C, column E, from sheet1 to last row sheet E also if theres no data on column E do nothing and continues If theres some data in column F copy column A, column B, column C, column F, from sheet1 to last row sheet F also if theres no data on column F do nothing and continues ....

Also I want know if is possible launch this script with function onSubmitForm() so as the row is insert automatically run the script and clasify the datas between the sheets.

© Stack Overflow or respective owner

Related posts about google-spreadsheet

Run Google-apps-script on Google-Spreadsheet event?

as seen on Stack Overflow - Search for 'Stack Overflow'
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don't know if Google spreadsheet supports any events. For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way… >>> More
Google Spreadsheet multiple column filter using OR

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Google Spreadsheet with 3 columns which are either blank or have a value. I want to get the count of the number of rows that has A and either B or C populated. If I were writing a SQL query it would be select count(*) from Table where A is not null and (B is not null or C is not null) But… >>> More
Google Apps Script - Sending Google Spreadsheet Row to Email

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to write a script using Google Apps Script (Javascript) for a Google spreadsheet. I am trying to do the same thing that is shown in this tutorial [http://www.google.com/google-d-s/scripts/sending_emails.html][1], but each row in my spreadsheet has 24 columns. I would like to send… >>> More
Using Google Spreadsheet API on Blackberry

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a Google spreadsheet synchronization feature on a blackberry application that I am building. Not being a pro I was hunting for some sample code to get a grasp of the flow but I could not. When I am using the API from Google to access spreadsheets, it suggests to use the SpreadsheetService… >>> More
Where is the script editor in google spreadsheet?

as seen on Super User - Search for 'Super User'
Hello I just stumbled upon this link and wanted to try it out. Yet, if I open a google spreadsheet, I have no scripts submenu under the tools menu. This was with firefox 3.0.15 and IE 7. Unfortunately, I didn't find anything that indicated why there wouldn't be such menus with my spreadsheets. Does… >>> More

Related posts about google-spreadsheet-api

google spreadsheet api from android: google-api-java-client or handmade?

as seen on Stack Overflow - Search for 'Stack Overflow'
For working with google spreadsheet api from android (2.2) - google suggests using google-api-java-client for android. For that you have to include 5 jars to your android application: guava-r09.jar google-http-client-extensions-android2-1.6.0-beta.jar google-api-client-extensions-android2-1.6.0-beta… >>> More
Using Google Spreadsheet API on Blackberry

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a Google spreadsheet synchronization feature on a blackberry application that I am building. Not being a pro I was hunting for some sample code to get a grasp of the flow but I could not. When I am using the API from Google to access spreadsheets, it suggests to use the SpreadsheetService… >>> More
Can't connect in C# and google spreadsheet api

as seen on Stack Overflow - Search for 'Stack Overflow'
Trying to access google spreadsheets using their api. following their example, the code doesnt work, and its not obvious why. All I'm trying to do is to connect, and I keep getting back the same error. This is with their code set as of 4/15/10. Can anyone offer any suggestion on what I'm doing… >>> More
Google Spreadsheet API problem: memory exceeded

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, Don't know if anyone has experience with the Google Spreadsheets API or the Zend_GData classes but it's worth a go: When I try to insert a value in a 750 row spreadsheet, it takes ages and then throws an error that my memory limit (which is 128 MB!) was exceeded. I also got this when querying… >>> More
Google SpreadSheets - When using a time trigger in code, some cells getting '#N/A' value

as seen on Stack Overflow - Search for 'Stack Overflow'
I've created a Google spreadsheet with imported data on one cell, extracting specific string to another cell and pasting the data in a table with a trigger for every 2 hours. Now everything works perfectly when running the script manually but when logged out and waiting for the cells to fill, sometimes… >>> More