operation efficiency

Spreadsheet

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.
Spreadsheet

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.
Spreadsheet

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.
Spreadsheet

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.
Spreadsheet

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.
Spreadsheet

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
Spreadsheet

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.
Spreadsheet

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.
Spreadsheet

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.
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.
Advertisements