GASを利用した自動化や省人化の方法、業務を楽に&2度同じことをしないをkeywordに実際の実装例を紹介
GAS Breaking news! !! Tried to touch the new GAS IDE ~ Changes and impressions / concerns ~
Since the new IDE of GAS has been applied, I will write what I found by touching it. Including changes and personal concerns. Although it is generally well received, there is one change that I cannot agree with, and I would like to introduce it as a concern.
GAS How to convert a spreadsheet to PDF with GAS and send it by email
Convert the spreadsheet to PDF and send it as an attachment to an email. The elements are a method to convert all spreadsheets to PDF and a method to convert a specific sheet to PDF. You can learn what you can and cannot do with the getAs () method. By using export? Format, you can also create files such as PDF / csv.
GAS How to create a self-made library with GAS and reuse scripts ~ Part 2: GAS major external library ~
This is an introduction of how to use an external library with GAS, and how to publish your own library and reuse scripts. If you think of a function that can be used in common, you can reuse it by creating a library and saving it in a public file. This time we are introducing major GAS libraries.
GAS How to create a self-made library with GAS and reuse scripts ~Part 3: How to make a self-made library~
This is an introduction of how to use an external library with GAS, and how to publish your own library and reuse scripts. If you think of a function that can be used in common, you can reuse it by creating a library and saving it in a public file. This time we will finally create and use our own library.
GAS How to create a self-made library with GAS and reuse scripts ~Part 4: Tips and points to note when creating a library~
This is an introduction of how to use an external library with GAS, and how to publish your own library and reuse scripts. If you think of a function that can be used in common, you can reuse it by creating a library and saving it in a public file. This time, I will explain tips and points to note when creating a library.
GAS How to create a self-made library with GAS and reuse scripts ~Part 1: How to use libraries~
This is an introduction of how to use an external library with GAS, and how to publish your own library and reuse scripts. If you think of a function that can be used in common, you can reuse it by creating a library and saving it in a public file. The first is from the explanation of how to use the external library.
GAS How to run a separate file script in GAS
I will show you how to execute a container-bound script in multiple separate files in GAS. Using the library, one script can execute multiple GAS scripts in different files. It saves you the hassle in the premise that triggers can't be used.
GAS Let’s try ECMAScript in New GAS version〜setting and use Arrow Function〜
Since ECMAScript became available in GAS, I tried it immediately. Confirmed the setting method of V8 and that the arrow function is actually supported. However, logging may take some time, so it may be good to check it on the script dashboard.
GAS 【Series of script explanation】Make your own paid leave management system by fully utilizing GAS ~Sending email to the approver when the applicant registers the Form (html email setting by GAS and trigger setting)~
Script explanation of "Make your own paid leave management system by fully utilizing GAS". This time, the part that sends an e-mail to the approver when the applicant has registered the Form is the target. GAS html mail settings and trigger settings can be implemented.
GAS 【Series of script explanation】Make your own paid leave management system by fully utilizing GAS〜first step, settings〜
Paid acquisition management has been an issue since April 2019 in Japan. Paper management is too hard and no efficiency. SaaS can be useful, but if it is this much, it can be implemented by GAS. This time, explaining the setting of Spreadsheet/Google Forms/SlackBot