How to understand LockService and implement it correctly?

by

In the above pseudo code, once the script doesn’t get a lock it will still proceed to run the code. Is that the intended behavior? It is a better practice or option to throw a server busy message to the user.
Like so:

var active_spreadsheet = SpreadsheetApp.openById("bbb");

// BEGIN - start lock here

var lock = LockService.getScriptLock();
try {
    lock.waitLock(30000); // wait 30 seconds for others' use of the code section and lock to stop and then proceed
} catch (e) {
    Logger.log('Could not obtain lock after 30 seconds.');
    return HtmlService.createHtmlOutput("<b> Server Busy please try after some time <p>")
    // In case this a server side code called asynchronously you return a error code and display the appropriate message on the client side
    return "Error: Server busy try again later... Sorry :("
}

// note:  if return is run in the catch block above the following will not run as the function will be exited

var active_sheet = active_spreadsheet.getSheetByName("ENTRIES");
var new_start_row = active_sheet.getLastRow() + 1;

//  Do lots of stuff - ie apply dynamic background colors based on previous entries colors, define the target range and set values, set data validations  

SpreadsheetApp.flush(); // applies all pending spreadsheet changes
lock.releaseLock();

// END - end lock here

return;

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  3. No permission to call msgBox in Google Apps Scripting
  4. Custom functions intermittently hang with “Error – Loading Data”
  5. How can I generate a multipage text document from a single page template in google-apps-script?
  6. Navigating embedded Google Apps Script iFrame from the parent
  7. How do I add formulas to Google Sheets using Google Apps Script?
  8. Deleting rows in google sheets using Google Apps Script
  9. Dynamically edit multiple choice options in live Google Form using Apps Script
  10. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  11. Google apps script to email google spreadsheet excel version [duplicate]
  12. Why does google script editor stop paren matching after 100 lines in a function and does it affect the code?
  13. Run javascript as the form is being filled by users
  14. A Script to Simplify Creating a SO Table
  15. How to use a google apps script in multiple documents
  16. Initiate a download from google apps script
  17. Call a function from external URL
  18. Measurement of execution time of built-in functions for Spreadsheet
  19. Google Spreadheets Scripts: check if cell is empty
  20. Custom Functions with add-ons?
  21. Line break in a message
  22. How do I create a file in a folder?
  23. How to prefill Google form checkboxes?
  24. Converting .xls to google spreadsheet in google apps script
  25. Shuffle answer properties
  26. publish a Google Spreadsheet through Google Apps Scripts
  27. Google spreadsheet “Cannot call method “getRange” of null”
  28. Web scraping with Google Apps Script
  29. Converting string to web-safe Base64 format
  30. Unreachable Service – appsactivity

Leave a Comment