tanaike - Google Apps Script, Gemini API, and Developer Tips

The Thinker

Updated ggsrun to v132

ggsrun was updated to v.1.3.2 v1.3.2 (October 20, 2017) Updated ggsrun’s Install manual (README.md). Since I thought that the manual became too complicated, I separated it to the simple version and the detail version. And also , recently, since Google’s specification was updated, about how to deploy API executable and enable APIs for ggsrun’s Install manual were updated. From this version, scripts in a project can be rearranged.

Updated go-rearrange and gorearrange to v102

go-rearrange and gorearrange were updated to v.1.0.2 From this version, data included multi-bytes characters can be used. At Linux, it works fine. At Windows DOS, rearranging and selecting data can be done. But the displayed data is shifted. Although this may be a bug of termbox-go, I don’t know the reason. I’m sorry. On the other hand, data with only single-byte characters works fine. About MAC, I don’t have it. If someone can confirm and tell me it, I’m glad.

Updated go-rearrange and gorearrange to v101

go-rearrange and gorearrange were updated to v.1.0.1 As one of outputs, indexmode (bool) was added. If this is true, the rearranged result is output as the change of index for the source data. For example, if the source data and rearranged data are ["a", "b", "c"] and ["c", "b", "a"], respectively. The output will become [2, 1, 0]. By this, the specification for creating applications will expand. The detail information and how to get this are https://github.

CLI Tool - gorearrange

Overview This is a CLI tool to interactively rearrange a text data on a terminal. Description Since I couldn’t find CLI tools for manually rearranging text data, I created this CLI tool. For this, at first, I created a Golang library go-rearrange. The detail information and how to get this are https://github.

Enhanced onEdit(e) using Google Apps Script

Gists onEdit(e) which is used for the Edit event on Spreadsheet has the old value as e.oldValue. The specifications for this are as follows. When an user edited a single “A1” cell, e of onEdit(e) shows hoge for e.oldValue and fuga for e.value. When an user edited the “A1:A2” multiple cells, e.oldValue and e.value of onEdit(e) are not shown anything. When an user copied and pasted from other cell, e.