tanaike

v1.2.1 (July 26, 2023) A bug of “Send Email messages” was removed. GitHub of OnedriveApp

Gists Here, I would like to introduce a report for understanding the flow of the request to Web Apps created by Google Apps Script. There might be a case that various applications using the Web Apps are created and the Web Apps are used as the webhook. In that case, it is considered that when you have understood the flow of requests to the Web Apps, your goal might be able to be smoothly achieved.

Gists This is a sample script for managing the metadata of PDF data using Google Apps Script. There might be a case in that you want to retrieve and update the metadata of PDF data using Google Apps Script. In this post, I would like to introduce achieving this. Class ManagePdfMetadata This is a Class ManagePdfMetadata. This Class is used for managing the metadata of PDF files using Google Apps Script.

Gists This is a sample script for checking the overwrapped cells of multiple ranges on Google Spreadsheet using Google Apps Script. When applications are developed, there might be a case that it is required to confirm whether 2 ranges on Google Spreadsheet are overwrapped. In this post, I would like to introduce a sample script for achieving this. Method: getOverwrappedCells The following script is a method of getOverwrappedCells. This is the main script of this post.

Gists This is a sample script for automatically refreshing the basic filter on Google Spreadsheet using Google Apps Script. Description A sample situation is as follows. In this sample, the basic filter is set to columns “B” and “D”. Column “B”: When the checkbox is checked, the row is hidden. Column “D”: When the cell value is multiples of 3, the row is hidden. In this case, the custom function =MOD(E2,3)<>0 is used.