Hi there, I’m kinda new to Glide since a few days, and in my app I want to use data from one table to another (like 2 separate tabs filled with data) to be able to reuse data according to a certain value in the first tab.
I don’t know if I am kinda clear, relations don’t work and I can’t find a way to separate every data, it’s either all or nothing.
Thanks !
Hello Arnaud, welcome to Glide’s community forum.
A few random ideas:
Are you sure you need to copy data from one table from another? If possible I would consider other options first.
Table architecture. Imagine I’m creating a Things tab on which I will display a collection of Things. In the Data Editor, I create a table called Things Tab and don’t touch it (I might touch it at the outset). I create a second table called Things Collection where I will store data related to the Things collection. Each of my tabs have their own table, each of my collections have their own table, and I keep these tables strictly separate.
One-off methods to copy data. You can right-click on any table and duplicate it. You can right-click on any table and do a data import. You can select cells in one table and copy-paste them into another. Below the Users table, you can import a file.
As long as the style of a tab is custom, any collection, and therefore any table, can live on any tab via a collection component.
Fetching data from another table. You can leverage the Single Value column. In the destination table (the table you are copying the data to):
I hope this helps.
Hi Nathanael, thanks for your answer !
I was looking up doing the 5th point, but I encounter a problem, as I need to get data from every row of column 1, and the single value just gets me the same value every time… And I need it to be dynamic, as the user could modify what’s on the 1st column rows when modifying a form.
The method I described is dynamic and should return every row in the column. Did you follow my configuration of the Single Value column exactly? (Single Value column, from start, RowIndex, column from the original table)
Thanks again, I can’t seem to find the RowIndex, where is it exactly ?
Or maybe I missed something to do when searching ahah
In point 5. Fetching data from another table, the first bullet point is “Create a dynamic RowIndex column”.
That I did right here I believe
But the thing is I’d like to have each value extracted automatically, not with a numbered row explictly filled in the column parameters (like if there’s 2 values like here, having 2 rows created with those 2 values put first)
There are often many ways to achieve the same result. The method I explained above Fetching data from another table is dynamic and uses a minimal amount of columns, but I’m sure there’s better. If you come up with a different or more efficient method, do please share.
Can you describe your 2 tables’ structure and your app flow?
Thanks for the ideas on copying data to a new table. Here’s my use case - let me know if it can be supported by any of your approaches.
My users are a not-for-profit looking to keep costs down and utilize glide tables vs google sheets to avoid update costs.
So I am exploring the approach of importing the current google sheet into a glide table. this works well but I need to utilize a template column in the data that concatenates values in the data into a new column that I use to display in a choice list.
So I am looking for ways to import a raw table with 100 rows of data and then create a table using those 100 rows data that also supports a template column that combines the data.
Ideas appreciate.
thanks
Can’t you just add a template column in the table you imported the data into? Why do you need a secondary table?
Good question.
A fresh table gets imported each week so it would wipe our the old table config
Ideally of I corps just Paste the new spreadsheet data into the existing table it wouldn’t need an issue
I don’t see a way to paste data from a buffer into glide
Usually CTRL+V works for me.
But I think you could also do something like this.
Really dumb question. How’s and where are you pasting to? I have tried data grids, glide table view and no news rows are ever created
Usually I’ll do it in the data editor. Select the starting cell, and then paste from my clipboard. You may need to add empty rows if your data extends past the end of the table. I’ve never done it on a large scale. Usually I’m just copying and pasting a few cells at a time to move things around.
Usually I’ll do it in the data editor. Select the starting cell, and then paste from my clipboard. You may need to add empty rows if your data extends past the end of the table. I’ve never done it on a large scale. Usually I’m just copying and pasting a few cells at a time to move things around.
perhaps my karma has changed because data is posting just fine into glide data editor. This will make the app work exactly like I had it using google sheets. THANKS
