Here's another app built with the DataHandler. This time it's actually a VBA app that accesses Google Sheets (and any other database for which there is a driver) via the DataHandler REST API Using this you can read, write and query Google Sheets directly from your VBA code.
Using this you can read, write and query Google Sheets directly from your VBA code.
with drivers for parse.com, scriptdb and sheets - more on the way.
Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain.
learned last week that I had been bestowed the honor of membership of the Google Developer Experts (GDE) program.
It's a great feeling to have your work recognised in this way, even though I do feel a little out of place in the company of the august group who make up the current GDE community. GDEs are a small, but enthusiastic group who share a passion for the family of Google APIs and products, and give generously of their time to share their knowledge and ideas with others.
When I started toying with Google Apps Script a couple of years ago I never imagined it would develop such great capability - if you are not familiar with the new add-ons, for example, take a look to see just how far it has come.
I'm planning to continue to search out interesting (and even useful) things to do with Apps Script and other APIS, and I hope you will continue to find this blog and related site, and the various other channels of some help in your journey to the cloud.
Here's a Google Apps Script version of SunCalc. There's a library to include in projects, and a webapp to provide rest query responses. It calculates things like sunrise, sunset and so on given a location and a date. Created from Vladimir Agafonkin's https://github.com/mourner/suncalc.
Before Tableau I had a passion for Excel. I loved it because it was a canvas where almost anything was possible. To prove it, I set out to make one of my favorite games in it...Monopoly. It was pretty challenging and I never ...
Google brings Chrome OS straight into Windows 8 in latest... The Verge Just like Google's full Chrome OS, you can create multiple browser windows and arrange them using a snap to the left or right of the display or full-screen modes.