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)
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 https://youtu.be/b7_k3_brusQ?si=7ou2AIHe-wDZe0vv
