Profile

Cover photo
Eric Koleda
Works at Google
Attended Colgate University
Lived in Brooklyn, NY
4,332 followers|1,507,677 views
AboutPostsPhotosYouTube

Stream

Eric Koleda

Shared publicly  - 
 
A really fantastic introduction to Apps Script and add-ons for beginners.
15
8
Игорь Белозеров's profile photoMats Nilson's profile photoAndrew Stillman's profile photoMarisa Peters's profile photo
2 comments
 
Learning to create an Add-on is just a matter of copying and pasting Google's code!  Hurray;)
Add a comment...

Eric Koleda

Shared publicly  - 
 
An interesting take on how you can use Google Apps consumer products to beta-test new features in your application. Prove the concept works using Form, Sheets, and email, and then spend the effort to build it into your product.
4
1
Václav VESELÝ's profile photoRory O Connor's profile photo
 
We use to say in #netmail that you can mockup fast with sheets, gmail and apps script. The platform is perfect for proofs of concept.
Add a comment...

Eric Koleda
moderator

Tips & tricks  - 
 
Updates to HtmlService Best Practices

We've made a few updates to the HtmlService Best Practices. Notably:

- Use IFRAME sandboxing. It's pretty amazing.
- Load resources over HTTPS. The IFRAME sandbox gets sad if you don't.
- Set the HTML5 DOCTYPE. Without it you'll be in quirks mode, and your page will look funny.
- Start using <html>, <head>, and <body> tags again. With Caja out of the picture we can go back to writing normal HTML.
25
4
Steve Webster's profile photoJose Luis Garcia's profile photoJose Alzueta Mancoeduca's profile photo김진달's profile photo
23 comments
 
If you look closely, that best practice only applies to pages that use Caja.
Add a comment...

Eric Koleda
moderator

Announcements  - 
 
This is not the community you're looking for

If you have questions or comments about using Google Drive the product, then you want to do to the Google Docs and Drive community linked below. This community is intended for software developers that use the Drive SDK and APIs. 
Google Docs and Drive
The largest unofficial community for discussion of Google Docs and Drive.
View community
25
3
Ziggy Dziegman's profile photoVonVictor Valentino Rosenchild's profile phototufan kamrani's profile photoNazie Ganjavian's profile photo
 
Thanks for plugging us :)
Add a comment...

Eric Koleda

Shared publicly  - 
 
ScriptDB Going Read-Only Tomorrow

ScriptDB was officially shut down on November 20th, but we decided to wait until after Thanksgiving to pull the plug. We're going to start by making the service read-only tomorrow, perhaps for a couple of hours to start but eventually permanently. This should help ferret out any places you are still using the service and give you time to export your data.

If you know you are still relying on ScriptDB now is the time migrate to another storage solution. Apps Script provides native support for connecting to SQL databases (including Google Cloud SQL) and with UrlFetchApp you can connect to a variety of other NoSQL providers.
Back in May, we announced that ScriptDB, an experimental database in Google Apps Script, would be turned off on November 20, 2014. Hopefully you've already migrated your data to another database, but if not, now is the time to check out alternatives like Cloud SQL. The migration guide explains ...
7
3
Steve Webster's profile photoAlex Dobrov's profile photo
Add a comment...
 
Welcome Google Forms to the world of add-ons!
 
Just like with Docs and Sheets, you can now use add-ons for Forms to add handy new features to your surveys, like setting a survey end date, sending custom emails based on responses, storing lists of choices that you frequently add to questions, and more. 
52 comments on original post
13
Add a comment...
Have him in circles
4,332 people
Martin van Beurden's profile photo
Hasan Morshed's profile photo
Antonino Caternicchia's profile photo
Tedj MEABIOU's profile photo
Code Maesters's profile photo
Dragos Ionescu's profile photo
Billy Chang's profile photo
Joshuha Owen's profile photo
STEFF EVANS's profile photo

Eric Koleda

Shared publicly  - 
 
There are a wide variety of APIs and developer tools available for Google Apps, but the landscape can be hard to navigate sometimes. To help with this, we've published a page that maps consumer Google Apps products to their corresponding developer offerings. Let us know if you find it useful!
32
3
Steve Webster's profile photoJean-Rémi Delteil's profile photoRichard Burgess's profile photoHans Sébastien's profile photo
5 comments
 
I'm interested in "mobile" and "offline" first methods, then desktop to online for my clients. Any guidance documentation would be much appreciated.

I'm thinking, Polymer, Chrome App, Chrome Storage API, Apps Script web app or content service. If one solution is not possible, then maybe two UI instances: one for mobile offline (Polymer, Chrome App, Chrome Storage API), and one for desktop (Apps Script with HTML Servivce IFRAME) where a common datastore exist.
Add a comment...

