Try glide 〜Update and link data on glide〜

glide glide
この記事は約9分で読めます。

Last time, I explained the better form of data to be imported into glide. It may have been a matter of course for those who are accustomed to RDB such as MySQL.

If you can’t remember, please check the previous article.

This time, I will explain how to update data in glide and link data with each other.

Advertisements

Let’s update the sheet data with glide

If you want to update the data, you first need to find out where the data is. Of course, glide also takes in and processes the spreadsheet data, so the data is stored internally.

From the list that appears in the left sidebar, click the one in the shape of Database to display the imported data.

Let’s click Data

Do you see that the data is captured as it was created in the spreadsheet?

There is a tab at the bottom of the screen, and you can switch sheets.

Let’s actually update the data

Let’s actually update the data.

The method is simple, just move to the cell like a spreadsheet (move the cursor to the cell position and click). Then, “+” mark and “✒️” mark will appear according to the attribute of the column to which the cell belongs as shown below.

status: clicked the cell

You can change the data by clicking the blue + mark. Since the column of attributes related to img is selected in the image above, you can select the image as shown below by clicking with the + mark.

What happens to the original spreadsheet when I update it?

Now, what happens to the original spreadsheet if you update the data on glide as above?

The answer is simple and synchronized, so similar data is entered.

data is updated(spreadsheet is synchronized)

Try adding columns with glide

Now that the data can be updated, it is possible to add columns in a similar way. There is a button called Add Column + at the top of the selected data screen.

Clicking this will bring up a window as shown below as to what type of data column to create.

After deciding the label (name of the column), select the Column Type. Here, select what kind of data type you want. (Instead of choosing the data type, choose what you want the column to do)

choices of Column Type

There are cases where you want to calculate, when you enter a single value, and there are things like conditional branch + execution like if-> then-> else.

This time, select the relation function (data linkage function) and try using it.

Try data linkage within glide

glide includes features like SQL join. That is this “relation”.

It’s a function that I couldn’t do when I used the query function of a spreadsheet before, but since glide retains data while linking it on glide, it seems that a function like join is also possible.

Let’s actually Try “relate”

It’s very simple, just select relation for Column Type and associate the parent and child data. The association is in column units.

For example, let’s link it with the personalized language statement on another sheet by name. Another sheet is taken in like this.

It’s not a good idea, but I added a data column to the self-introduction sheet that links the name of the self-introduction sheet and the name of the personal sheet. It is displayed like this.

So what can you do with this?

What you can do by linking data

Now, let’s select layout> test1 user to display personal detail information.

You can add an element to the detail sheet by pressing the + button on the upper right. There are many elements that can be added, but this time I will select list relation, which is a little scrolled down.

When you select list relation and do it, Add Column is displayed in the detailed data like the center screen. Let’s click.

The individual language skills linked with the data earlier are displayed. It seems that we are able to cooperate safely.

By using the function to link data, it is possible to link additional information instead of adding columns to the original sheet more and more. Conceptually, it’s a method often implemented in RDB. It’s said to divide the table.

What happens to the spreadsheet when you make a relation?

The answer is that nothing has changed, unlike when you updated the data.

This means that the addition of the relation column is done only within glide.

SUMMARY

I explained last time that you can easily create a large layout by giving the data correctly, but this time it was a method of manipulating the data internally.

It’s similar to a spreadsheet, so I think it wasn’t particularly difficult.

On the other hand, the part of linking data in glide and displaying the linked data in layout takes a lot of work. However, I personally appreciate it because I don’t have to pollute the table, or I want to be able to do everything that SQL can do.

If I had free time, I thought I’d try to make my own glide app someday. I can confidently say that it is a tool for non-programmers because it is very easy to layout and link data.

コメント