I would like to know which way it defines first 5 columns from the sheets.
What it does is if Date is today's date or if sheet contains past date then
it should move to archieve sheet. Now I am confused which way it defines
that it should move only 5 rows.
function movethisRowToArchieve(rowIndexToMove)
{
archieveSheet.insertRows(2, 1);
// The code below will copy the first 5 columns over to the 6th column
var rangeToCopy = sabhaPlanningSheet.getRange(rowIndexToMove, 1, 1, 20); //
"K1:K20"
rangeToCopy.copyTo(archieveSheet.getRange(2, 1));
//Now delete the original row (Which is old) in Plannig sheet
planningSheet.deleteRow(rowIndexToMove);
}
Can anyone help me out here? And how to change if I have more than 5 rows
for past date or current date. Where to change the syntax. I know copyTo
function copies in descending order.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
