Advertisement
Guest User

GForm limit

a guest
Feb 22nd, 2018
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. function calculateTodayReservedSeats() {
  2. var msg = "We're sorry, the event is full.";
  3. var ss = SpreadsheetApp.openById('1W3YYzxCnefXsdY3lV99q7Pm3KWWt7Ef-Oiq9mG9oM9k');
  4. var sheet = ss.getSheetByName('Responses');
  5. var lastRow = sheet.getLastRow();
  6. var person1 = sheet.getRange(2, 3, lastRow - 1, 1).getValues();
  7. var person2 = sheet.getRange(2, 4, lastRow - 1, 1).getValues();
  8. var i, count;
  9. for (i = 0; i < person1.length; i++) {
  10. count += person1[i][0];
  11. count += person2[i][0];
  12. }
  13.  
  14. if (count > 60) {
  15. form.setAcceptingResponses(false).setCustomClosedFormMessage(msg);
  16. }
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement