Advertisement
Guest User

Untitled

a guest
Oct 7th, 2015
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. function automateRestrictSpam()
  2. {
  3. //alert("restricting spam");
  4. var sss = SpreadsheetApp.getActiveSpreadsheet();
  5. SpreadsheetApp.getUi().alert("restricting spam");
  6. var form = sss.getSheetByName("form2");
  7.  
  8. var range = form.getRange(1,3,form.getLastRow(),1);
  9. var lastEntry = range.getCell(form.getLastRow(),1).getValue();
  10. var data = form.getRange(1,3,form.getLastRow()-1,1).getValues();
  11. for (var i = 0; i < data.length; i++)
  12. {
  13. var row = data[i];
  14. var entry = row[0];
  15. if (entry == lastEntry)
  16. {
  17.  
  18. form.getRange(form.getLastRow(),1,1,form.getLastColumn()).clear();
  19. break;
  20. }
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement