How to pause App Scripts until spreadsheet finishes calculation

by

Here is a very simple way of preventing the next script from starting until the current script completes in google apps scripts. Just add a call for testWait() after each script you are processing successively. The SpreadsheetApp.flush() also seems to reset the timeout timer on the spreadsheet back to the default 5min so you have more time to process multiple scripts in one go. 

//holds processing of next script till last one has completed
function testWait(){
  var lock = LockService.getScriptLock(); lock.waitLock(300000); 
  SpreadsheetApp.flush(); lock.releaseLock();
}

More Related Contents:

  1. Determining the last row in a single column
  2. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  3. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  4. Google Sheets OnEdit() – You do not have permission to call a service
  5. Detect user inserting row or column in a google spreadsheet and reacting in a script
  6. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  7. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  8. Google app scripts: email a spreadsheet as excel
  9. Moving Files In Google Drive Using Google Script
  10. How to get onFormSubmit to trigger automatically?
  11. Copying a spreadsheet copies all linked files as well
  12. onEdit simple trigger never seems to be triggered
  13. “SpreadsheetApp.getUi() cannot be called from this context”
  14. Using built-in spreadsheet functions in a script
  15. Protect ranges with google apps script
  16. How to access new ‘in-cell-image’ from google apps script?
  17. How to convert a Google Sheets-File to an Excel-File (XLSX)
  18. Difference between getValue() and getDisplayValue() on google app script
  19. Dynamically creating spreadsheet menu items
  20. Creating and Sending sheets in the same function
  21. How do I know if spreadsheet cells are merged using google apps script
  22. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  23. How to ignore empty cell values for getRange().getValues()
  24. Google apps script error: “You do not have permission to call protect” [duplicate]
  25. Use script in all spreadsheets
  26. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment