Join Scott Simpson for an in-depth discussion in this video Storing data for your script, part of Up and Running with Google Apps Script (2013).
- View Offline
So chances are your script will need to have some data…that doesn't exist within the documents or services you're working with.…Sure you can set up a spreadsheet to store settings, lookup's and things like that.…But it's a hack at best and you definitely wouldn't want…to do that in a script you plan to share with others.…So Google provides three ways of storing data for your application.…Script properties, ScriptDB and JDBC.…First lets take a quick look at script properties.…These are very…basic key-value pairs of strings. And they're stored on a per script basis.…Each property has a max size of nine kilobytes.…
And the total size limit is 500 kilobytes.…The end design for heavy volume.…So Google recommends that they be used for things like configuration settings.…I can define some properties by sending a simple object…to the set properties method or the script properties class.…And…then I can get the information back out with the getProperty method.…Here, I am using the present desk notation for string variables…
- What is Google Apps Script?
- Creating and editing files with Apps Services
- Storing data for your script
- Using events and triggers in containers
- Building custom spreadsheet functions
- Sharing your script as a web app
- Serving JSON or XML from your script
- Publishing your app in the Chrome Web Store