Stream

Join this community to post or comment
 
Today Google announced a new gForm feature, Quizzes.
http://googleforeducation.blogspot.com/2016/06/updates-from-iste-4-new-tools-to-help.html
The screenshot is what the Quizzes settings looks like. Does anyone know if gApps Script will include integration for Quizzes?
12
4
Mark Schuurman's profile photoSteve Webster's profile photo
3 comments
 
This is what I heard, "Nothing to announce now, but our goal with Apps Script remains to allow users to automate all aspects of their Google experience."
Add a comment...

Romain Vialard
moderator

News  - 
 
The new Google Sheets API (v4) lets you get / set filters on each sheet of your spreadsheet.
It's possible to call this API from Apps Script (via UrlFetch). Here's an example:
https://script.google.com/d/1MXxVLPUEQF9s9L3uzJ5dTn4W5ur8yUn15dR7Y_yzUzClHyAjnmdBDCvn/edit?usp=sharing
(note that it works like an Advanced Service, you need to activate the API in the Developers Console Project).

+Spencer Easton +Bruce Mcpherson +Riël Notermans +Martin Hawksey +Ivan Kutil and others - would someone be interested to collaborate on an Apps Script library to offer to all Apps Script developers the ability to set / get filters and get filtered values of a spreadsheet?

32
8
Bruce Mcpherson's profile photo
26 comments
 
+Romain Vialard +Riël Notermans 
couple of findings of interest.
- treatment of filterViews..in the code so far Im applying any filterviews discovered associated with a sheet. There doesnt seem to be any way of detecting which filterviews are actually active in the UI. Any insight?
- Ive noticed that the start column & row indexes are 0 based, whereas the end column & row indexes are 1 based. I find this super weird. come across this before?
Add a comment...
2
3
Holger Hubbs's profile photo
 
Looks very promising. The script installs, but even after reloading the dialog panes are empty. No scanning possible...

Quick support response (-; Update: in Safari (OS X) it works.

Currently the script only allows to scan 200 files; after this you have to buy.
Add a comment...
 
Hi,

Im doing a blog (spanish with translation button) about learning GAS.... but now im running out of ideas.

Someone have interesting ideas about what can i talk now?

Here the link : googleappscriptsweb.blogspot.com

Thanks to all
1
Add a comment...
 
 
New Google Sheets API (v4)

So happy to finally be able to share the new Sheets API with the world. The v3 version of the API has faithfully served developers for years, but this new version massively expands the capabilities available and brings the API onto our modern technology stack.

The full docs are available here: https://developers.google.com/sheets/
9
Jose Angel Morente's profile photo
 
Will this API be available as a GAS service?
Add a comment...
 
Новая не анонсированная АПИ для работы с таблицами

https://developers.google.com/apis-explorer/#search/sheets/sheets/v4/

Методы:
sheets.spreadsheets.batchUpdate
sheets.spreadsheets.create
sheets.spreadsheets.get
sheets.spreadsheets.sheets.copyTo
sheets.spreadsheets.values.batchGet
sheets.spreadsheets.values.batchUpdate
sheets.spreadsheets.values.get
sheets.spreadsheets.values.update
 ·  Translate
 
New Sheets API

No official docs available yet, but a new Sheets API seems to be finally available after many, many years:

https://sheets.googleapis.com/$discovery/rest?version=v4
1
Add a comment...

Bruce Mcpherson
moderator

News  - 
3
Add a comment...
 
Apps Script now allows web apps running in IFRAME mode to access the browser history stack. This allows developers to persist and recover state information as the user navigates the web app, including clicking on the backward and forward browser buttons.

Currently this feature is only available for web apps -- dialogs, sidebars and add-ons are not supported.


25
6
Ridley Jones's profile photoJean Gorene's profile photo
6 comments
 
Great ! I just tested it with visualization API to update the charts after changing online ... Well, I spent some time still before understanding how it works ;)
Add a comment...

Bruce Mcpherson
moderator

News  - 
 
Well.. it took a while, but my Sankey Snip add-on is now available from the store.

#gde #googleappsscript #blogpost
Sankey Snip will create a Sankey chart (flow diagram) in the sidebar in real time using the data from the current sheet.
15
4
Andrés Cifuentes's profile photoKevin Boulier's profile photo
8 comments
 
