雑記

Content wanna continue studying under COVID-19(with living covid-19)

I wrote a series of learning methods and ways to think of a place like a third place that will progress in the corona era. Consider also the categories of services that are likely to develop in the era of changes in learning methods.
2020.06.29
雑記
Python

How to automate the operation of Excel with python 【Introduction for beginners】

This is an explanation of the openpyxl module required to automate the operation of Excel with python. The main explanation is how to use it. We will introduce how to create/copy/save/delete sheets and get/edit values for single cells and multiple cells.
2020.06.28
Python
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.
2020.02.09
GAS
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.
2020.01.30
GAS業務効率化
Python

Automation Posting tweet into twitter by python/selenium

selenium is a feature that makes it very easy to implement scraping. This time we will create a very simple automatic post function to twitter. When combined with daemon processing by cron/launched, it is also possible to automate execution.
2020.01.29
Python
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
2020.01.29
GAS業務効率化
GAS

Make your own paid leave management system by fully utilizing GAS〜Usage script and actual flow with screen shot〜

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. Since it is a GAS based on a spreadsheet, it can be implemented very easily even in the future when pushing in cooperation with Slack.
2020.01.28
GAS業務効率化
GAS

Make your own paid leave management system by fully utilizing GAS

Create a paid leave management system by making fully utilized GAS. It's hard to laugh at the fact that the system for promoting paid acquisition increases the workload of the HR department and makes it unpaid. This is a type of task that greatly contributes to business efficiency by GAS.
2020.01.27
GAS業務効率化
GAS

How to automate monthly report creation and update by Google slide　〜after updating files, coping files automatically and regularly〜

Learn how to use the Installable Trigger to send an email when certain edits are made to a spreadsheet. Event triggers are always activated when they are edited, so we send emails by specifying conditions in the GAS code.
2020.01.27
GAS業務効率化
GAS

How to automatically send gmail by using event triggers when a spreadsheet is edited

Learn how to use the Installable Trigger to send an email when certain edits are made to a spreadsheet. Event triggers are always activated when they are edited, so we send emails by specifying conditions in the GAS code.
2020.01.23
GAS業務効率化
スポンサーリンク
Next page