Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onFormSubmit(e) {
- var random = Math.floor((Math.random() * 10000000000));
- var lock = LockService.getPublicLock();
- lock.waitLock(30000);
- var sheet = SpreadsheetApp.openById('******************************').getSheetByName('testing (Responses)');
- var range = sheet.getRange(sheet.getLastRow(),3);
- range.setValue(random);
- var data = sheet.getRange(sheet.getLastRow(),2).getValue();
- lock.releaseLock();
- }
Add Comment
Please, Sign In to add comment