Graduate to a database

If you followed Do something useful with GAS in 5 minutes, you'll already know how to use a spreadsheet as a database. You may want to move on to using a real database as a back end. Luckily, using Database abstraction with google apps script it's just a matter of connecting to a different backend. Everything else is the same. Here's how to migrate, using as the example back end.

do something in 5 with gas-2-graduate to a database

For more snippets like this see Google Apps Scripts snippets
For help and more information join our forum,follow the blog or follow me on twitter .

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.