For graphic designers that need to get Snakey to Illustrator, copy the embed code and paste it into a editor and save as .svg. Then you can open with Illustrator as editable vector art. Big time saver. Thank you Bruce!!
Add a comment...
 
Convido os brasileiros a participarem, também, desta nova comunidade.
Claro que é interessante continuarmos participando desta comunidade original em inglês, mas... pode facilitar nosso networking irmos nos conhecendo e trocando informações úteis também na nova comunidade.
 ·  Translate
1
Add a comment...
 
Check for merged cells via script and get merged ranges with...

Range.isPartOfMerge()
Range.getMergedRanges()

Also see: https://code.google.com/p/google-apps-script-issues/issues/detail?id=618
Google Apps Script issues and feature requests.
5
Add a comment...
4
3
iBO App Service's profile photoZac Garcia's profile photo
3 comments
 
Also repetitive form generation with similarly formatted source documents. Event-based use cases come to mind, where a new form should be quickly made as part of an event setup workflow (with event registration / event feedback forms, etc.).
Add a comment...
 
Errors with using UrlFetch via trigger significantly reduced

Developers working with triggers have often noticed that, if the trigger calls UrlFetch, the request will sometimes results in a timeout or 'Unexpected' error, after a long delay.

The Apps Script team has recently completed several internal changes that should significantly reduce the number of these errors and improve average latency of the UrlFetch requests. If these errors were causing your project problems, you may want to retest your script now to see if they are resolved.

Happy Scripting!
15
Steve Webster's profile photoFaustino Rodriguez's profile photo
3 comments
 
Indeed, since may 26, it's a huge improvement.
Thanks a lot 
Add a comment...

Martin Hawksey
moderator

News  - 
 
Been waiting for this for a long time :)
8
1
Abdallah Paracha's profile photo
11 comments
 
Been playing with the Sheets v4 api (python) for the last four hours. I must say it is very powerful. You can now do a lot of stuff which you could not do with GData earlier like formatting, sorting, pivot tables etc. But at the same time the http request body is also very dense and hierarchical. Building request bodies would take some getting used to. Definitely need to make some high level functions for that.
Add a comment...
 
 
New add-on 'Custom Count and Sum' published.

This add-on contains 15 custom functions that extend the existing SUM, COUNT and AVERAGE functions to allow the user to perform the aggregations according to the format of the cells - background colour, font colour, and font style. There are also functions in the package that allow you to perform the aggregations across multiple sheets (within the same spreadsheet) without the need for complex formulas.
1
Add a comment...
 
Check this new add-on "Peoples Choice Sheet Tools". Many useful tools under one roof.
Many tools under one roof. Manipulate cells, columns, sheets. Extract & merge values. Generate passwords & encrypt data as well.
5
Andrew Crawford's profile photo
 
Looks like a addon that might be of use to some i know
Add a comment...
 
Reminder:

Last October the EMULATED and NATIVE modes for Apps Script's HtmlService were deprecated, and a gradual sunset plan was announced.

As of today, all scripts, including existing ones, will default to IFRAME sandbox mode unless NATIVE mode is explicitly specified.

If you have scripts, web apps, or add-ons that you did not migrate over to IFRAME, they may function differently than expected (or not at all).

For now you can still use NATIVE mode if you explicitly set it. However, NATIVE mode will be sunset permanently on June 30, 2016, so it is recommended that you migrate now if you have not done so.

Happy scripting!
6
6
Stanislav Tvarůžek's profile photo
 
hmm, that might be the reason why my add-on stopped working.
Add a comment...
 
Published another Add-on. Now it is easier to analyze sentiments of your Google Docs. Have a look.

Analyze the sentiment of a part of a document or an entire document. Get a detail report on positive and negative sentiments.
10
1
Jean Gorene's profile photoAlan Wells's profile photo
2 comments
 
I like it.  I don't like when I see "Connect to an external service" in an Add-on, but other than that, it's good.

Positive:
like 0.72 I like it
good 0.76 it's good

Negative:
don't like -0.72 I don't like

Sentiment:
Positive: 25,2
Add a comment...