Guest User

Untitled

a guest
Jul 23rd, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. function onFormSubmit(e) {
  2.  
  3. var random = Math.floor((Math.random() * 10000000000));
  4. var lock = LockService.getPublicLock();
  5. lock.waitLock(30000);
  6.  
  7. var sheet = SpreadsheetApp.openById('******************************').getSheetByName('testing (Responses)');
  8. var range = sheet.getRange(sheet.getLastRow(),3);
  9. range.setValue(random);
  10.  
  11. var data = sheet.getRange(sheet.getLastRow(),2).getValue();
  12.  
  13. lock.releaseLock();
  14.  
  15. }
Add Comment
Please, Sign In to add comment