Global variables in Google Script (spreadsheet)

by

You won’t like this: global variables in GAS are static – you can’t update them and expect them to retain their values. I, too, googled this for hours.

You can use CacheService or ScriptDB as possible storage for this sort of problem. CacheService is quick and easy to use, but limited because the cache will expire eventually. I haven’t tried ScriptDB

More Related Contents:

  1. Declaring variables without var keyword
  2. Effect of declared and undeclared variables
  3. Get all Javascript Variables?
  4. What is the quickest way to subtract a variable from a number and set the variable?
  5. Node.js bug ? function’s return value change when stored as variable
  6. Pass variables by reference in JavaScript
  7. How can I unset a JavaScript variable?
  8. Are Variable Operators Possible?
  9. Convert column index into corresponding column letter
  10. Multiple left-hand assignment with JavaScript
  11. Calling a JavaScript function named in a variable [duplicate]
  12. How to swap two variables in JavaScript
  13. Why a variable defined global is undefined? [duplicate]
  14. Google Spreadsheet Script – How to Transpose / Rotate Multi-dimensional Array?
  15. How to copy a row from one google spreadsheet to another google spreadsheet using google apps script?
  16. Emailing Google Sheet range (with or without formatting) as a HTML table in a Gmail message
  17. Global variables for node.js standard modules?
  18. Access variable outside function scope [duplicate]
  19. jQuery ajax return value [duplicate]
  20. How to load javascript from external source and execute it in Google Apps Script
  21. Synchronize independent spreadsheet rows, filled by IMPORTRANGE()
  22. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  23. How to fix ‘TypeError: Cannot call method “getRange” of null’ in Google Apps Script
  24. Javascript date variable assignment
  25. Use JavaScript variable as function name?
  26. What is the best way to parse html in google apps script
  27. Add content of showModalDialog() to the clipboard Google Script
  28. Using base64-encoded images with HtmlService in Apps Script
  29. Add timestamp to named column in Google Spreadsheet onEdit script
  30. Converting Google spreadsheet date into a JS Date object?

Leave a Comment