Eric Koleda

Shared publicly  - 
 
Way overdue, perhaps to the point of being irrelevant, I've finally gotten around to publishing the source code for Feed+ and ParseDb:

- https://github.com/erickoledadevrel/feed-plus
https://github.com/erickoledadevrel/parsedb
feed-plus - A sample web application, built using Apps Script, that makes an RSS feed from a Google+ feed.
16
Michael-Rainabba Richardson's profile photoAhmet Ahmet's profile photo
2 comments
 
please make contact to pass for help with some associated with the old URLs
Add a comment...
 
HtmlService no longer requires Caja, UiApp deprecated

Today we launched a new sandbox mode for HtmlService: IFRAME. It uses a even newer sandboxing technology built into modern browsers that places FAR fewer restrictions on your JavaScript, and runs MUCH faster.

We've also decided to officially end support for UiApp. Although it was a handy way to quickly spin up UIs, we believe that giving developers the full power of the web will allow you all to innovate and create high-quality add-ons.
Apps Script's HTML service is a great way to easily build user interfaces for Docs, Sheets, and Forms add-ons. However, HTML service is S-L-O-W. And until today there have been quite a few restrictions on using HTML service, including the inability to use a variety of JavaScript libraries.
36
17
David Cifuentes's profile photoJean-Rémi Delteil's profile photoStuart Keeble's profile photoEiju ISHII's profile photo
10 comments
 
Also some static hosting of the polymer files would be really convenient. Maybe on Google's Hosted Libraries? I see the author has hosted their own at http://polymerstaticfiles.appspot.com
Add a comment...

Eric Koleda
moderator

News  - 
 
 
ScriptDB Going Read-Only Tomorrow

ScriptDB was officially shut down on November 20th, but we decided to wait until after Thanksgiving to pull the plug. We're going to start by making the service read-only tomorrow, perhaps for a couple of hours to start but eventually permanently. This should help ferret out any places you are still using the service and give you time to export your data.

If you know you are still relying on ScriptDB now is the time migrate to another storage solution. Apps Script provides native support for connecting to SQL databases (including Google Cloud SQL) and with UrlFetchApp you can connect to a variety of other NoSQL providers.
Back in May, we announced that ScriptDB, an experimental database in Google Apps Script, would be turned off on November 20, 2014. Hopefully you've already migrated your data to another database, but if not, now is the time to check out alternatives like Cloud SQL. The migration guide explains ...
View original post
3
1
Faustino Rodriguez's profile photoAlex Dobrov's profile photo
 
bye bye ScriptDB, we'll miss you
Add a comment...

Eric Koleda

Shared publicly  - 
 
Finally got around to publishing an add-on of my own: Crop Sheet. I'm a bit of neat freak when it comes to spreadsheets, and tens of empty columns and hundreds of empty rows always kind of bugged me. With a couple clicks you can crop your sheet to just the part that has data in it. The code is open source and hosted on GitHub: https://github.com/erickoledadevrel/crop-sheet/blob/master/Code.js
Provides the ability to quickly remove extra rows and columns from a sheet.
39
9
Saurabh Gupta's profile photoTrevor Beck's profile photoPéter Erben's profile photoJonathan Beri's profile photo
6 comments
 
Useful, small, elegant. Well done!
Add a comment...

Eric Koleda
moderator

News  - 
 
 
Time-based triggers now in Add-ons

A few weeks ago we announced in a blog post (http://goo.gl/Js3mEH) that add-ons could start using triggers, and those of you with a keen eye may have noticed that time-based triggers were missing from the list. It took a couple of extra days to get those working right, but we're happy to announce that time-based triggers can now be used as well.

Be aware that time-based triggers in add-ons behave differently than those in regular scripts. Most notably, they can only fire at most once an hour. Take a look at our trigger documentation for the full list of caveats.
View original post
8
Add a comment...
People
Have him in circles
4,332 people
Martin van Beurden's profile photo
Hasan Morshed's profile photo
Antonino Caternicchia's profile photo
Tedj MEABIOU's profile photo
Code Maesters's profile photo
Dragos Ionescu's profile photo
Billy Chang's profile photo
Joshuha Owen's profile photo
STEFF EVANS's profile photo
Education
  • Colgate University
    Computer Science, 2001 - 2005
Basic Information
Gender
Male
Story
Tagline
Member of the Developer Relations team at Google.
Introduction

I am a Developer Programs Engineer working primarily on Google Apps Script.

Work
Occupation
Developer Programs Engineer
Employment
  • Google
    Developer Programs Engineer, 2009 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Brooklyn, NY