Sedang Disiapkan

Google Sheet Script to Copy one row from one sheet to another sheet

Here is a simple project for those who master javascript and google spreadsheet! We are looking for someone with skills in google sheet for different script we are building for our project so if you are good on this one we will have plenty of contracts for you!

So here is the challenge. We use a script below to erease the old row in the "archive" sheet but we want to copy thoses same row on a new sheet that we name "target" ant that it add the row at the end of the target spreadsheet

So we want a version of the script below that allow to copy a row form googlesheet1 (Archive) to googlesheet2 (target)

here is the script:

function myFunction() {

var ss = [url removed, login to view]();

var sheet = [url removed, login to view]("Archive");

var datarange = [url removed, login to view]();

var lastrow = [url removed, login to view]();

var values = [url removed, login to view]();// get all data in a 2D array

var currentDate = new Date();

var oneweekago = new Date();

[url removed, login to view]([url removed, login to view]() - 2);

for (i=lastrow;i>=2;i--) {

var tempdate = values[i-1][1];// arrays are 0 indexed so row1 = values[0] and col2 = [1]

if(tempdate < oneweekago)

{

[url removed, login to view](i);

}

}

}

Kemahiran: Excel, Javascript

Lihat lebih lanjut: google sheets copy row to another sheet based on cell value, google script copy data from one sheet to another, google spreadsheet script copy paste values, google script copy row, target range and source range must be on the same spreadsheet, google script copyto, google script copy range to another spreadsheet, google spreadsheet copy row to another sheet, Google Sheet Script, copy format sheet script task, google sheet script print, script task copy excel sheet, excel script copy sheet, script copy excel sheet, function copy picture sheet anather sheet vba excel

Tentang Majikan:
( 62 ulasan ) Quebec, Canada

ID Projek: #15880385

Dianugerahkan kepada:

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$30 USD dalam sehari
(173 Ulasan)
6.7

8 pekerja bebas membida secara purata $43 untuk pekerjaan ini

schoudhary1553

Greeting, I have understood your Google Sheet Script to Copy one row from one sheet to another sheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years o Lagi

$30 USD dalam sehari
(209 Ulasan)
7.2
shihan033010

Hi I can solve the issue that you mentioned. Please accept the bid and create the milestone.

$30 USD dalam sehari
(94 Ulasan)
5.6
ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Thank you fo Lagi

$19 USD dalam 4 hari
(23 Ulasan)
4.5
mohamedkaram93

Hi there, I will be happy to help you with that. I have checked your attached script. RIght now, you are trying to delete the rows that have a timestamp older than 2 days "from the script runtime moment" from the "A Lagi

$30 USD dalam 0 hari
(19 Ulasan)
4.2
meeshal1994

Hello, Message me so that I can understand​ your requirements in detail. Thanks

$15 USD dalam sehari
(10 Ulasan)
3.8
ashishonmobile

I have worked on many google sheet script and used below features of sheet. 1) Email Sending 2) Calendar Integration 3) MYSQL Database Connection. 4) Automation 5) Manipulating Various Google Sheet based on Busi Lagi

$25 USD dalam sehari
(1 Ulasan)
2.6
softtronicstech

I can solve it. But can you please tell me about the next task. I will do the other task too for the current price. let us discuss. added 3rd party api to googlesheets [url removed, login to view] Lagi

$166 USD dalam 3 hari
(1 Ulasan)
2.3