ks_Accounting

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.
2020.12.16
GAS
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.
2020.12.03
GAS
flask

Flask: How to pass variables from python to javascript (inline script / external script file)

Introducing how to pass variables from python to javascript in Flask. Even if you say flask, template is jinja2, so it is a method of passing variables to js in jinja2. Both inline script / external script file formats are described.
2020.12.03
flask
スプレッドシート

Let’s Use Spreadsheet Query Function (9)　line breaks in the data etc. Query function error countermeasures

For those who want to use queries, but not enough to create an SQL environment, the spreadsheet query functions are suitable for a little practice or work environment, so I will introduce them. The basics are how to write a query, but we will also introduce how to deal with events that often occur in practice. This is the 9th time to deal with unexpected behavior.
2020.09.23
スプレッドシート業務効率化
スプレッドシート

Let’s Use Spreadsheet Query Function (8)　Required if you do SQL!! Try a subquery with the Query function

For those who want to use queries, but not enough to create a SQL environment, the spreadsheet query functions are suitable for a little practice or work environment, so I will introduce them. The basics are how to write a query, but we will also introduce how to deal with events that often occur in practice. This is the 8th time, how to make a subquery-like query.
2020.09.23
スプレッドシート業務効率化
glide

Try glide　〜Update and link data on glide〜

Introducing Y combinator's first glide, which has become more popular as NoCode Apps. It displays the spreadsheet data in an app format in a nice way. No need to write code. This time, we are linking data by updating data and adding columns in glide.
2020.09.17
NoCodeglide
glide

Try glide ~ What kind of data structure is suitable for glide? ~

glide that being Introduced from Y combinator, which has become more popular as NoCode Apps. It displays the spreadsheet data in an app format in a nice way. No need to write code. This time, I'm talking about what is the best data structure for spreadsheets.
2020.09.16
NoCodeglide
glide

Try glide(no-code app)　〜Overview〜

This is an introduction of glide from Ycombinator, which has become popular as NoCode Apps. It will display the spreadsheet data in a nice app format. No need to write code. Even non-programmers can easily create applications using the spreadsheet as a DB.
2020.09.09
NoCodeglide
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.
2020.09.08
GAS
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.
2020.09.08
GAS
スポンサーリンク
Next page