Profile

Cover photo
Eric Koleda
Works at Google
Attended Colgate University
Lived in Brooklyn, NY
4,056 followers|1,021,832 views
AboutPostsPhotosYouTube

Stream

Eric Koleda
moderator

Tips & tricks  - 
 
Just found out that power-user +Bryan Patterson runs a series of Helpouts for Apps Script. Way to go Bryan! I love seeing the Apps Script community helping each other.
9
Bryan Patterson's profile photoAlexey Isachenko's profile photo
2 comments
 
Yeah the few I've done have worked out well and have been with people who really haven't touched JS before. Having them share their screen and type their own code has gone faster than I thought it would. Have a referral code if some one wants to do their own! 

Also, looking to start a community that is just a Hangout Event of multiple developers. HELPouts is currently just a 1-to-1 deal, but I'm interested in seeing how well live online collaboration with multiple people can go in code - https://plus.google.com/communities/109433448004307433420
Add a comment...

Eric Koleda

Shared publicly  - 
 
You can use the new Drive advanced service to get and set comments on your files. See my response to this feature request for sample code showing how to add and list comments.
13
John McGowan's profile photo
 
+Eric Koleda, love this code. I adapted your code to make custom comments from the Sidebar (especially prepopulated ones that I repeat during assessments), but I am having trouble anchoring it to a specific place in the Doc.
I have read the documentation regarding anchoring not being flexible among revisions, is this still current or is there a way to anchor it like when you use the built-in Comment function?
Add a comment...

Eric Koleda

Shared publicly  - 
 
One of add-ons that launched yesterday was Date Add and Subtract, a sample add-on we created on the Apps Script Developer Relations team. It provides a couple of custom functions for date manipulation and was built to show how you can move your custom functions scripts to the add-ons framework.

The full source code (there isn't much) is now available on GitHub: http://goo.gl/6N8Pdw. There is a wealth of custom functions in the Script Gallery that we would love to see start moving to the add-on store, so get cracking and fill our the add-on application form (http://goo.gl/qBCs09) when you've got something working.
11
5
Gerard Wijnands's profile photoGAS LibraryApp's profile photo
Add a comment...
 
The evolution of Apps Script is here!

With add-ons you can write code once, distribute it to millions of Docs and Sheets users in an eye-catching store, and push updates out seamlessly. All the tools you need to get started writing your own add-on are available today, but for the time being you'll need to go through a approval process before you can publish it. We can't wait to see what you create!
34
18
Federico Granata's profile photoDarren Neimke's profile photoDusty Wilson's profile photoGerard Wijnands's profile photo
2 comments
 
Love it!
Add a comment...

Eric Koleda
moderator

Tips & tricks  - 
 
Wanted to share a little code snippet I cooked up today. It provides a function you can use to determine if a given Position with a Google Doc is contained within a given Range. This can be useful when using the new NamedRange functionality we launched yesterday (http://goo.gl/eiCXXP) and want to determine if the user's cursor falls within one of those ranges.
7
Add a comment...
Have him in circles
4,056 people
Shawn Busolits's profile photo

Eric Koleda
moderator

Tips & tricks  - 
 
I put together a short sample script that shows how to use the Advanced Drive service and the MailChimp API to send the contents of a Google Doc in an email. Enjoy!
17
2
James Swansburg's profile photoJoris Steurs's profile photoFaustino Rodriguez's profile photoPierre-Henri BEGUIN's profile photo
3 comments
Add a comment...

Eric Koleda

Shared publicly  - 
 
Apps Script now has advanced services for both Calendar and Drive. While CalendarApp and DriveApp gave you easy access to basic features, these new services give you raw access to the underlying API. This enables you to do things like set the colors of individual calendar events, list the revisions of a file, etc.
42
10
Niklas W's profile photoGDG Udine's profile photoRiël Notermans's profile photoAlexander Ivanov's profile photo
7 comments
 
No, still an open feature request to add support: https://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=2615
Add a comment...

Eric Koleda
moderator

News  - 
 
I can't wait to see the add-ons from this community!
 
The evolution of Apps Script is here!

With add-ons you can write code once, distribute it to millions of Docs and Sheets users in an eye-catching store, and push updates out seamlessly. All the tools you need to get started writing your own add-on are available today, but for the time being you'll need to go through a approval process before you can publish it. We can't wait to see what you create!
16
2
Eric Koleda's profile photoAaron Burg's profile photoGraham Bourne's profile photoGAS LibraryApp's profile photo
7 comments
 
+Joe Marino Yes, you can create domain-only add-ons. This will be very easy once add-ons are no longer in developer preview.
Add a comment...
 
A nice tutorial on how to use Apps Script to report on your MailChimp campaigns.
 
Blent Day 2: MailChimp API and Google Spreadsheets do it = automated reporting. +MailChimp +Google Apps Script Snippets  #mailchimpintegration
6
4
Matt Barger's profile photoGerard Wijnands's profile photo
Add a comment...
 
In case you missed it last week, it's now possible to show a sidebar in Google Sheets. We've had sidebars in Google Docs since I/O 2013, and now we've brought the feature to spreadsheets as well.

SpreadsheetApp.getUi().showSidebar(
    HtmlService.createHtmlOutput('Hello World'));

Be aware that sidebars (and the rest of the getUi() methods) are only supported in the New Google Sheets, which still has some known issues (http://goo.gl/C2tERO).
17
6
Katrin Kulesova's profile photoKeisuke Oohashi's profile photoAntonio Guzmán's profile photoGerard Wijnands's profile photo
3 comments
Add a comment...
People
Have him in circles
4,056 people
Shawn Busolits's profile photo
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
Story
Tagline
Member of the Developer Relations team at Google.
Introduction

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

Education
  • Colgate University
    Computer Science, 2001 - 2005
Basic Information
Gender
Male