fromSitePoint Forums | Web Development & Design Community
2 months agoTrying to create a honeypot spam filter in google apps script
function deleteSpamRows() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("leads"); var data = sheet.getDataRange().getValues(); var rowsToDelete = []; for (var i = 1; i < data.length; i++) { var row = data[i]; var honeypotValue = row[3]; if (honeypotValue != "") { rowsToDelete.push(i + 1); } } for (var i = rowsToDelete.length - 1; i >= 0; i--) { sheet.deleteRow(rowsToDelete[i]); } }