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