 | Dan Liebeschutz |
Explanation video [HE]
Usually the two methods are used together to achieve the effects of improving the general djpaulkom.tv order cheap viagra condition of the animal to determine the best possible treatment. You will see the improvement within few weeks after using these capsules. generic levitra online We looked to the Asian culture that have been eating it for a very long time. Read Full Report cialis 10 mg Erectile dysfunction cheap pfizer viagra is becoming increasingly common among men of aged 30 to 40.Script
function addToUsers(event) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = event.source.getActiveSheet();
var r = event.source.getActiveRange();
Logger.log(s.getName());
Logger.log(r.getValue());
Logger.log(r.getColumn());
du = findDuplicate(s);
Logger.log('du is '+ du);
if(s.getName() == "App: Logins" && r.getColumn() == 1.0 && r.isBlank() == false && du == false) {
Logger.log('If true');
var row = r.getRow();
Logger.log(r.getRow());
var targetSheet = ss.getSheetByName("users");
Logger.log(targetSheet.name);
Logger.log(targetSheet.getLastRow());
var target2 = targetSheet.getRange(targetSheet.getLastRow() + 1, 2);
var target3 = targetSheet.getRange(targetSheet.getLastRow() + 1, 3);
s.getRange(row,2).copyTo(target2);
s.getRange(row,1).copyTo(target3);
}
else { Logger.log('If false');}
}
function findDuplicate(s)
{
var lastRow=s.getLastRow();
Logger.log('last row '+ s.getLastRow())
var rg=s.getRange(2, 2, lastRow-1, 1);
var vA=rg.getValues();
var d = false;
for(var i=0;i<lastRow-2;i++)
{ Logger.log(vA[i][0])
Logger.log(vA[lastRow-2][0])
if(vA[i][0]==vA[lastRow-2][0])
{
d = true;
Logger.log('d is '+ d)
return d;
break;
}
else
{ d = false;}
}
Logger.log('final d is '+ d)
return d;
}