tanaike

The Thinker

Applicating Spread Syntax and Destructuring assignment to Google Spreadsheet with Google Apps Script

Gists Introduction In this report, I would like to introduce to apply the spread syntax and the destructuring assignment to Google Spreadsheet with Google Apps Script. The destructuring assignment can be used without V8 runtime. But, the spread syntax is required to be used with V8 runtime. Recently, I often saw the script using them at Stackoverflow. And also, I have sometimes gotten the questions related to the spread syntax and the destructuring assignment.

Finally, Google Forms API has been officially released as version 1

Finally, Google Forms API has been officially released as version 1. Create surveys, quizzes, and more using the Google Forms API, now generally available The Google Forms API provides programmatic access for managing Google Forms and acting on responses— empowering developers to build powerful integrations on top of Forms. Forms API

Bug of Create Method of Google Forms API was Removed

Gists When I tested Google Forms API, I noticed that when a new Google Form is created by the method of forms.create, there is not title of the created Google Form. So, I have reported this to Google issue tracker. Ref Today, I confirmed that this bug has been removed. And, when I saw the official document, I noticed that the following document has been added. Ref In the current stage, when the following curl command is used, a new Google Form with the file title of sampleFormTitle and the form title of sampletitle can be created.

Updated: Go Library - getcode to v101

getcode was updated to v1.0.1 v1.0.1 (February 26, 2022) Latest libraries are reflected to this library. And, the sample script is shown using the Quickstart for go of Drive API. You can get this from https://github.com/tanaikech/getcode