Insert data from big table into a normal glide table

I have data in a big table like

| A | B | C|
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 2 | 2 | 3 |

I would like to query the big table where A=1 and then insert the data into a Glide table. This table would have a lot more columns

Glide table
| A | B | C|
| 1 | 2 | 3 |
| 1 | 2 | 3 |

How to do that in Glide?

Or would it more sense to use MAKE (which I haven’t really used yet)

Have you tried using query or relation columns? Or do you mean to create a duplicate column, you can use Glide api?

@Himaladin I need to copy the data from the big table and paste them to another table.

I have tried relation and query column - but cannot see how to run these other than hitting a button in the builder (so not accessible to the user)

If I don’t misunderstand what you mean. Have you turned on this section?

So you need to automate this on a time-based schedule?

@ThinhDinh no - the copying should take place when the user hits a button

So you just want your user to copy a number of rows from the bigtable to a regular table with a single button press?

Yes - that’s correct. The rows must fulfill certain criteria- so a filtering before the copying takes place

Apart from the first method that I mentioned above, you might be able to use this alternative method

1 Like