G Suite Developers Blog: 4/1/17

Create quizzes in Google Forms with Apps Script

April 27, 2017

Posted by Tynia Yang, Software Engineer, Google Formswe launched Quizzes in Google FormsGoogle Apps Script Forms Servicequizzes

Create quizzes

Assign point values and correct answers for questions

Implement custom grading schemes

Creating an auto-graded question

function createGradedCheckboxQuestionWithAutofeedback() { // Make sure the form is a quiz. var form = FormApp.getActiveForm(); form.setIsQuiz(true); // Make a 10 point question and set feedback on it var item = FormApp.getActiveForm().addCheckboxItem(); item.setTitle("What flavors are in neapolitan ice cream?"); item.setPoints(10); // chocolate, vanilla, and strawberry are the correct answers item.setChoices([ item.createChoice("chocolate", true), item.createChoice("vanilla", true), item.createChoice("rum raisin", false), item.createChoice("strawberry", true), item.createChoice("mint", false) ]); // If the respondent answers correctly, they'll see this feedback when they view //scores. var correctFeedback = FormApp.createFeedback() .setText("You're an ice cream expert!") .build(); item.setFeedbackForCorrect(correctFeedback); // If they respond incorrectly, they'll see this feedback with helpful links to //read more about ice cream. var incorrectFeedback = FormApp.createFeedback() .setText("Sorry, wrong answer") .addLink( "https://en.wikipedia.org/wiki/Neapolitan_ice_cream", "Read more") .build(); item.setFeedbackForIncorrect(incorrectFeedback); }documentationStack OverflowG+ communitylet us knownewissue tracker for Apps Script

Using field masks with update requests to Google APIs

April 20, 2017

Posted by Wesley Chun (@wescpy), Developer Advocate, G SuiteWe recently demonstrated how to use field masks 2cell(fields) { "repeatCell": { "range": { "endRowIndex": 1 }, "cell": { "userEnteredFormat": { "textFormat": { "bold": true } } }, "fields": "userEnteredFormat/textFormat/bold", } }userEnteredFormat/textFormat/bold"fields": "userEnteredFormat/textFormat(bold,italic)"italiccheck out this videopostsee the guide

Using Google Sheets filters in Add-ons with Google Apps Script

April 13, 2017

Posted by Bruce Mcpherson and Romain Vialard, Google Developers Experts, and posted by Wesley Chun (@wescpy), G Suite Developer AdvocateGoogle Apps ScriptGoogle Sheets APIrecent launchAdvanced Sheets Service Filter functionality Advanced Sheet ServiceanyApps Script advanced servicesUrlFetch serviceAPI documentationfunction getIndexesOfFilteredRows(ssId, sheetId) { var hiddenRows = []; // limit what's returned from the API var fields = "sheets(data(rowMetadata(hiddenByFilter)),properties/sheetId)"; var sheets = Sheets.Spreadsheets.get(ssId, {fields: fields}).sheets; for (var i = 0; i < sheets.length; i++) { if (sheets[i].properties.sheetId == sheetId) { var data = sheets[i].data; var rows = data[0].rowMetadata; for (var j = 0; j < rows.length; j++) { if (rows[j].hiddenByFilter) hiddenRows.push(j); } } } return hiddenRows; } The fieldscheck out this pagethis recent video See how some Add-ons use filtering

Yet Another Mail Merge: this Add-on helps users send email campaigns from a spreadsheet and is built to process only the filtered rows of a Sheet. Let's say you have a list of people who are registered for an event, but you've only accepted some of these registrants and need to send an email confirmation. With Yet Another Mail Merge and the updated API, you can filter out people you don't approve to attend and the Add-ons skips them without sending confirmations.

Sankey Snip and Chord Snip: these Add-ons helps users create special chart types that aren't available in the Google Sheets UI. When respecting filters is enabled with these Add-ons, the charts will dynamically visualize filtered data. Check out the example below from the Chord Snip Add-on.

basic filter objectfunction setSheetBasicFilter(ssId, BasicFilterSettings) { //requests is an array of batchrequests, here we only use setBasicFilter var requests = [ { "setBasicFilter": { "filter": BasicFilterSettings } } ]; Sheets.Spreadsheets.batchUpdate({'requests': requests}, ssId); }

Sheets APIApps ScriptAdd-onsAdvanced Sheets Service About the Authors Google Developer ExpertYet Another Mail MergForm PublisherGoogle Developer ExpertbloggerGoing GASGoogle Apps Script for BeginnersGoogle Apps Script for Developers

New Google Drive metrics now accessible from Reports API

April 5, 2017

Posted by Rio Akasaka, Product Manager, Google Drive and Wesley Chun (@wescpy), G Suite Developer Advocatewe launched new metricsAdmin SDK Reports API

New metrics to supplement the set of metrics we launched last year

New visibility information for audit events

Deprecation of existing metrics from the Reports API

New Metrics

Gain insight into the visibility of files and their sharing state, which is useful for security and reporting. This will replace these older metrics:

num_docs_internally_visible, num_docs_externally_visible, num_docs_shared_outside_domain.

Report on product adoption within your domain with summary statistics about groups of users (collaborators, viewers, creators and sharers). Take advantage of key adoption metrics such as 1-, 7-, and 30-day active users for Google Drive, Docs, Sheets, Slides, Forms, Drawings and more.

Simplify your calculation of “what has changed” in your domain using delta metrics which pre-calculate changes in visibility and items owned.

New Visibility Information Learn more Deprecating Existing Metrics these existing metricsMay 14, 2018check out the official documentation

Updates to end user consent for 3rd-party apps and Single Sign-on providers

April 3, 2017

Posted by Rodrigo Paiva, Product Manager, Nicholas Watson, Software Engineer and Wesley Chun, Developer Advocateaccess to user datachange their passwords

Google and 3rd-party applications on iOS

Mobile browsers on iOS and Android

Web browsers (Chrome, Firefox and other modern browsers)

More visibility with new permission requests for your application

Only non-standard permissions will be presented in the secondary consent screen that the user must approve.

check out this developer guidehdlogin_hintOpenID Connect Changes coming for 3rd-party SSO redirection

The end user who has just signed in with one Google account should select that account as confirmation.

A user who is signed into several Google accounts will be required to choose the appropriate account.

See updates starting April 2017April 10, 2017