tanaike

The Thinker

Report: Occurring and Resolving Infinite Loop on Google Spreadsheet using Google Apps Script

Gists Here, I would like to introduce a report for occurring and resolving the infinite loop on Google Spreadsheet using Google Apps Script. I have reported this to Google issue tracker. Ref Sample script: Occurring infinite loop This sample script is a test script for confirming the infinite loop. Please be careful this. Please copy and paste the following script to the script editor of Google Spreadsheet and save it. And, please install OnChange trigger to the function onChange().

Report: Inserting Multiple Paragraphs to Google Document in Order using Google Docs API

Gists This is a report for inserting the multiple paragraphs to Google Document in order using Google Docs API. When the multiple paragraphs are inserted to Google Document using Google Docs API, it is required to pay attention to the index for inserting the texts. In this report, I would like to introduce the points for achieving this with a simple method. Although this report uses Google Apps Script, the logic of this method can be used for other language.

Updated: GAS Library - RichTextApp

RichTextApp was updated to v1.3.1 v1.3.1 (February 8, 2022) Modified the method of DocumentToSpreadsheet. Before this update, the paragraphs with only line breaks have been ignored. From this version, such paragraphs are included in the result value of the cell. You can see the detail information here https://github.com/tanaikech/RichTextApp

GAS Library - HtmlFormApp

Overview This is a Google Apps Script library for parsing the form object from HTML form and appending the submitted values to the Spreadsheet. Description There is Google Form in the Google service. Google Form can parse the submitted data and put it in the Spreadsheet. But when we want to use the custom form, it is required to use the HTML form on Web Apps, dialog, and sidebar. In this case, it is required to prepare Javascript and Google Apps Script for parsing the form object from the HTML form and appending the parsed values to Spreadsheet.