# Gather data from one tab (data table within Glide) to another **URL:** \ **Category:** Ask for Help\ **Created:** [September 9, 2023, 9:49am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942 "2023-09-09T09:49:14Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![TiJack](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tijack/32/63834_2.png) [@TiJack](https://community.glideapps.com/u/TiJack)\ **Post date:** [September 9, 2023, 9:49am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/1 "2023-09-09T09:49:14Z")
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 ! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 9, 2023, 11:00am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/2 "2023-09-09T11:00:46Z")
Hello Arnaud, welcome to Glide’s community forum. A few random ideas: 1. Are you sure you need to copy data from one table from another? If possible I would consider other options first. 2. **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. 3. **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. 4. 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. 5. **Fetching data from another table.** You can leverage the Single Value column. In the destination table (the table you are copying the data to): - Create a dynamic RowIndex column: RowID column, lookup of RowID column, find element index of RowID column. - Create a Single Value column to pull in a column from the origin table: Single Value column, from start, RowIndex, column from the original table. - Repeat with Single Value columns to fetch additional columns. I hope this helps. ---
**Author:** ![TiJack](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tijack/32/63834_2.png) [@TiJack](https://community.glideapps.com/u/TiJack)\ **Post date:** [September 9, 2023, 11:11am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/3 "2023-09-09T11:11:20Z")
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. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 9, 2023, 11:15am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/4 "2023-09-09T11:15:53Z")
> [@TiJack](#): > > as I need to get data from every row of column 1, and the single value just gets me the same value every time 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) ---
**Author:** ![TiJack](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tijack/32/63834_2.png) [@TiJack](https://community.glideapps.com/u/TiJack)\ **Post date:** [September 9, 2023, 11:19am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/5 "2023-09-09T11:19:50Z")
Thanks again, I can’t seem to find the RowIndex, where is it exactly ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91f9a7b27a93afd928a74603e30f959826909e38.png) Or maybe I missed something to do when searching ahah ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 9, 2023, 11:21am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/6 "2023-09-09T11:21:56Z")
> [@TiJack](#): > > I can’t seem to find the RowIndex, where is it exactly ? In point **5. Fetching data from another table** , the first bullet point is “Create a dynamic RowIndex column”. ---
**Author:** ![TiJack](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tijack/32/63834_2.png) [@TiJack](https://community.glideapps.com/u/TiJack)\ **Post date:** [September 9, 2023, 11:26am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/7 "2023-09-09T11:26:11Z")
That I did right here I believe ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d7612670e925cd6e5b28d84f11218b678958e57.png) 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) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 9, 2023, 11:32am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/8 "2023-09-09T11:32:32Z")
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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 10, 2023, 1:41am UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/9 "2023-09-10T01:41:04Z")
Can you describe your 2 tables’ structure and your app flow? ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [January 7, 2025, 3:22pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/10 "2025-01-07T15:22:27Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 7, 2025, 3:45pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/11 "2025-01-07T15:45:15Z")
Can’t you just add a template column in the table you imported the data into? Why do you need a secondary table? ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [January 8, 2025, 5:10pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/12 "2025-01-08T17:10:51Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 8, 2025, 6:28pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/13 "2025-01-08T18:28:59Z")
> [@Carl\_Johnson](#): > > paste data from a buffer Usually CTRL+V works for me. But I think you could also do something like this. > **[Import File | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/import-file#importing-to-an-existing-glide-table)** > > Add data from files saved locally on your computer. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [January 8, 2025, 8:01pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/14 "2025-01-08T20:01:28Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 8, 2025, 8:09pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/15 "2025-01-08T20:09:46Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 8, 2025, 8:10pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/16 "2025-01-08T20:10:14Z")
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. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [January 8, 2025, 11:06pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/17 "2025-01-08T23:06:17Z")
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 ---
**Author:** ![Marie](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@Marie](https://community.glideapps.com/u/Marie)\ **Post date:** [June 12, 2025, 3:56pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/18 "2025-06-12T15:56:57Z")
> [@nathanaelb](#): > > 1. **Fetching data from another table.** You can leverage the Single Value column. In the destination table (the table you are copying the data to): > > - Create a dynamic RowIndex column: RowID column, lookup of RowID column, find element index of RowID column. > - Create a Single Value column to pull in a column from the origin table: Single Value column, from start, RowIndex, column from the original table. > - Repeat with Single Value columns to fetch additional columns. Looking for a little more clarification on these steps. In the first table (origin) I have a Row ID column. But I am not sure what you mean by “lookup of RowID column” or “find element index of RowID column.” Are those additional columns I need to set up in the first table? In the second table (destination) when I set up a single value column, from start, RowID (from the first table) it populates the same RowID for all rows. When I go back to edit it I can see that it has reset to get “first” instead of “from start.” What am I missing? Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 12, 2025, 11:47pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/19 "2025-06-12T23:47:02Z")
> [@Marie](#): > > But I am not sure what you mean by “lookup of RowID column” or “find element index of RowID column.” Are those additional columns I need to set up in the first table? It’s just the steps to create a 0-based index of each row since Glide doesn’t provide that natively. - Add a rowID column to the table. - Add a lookup targetting that same column (so you get an array of all rowIDs). - Use find element index, use the source being the lookup above, and find the rowID (it will use the rowID of the current row). ---
**Author:** ![Marie](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@Marie](https://community.glideapps.com/u/Marie)\ **Post date:** [June 13, 2025, 4:42pm UTC](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/20 "2025-06-13T16:42:46Z")
Sorry I am very new to this and still confused. In Table 1 (origin) I have a Row ID column. In Table 2 (destination) I have a Lookup column targeting the Row ID column from Table 1 (I see the array of all Row IDs). When I add the Find Element Index column to Table 2, I can select “Lookup Row ID” for the values but there is no “Row ID” choice to find. I can only select the other columns I have in Table 2 (email, image, etc.). Appreciate any guidance! [Next page](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942.md?page=2)