"This solution came about from a requirement to recreate SharePoint lists in Google Apps, taking across large numbers of list items, with each item needing to have its own edit form populated with the appropriate data. Additionally, users should be able to edit the Google Sheet, and have those changes reflected in the edit forms. This attempts to give the same functionality as SharePoint where items can be edited in edit form, or in bulk via datasheet view"
"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."
This post describes how you can use the IMAGE formula as a Google Analytics Beacon for tracking Google Sheets views
Martin Hawksey's insight:
I've got quite a few Google Sheet templates in the wild and was looking for a way to track usage (even just a basic view count). Recently I came across +Ilya Grigorik 's Google Analytics Beacon project which lets you use an image as a GA webbug. The result basic Google Analytics tracking of sheets without jumping through potential Google Apps Script authorisation and quota issues
"Finance Service - we are deprecating the Finance Service in Google Apps Script. It will remain available for the next six months but will be turned off on September 26, 2014. Please start considering alternatives for the financial data right away.
Properties Service - we are launching a new properties service with a notion of Document level properties and more. Due to this, we will be deprecating the current properties service. Again, stay tuned for more details tomorrow! We think you'll like the new Properties service look. This is more of a heads up. No action needed till after tomorrow's blog post. "
"Choosing between Google Apps Script and Google App Engine is not always a clear choice. These two tools are not mutually exclusive in their functionality and could, in many cases, be used conjointly. Fundamentally, they are very similar. Both are platforms on which to build applications, both run within Google's infrastructure and both allow for integration into other Google services. Similarities abound."
"Quick update - going forward sidebars in Google Docs and Sheets will be forced to be 300px. If you have code that sets width of a sidebar, that call will be ignored. Please update your UI accordingly. This change has already been rolled out to new Sheets and will be in Docs next week. If you were never setting width, then you'll notice no difference as the default was 300px. "