Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function automateRestrictSpam()
- {
- //alert("restricting spam");
- var sss = SpreadsheetApp.getActiveSpreadsheet();
- SpreadsheetApp.getUi().alert("restricting spam");
- var form = sss.getSheetByName("form2");
- var range = form.getRange(1,3,form.getLastRow(),1);
- var lastEntry = range.getCell(form.getLastRow(),1).getValue();
- var data = form.getRange(1,3,form.getLastRow()-1,1).getValues();
- for (var i = 0; i < data.length; i++)
- {
- var row = data[i];
- var entry = row[0];
- if (entry == lastEntry)
- {
- form.getRange(form.getLastRow(),1,1,form.getLastColumn()).clear();
- break;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement