tanaike

The Thinker

Taking Advantage of Auto-completion of Script Editor for Google Apps Script

Gists Introduction This is a report for taking advantage of the auto-completion of the script editor for Google Apps Script. In the current stage, the auto-completion is implemented in the script editor of Google Apps Script. This auto-completion can be used for not only the built-in classes and methods but also the methods for Javascript. This helps develop scripts and applications very much. In the case of the built-in classes and methods and the methods for Javascript, you can see the detailed specifications of the documents like the official documents and developer.

Copy Date Object between Google Spreadsheets with Different Timezone using Google Apps Script

Gists This is a sample script for copying the date object between Google Spreadsheets with the different time zones using Google Apps Script. One day, you might have a situation in which it is required to copy the date object between Google Spreadsheets with the different time zones using Google Apps Script. In this post, I would like to introduce the sample scripts for achieving this. Sample situation Here, the sample situation is declared.

Focusing Selected Cell to Top Left on Google Spreadsheet using Google Apps Script

Gists This is a sample script for moving the selected cell to the top left on Google Spreadsheet to focus it using Google Apps Script. One day, there might be a case where you are required to focus the specific cell on Google Spreadsheet to help edit cells. In this post, I would like to introduce a sample script for achieving this. Sample script Please copy and paste the following script to the script editor of Google Spreadsheet, and save the script.

Report: Values to transfer between Javascript and Google Apps Script with google.script.run

Gists At the Google Apps Script project, the values can be transferred from HTML to Google Apps Script using google.script.run with Javascript. In this case, unfortunately, the values of all types cannot be transferred. In the official document, it says as follows. Ref Most types are legal, but not Date, Function, or DOM element besides form; see description Legal parameters are JavaScript primitives like a Number, Boolean, String, or null,

Updated: GAS Library - PDFApp

PDFApp was updated to v1.0.2. v1.0.2 (August 21, 2023) A new method of insertHeaderFooter was added. Ref When this method is used, the custom header and footer can be added when a Google Spreadsheet is exported as PDF. You can see the detail information here https://github.com/tanaikech/PDFApp