経営管理deプログラミング

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.

2020.09.08

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.

2020.09.07

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.

2020.09.07

GAS

Let’s Use Spreadsheet Query Function (7)　Sorting basics “ORDER BY” clause

I would like to use a query, but it is not enough to create an SQL environment, so the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. This is the sorting function for the 7th order by this time.

2020.08.28

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (6)　Let’s bring data from another sheet ~ Combination with ImportRange function ~

I would like to use a query, but it is not enough to create an SQL environment, so the spreadsheet query function was suitable for a little practice and work environment for people, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. I will learn the processing of the data part such as the sixth import range and data combination.

2020.07.21

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (5) Group by

I'd like to use a query, but since it's not enough to create an SQL environment, the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. I will remember the aggregation in the fourth GROUP BY this time.

2020.07.13

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (4) WHERE Clause

I'd like to use a query, but since it's not enough to create an SQL environment, the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. The fourth time, this time is the WHERE statement

2020.07.10

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (3) SELECT Clause

I'd like to use a query, but since it's not enough to create an SQL environment, the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. The third time this time is the SELECT statement.

2020.07.10

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (2) Structure of query function

I'd like to use a query, but since it's not enough to create an SQL environment, the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. This time for the second time, it is the construction of the query syntax.

2020.07.10

スプレッドシート業務効率化

Let’s Use Spreadsheet Query Function (1) Outline and Purpose

I'd like to use a query, but since it's not enough to create an SQL environment, the spreadsheet query function was suitable for a little practice and work environment, so I will introduce it. The basics are how to write queries, but I will also introduce how to deal with events that often occur in practice. The first time this time is an outline and purpose.

2020.07.09

スプレッドシート業務効率化

How to create a self-made library with GAS and reuse scripts ~Part 4: Tips and points to note when creating a library~

How to create a self-made library with GAS and reuse scripts ~Part 1: How to use libraries~

How to run a separate file script in GAS

Let’s Use Spreadsheet Query Function (7) Sorting basics “ORDER BY” clause

Let’s Use Spreadsheet Query Function (6) Let’s bring data from another sheet ~ Combination with ImportRange function ~

Let’s Use Spreadsheet Query Function (5) Group by

Let’s Use Spreadsheet Query Function (4) WHERE Clause

Let’s Use Spreadsheet Query Function (3) SELECT Clause

Let’s Use Spreadsheet Query Function (2) Structure of query function

Let’s Use Spreadsheet Query Function (1) Outline and Purpose

Let’s Use Spreadsheet Query Function (7)　Sorting basics “ORDER BY” clause

Let’s Use Spreadsheet Query Function (6)　Let’s bring data from another sheet ~ Combination with ImportRange function ~