Stream

Join this community to post or comment
 
.gs files recognised as JavaScript in Github editor. For all you people who get round to loading your GAS libraries and snippets onto Github (since made a lot easier thanks to +Bruce Mcpherson  and his GasGit) I've just noticed that the code editor in Github now recognises .gs files as JavaScript, rather than Gosu, so we don't have to rename them all to .js files.   #github  
Steps to Reproduce: Download a Google Apps Script library using Eclipse Add the Google Apps Script library files to Git Submit the repository to GitHub Result: The github project is marked as a 'gosu' project. Expected Results: Th...
8
1
Martin Hawksey's profile photo
Add a comment...
 
Add-ons & Apps Script | The Apps Show: http://youtu.be/m4Jtj2lCMAA
10
2
Michael Ellis's profile photoFrançois Humbert's profile photoJosue Santos Bitencourt's profile photo
 
This video goes REALLY fast and oversimplifies the effort it takes to do scripting.  Still, there's some good stuff in there if you want to learn how to do it.
Add a comment...
9
2
Ted Juch's profile photoaadhil aci's profile photoJean-Pierre Verhulst's profile photoRiël Notermans's profile photo
3 comments
 
If you copy the sheet, you lose control of it. :(
Add a comment...
 
Super excited that my Add On is now officially published.  Went live January 14th and already has over 140 users.  It's a simple utility tool that will save the user from clicking  to display all calendars AND also has functionality to print the names of all calendars on the user's spreadsheet too.  Special shout out to +Joe Carlin who worked with me on the development.
9
3
new house's profile photoDerek Kaufman's profile photoJeff Ingle's profile photoAxa Cheng's profile photo
3 comments
 
Congratulations
Add a comment...
 
Release notes for update to Apps Script DbAbstraction libraries. 

Lots of changes - a brief summary of the highlights..
- transactions now implemented, with rollback for selected drivers
- a new driver - scratchDB - this is a transient database that sticks around for as long as you use it, otherwise it cleans itself away
- updates to Orchestrate to be able to same complex queries as other back ends

#gde #tutorial #blogpost   #opensourcesoftware   #googleappsscript  
Liberate Excel data from the desktop
4
1
Jonathon Broughton's profile photoFaustino Rodriguez's profile photoBruce Mcpherson's profile photo
2 comments
 
Great case scenarios for the new DriverScratch
Add a comment...
 
 
TECH: When the front-end dev is on vacation · Nobody needs a front-end developer anyway · by CommitStrip #comics
1 comment on original post
6
1
David Prekul's profile photo
Add a comment...
 
December Release Notes (as of 12/12/14):

Note. the Domain Service was scheduled to sunset on 11/20/2014, but was delayed until yesterday. Post Announcement: http://googleappsdeveloper.blogspot.com/2014/05/deprecating-scriptdb-and-domain-service.html

This means Domain Service components like, UserManager, DomainGroup, DomainNickname, DomainUser,  and GroupsManger are no longer working. Use this Migration guide to recover: https://developers.google.com/apps-script/migration/domain
1
Raj J Salecha's profile photo
 
Hi, I did read the migration page - but it does not show the way to replace existing code in Google API using GroupsManager to a new one. The new AdminDirectory is a HTTP code. How do i code that in google API. sorry for being naive - as i am trying to get around this.
Add a comment...
 
This is best news for apps script we've seen for ages. Tomorrow I'll post how to run d3.js visualisations in a spreadsheet sidebar.. Previously blocked by Caja. 
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.
11
David Bingham's profile photoBryan Patterson's profile photo
12 comments
 
So, this mode still doesn't allow for an app to be iframed into a non-Google site?
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...
 
 
#gasja Apps Script have been updated.  
The Form Class have been added some new methods.  
  
Form  
 .getShuffleQuestions  
 .hasLimitOneResponsePerUser  
 .setShuffleQuestions  
 .shortenFormUrl  
  
I guess we can use features below by using these methods on Apps Script.  
http://googledrive.blogspot.jp/2014/09/a-few-more-ways-to-make-forms-your-own.html

#gde   #appsscript   #updates  
View original post
3
Add a comment...
 
OnFormSubmit issue that Google is fixing now (randomly not firing function). I just want to make sure you are not thinking it is your code. 

https://code.google.com/p/google-apps-script-issues/issues/detail?id=4447
Google Apps Script issues and feature requests
7
Chadi Mbarki's profile photoSteve Webster's profile photo
 
Here's a fun little add-on just arrived in the web store! It colors a range of cells depending on their numeric value, allowing you to jazz up some of those big boring tables of data! #googlesheetcolorscale  
Set the background color of a range of cells according to their numeric value, similar to the Excel feature.
6
11
Roger Nixon's profile photo김진달's profile photoOswaldo Alvarenga's profile photoSteven Rappaport's profile photo
 
HEY!  This is WAAYYYY cool.   Great tip, +Andrew Roberts .   I'll be looking in to using this one.
Add a comment...
 
An update on the migration of older spreadsheets to the new Google Sheets

Back in November 2014, we announced that older spreadsheets (those created prior to Dec 2013, including any subsequent copies) would start being gradually migrated to the new version of Google Sheets for Google Apps domains on the Rapid release track, with Scheduled domains to follow

...Simpler spreadsheets will be upgraded first, while those that use Apps Script and more complex features will be migrated weeks to months later to ensure a seamless transition.
4
1
Dan D Smith's profile photo
Add a comment...
 
The redmonk ranking for 2015 is out!  
I checked it but it seems they are missing out on GAS...
So sad! 
With two quarters having passed since our last snapshot, it's time to update our programming language rankings. Since Drew Conway and John Myles White originally performed this analysis late in 201...
3
1
Spencer Easton's profile photoRory O Connor's profile photo
5 comments
 
Google Apps Script is a Platform As A Service. It isn't a language. The language is Javascript.  Similarly you don't see  Google App Engine but you see GO, Python, PHP...
Add a comment...
 
For my first post of 2015 in this community, here's a look back at what came and went in 2014. How do you think Apps Script should develop in 2015 and beyond?

#gde   #googleappsscript   #blogpost  
10
2
Web Apps R&D's profile photoRutger Meekers's profile photoBruce Mcpherson's profile photoSteven Rappaport's profile photo
8 comments
 
I'd love to see the possibility to call functions within a library directly from an HTML Service.
Add a comment...
 
 
The first add-on version of Rose Task Manager, a team task manager that lists the tasks in a Google sheet, uses Google calendar to schedule regular events and sends various email notifications.
List tasks in a shareable spreadsheet via an automatically created form, send email notifications and schedule regular tasks.
View original post
13
2
Jimmy Juliano's profile photoRachel Welsch's profile photo
Add a comment...
 
Great news for HTMLService!
Not so good news for UiApp and DocsList… If you have scripts using those two services, you better start rewriting them. 
7
2
James Ferreira's profile photoSpencer Easton's profile photoAlex Dobrov's profile photoPéter Erben's profile photo
7 comments
 
I was able to place fullbleed on a body tag and worked
Add a comment...
 
Bulk Renamer for Google Drive™

I have recently polished off and published my Bulk Renamer web app. Will very much appreciate if you could take it for a quick spin when you have a minute, and give some feedback!

Bulk Renamer is a web application written in Google Apps Script that can help you rename multiple files in a selected folder. You can choose between simple find/replace and advanced rename (adding prefix/suffix to file names) and select various options for renaming. Could be handy in those cases when you need to rename lots of files and would rather not sync them to desktop to use OS-specific tools to rename them.

The app is available in Chrome Web Store at https://chrome.google.com/webstore/detail/bulk-renamer-for-google-d/peboiggabkeljjdnbelmhbpnmonomngo or can be directly accessed at https://script.google.com/macros/s/AKfycbz5f5BJ6OVf8w23Ntva2bC0ltUw9TieX5FPylpLoVaNUMWFRuaY/exec 

If you do not have any files to test the app with in your Drive, I have shared 2 folders that you can copy to your Drive. (all files in the folders are 0 bytes in size and won't take up any space in Drive):
200 files: https://drive.google.com/open?id=0B9cYdIOAKqWXOFM3OE9wLU9iazQ
500 files: https://drive.google.com/open?id=0B9cYdIOAKqWXaEJZWnk5SFh6WDA (for some reason web view of this folder reports it having, and shows, only 500 files while the folder actually contains 1000 files...)

Will very much appreciate your feedback!
Bulk Renamer for Google Drive™ renames all files in selected Drive folder according to chosen settings. No more need to sync…
17
9
Kyle Beatty's profile photoRoger Nixon's profile photoNigel Moat's profile photoDan Leighton's profile photo
9 comments
 
+Kyle Beatty​, anyone with editing rights can always rename the file. Has nothing to do with this script.

Of course, it would be nice if the script had an option to only rename owned files. 
Add a comment...
 
Google Apps Script
Release Notes updated

You may not need these improvements, but may be some perspective is welcome. For us these notes have an important function. First, they are proof, that development of Google Apps Script is alive, second, it shows that Google Apps Script is a strategic lever for Google Apps. Some of you are still working with a Gmail account. 

May be you can not afford a proper Google Apps for Work account, but if you can, make sure you bind the development of Web Apps to a Google Apps Domain for many reasons. If your achievement does not provide either basic functionality such as everything that +Bruce Mcpherson publishes, or solves problems like +Romain Vialard does e.g. with Awsome Tables, you may have to rethink the use case.

Does your script just solve a single problem, than it may be good for a start, but if it automates steps in a collaborative use case, you are about to qualify for a new carrier. Easier and faster than with JS or any other programming language or with the skills needed to utilize the underlaying App Engine directly. 

You may not have been around when VBA had a break through or database tools like Microsoft Access became available, but if you would have been, you would realize immediately why Google Apps Script is the most powerful development tool of all available by Google: It gives conrol over AdHoc solutions to those in need. 

When we started, most of the material for learning Google Apps Script was on it's way. May be it is time for a book that combines OOAD with Google Apps Script, but you could also just spend a day on the 5 Minute Examples of Bruce to catch up with that and use the next day solving your own problem. 

It is tempting to use all of Google Apps Script, but from experience, we would recommend to put only those services into a Web App that are no longer experimental. For some reason, libraries still are, but you can be sure, if they have to be replaced, it will be by something better, probably a CMS integration.

So long, wish you a great day.

+Keisuke Oohashi has already seen the improvement with his monitoring utility see https://plus.google.com/112329532641745322160/posts/1tE9Ks64enB
3
1
Jonathon Broughton's profile photoWeb Apps R&D's profile photoJose Luis Garcia's profile photo
2 comments
 
Thank you for asking +Jonathon Broughton consider e.g.

SitesApp.createSite( domain, name, title, summary ); 
Add a comment...
 
 
#devfestlon  speaker deck on analytics instrumentation from GDG London this afternoon. 

 h/t +Nico Miceli and +Martin Hawksey 

#gde   #googleappsscript   #googleanalytics   #techtalk  
1 comment on original post
5
Web Apps R&D's profile photo
 
"Recognize and it will be done, measure and it will improve." ... Such a consise example, you earned the respect of the community for a reason, also by helping all of us, almost daily. Thank you!
Add a comment...