# Same Column in Different Tables

**URL:** <https://community.glideapps.com/t/same-column-in-different-tables/70390>\
**Category:** Ask for Help\
**Created:** [February 1, 2024, 9:53pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390 "2024-02-01T21:53:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![corbmore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/corbmore/32/69365_2.png) [@corbmore](https://community.glideapps.com/u/corbmore)\
**Post date:** [February 1, 2024, 9:53pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390/1 "2024-02-01T21:53:11Z")

</div>

Need a little help here. This is probably a very dumb question, but here goes.

My app has a date field that the user dumps into the app. It is the first column in the app. To the right there’s another column of user data and then a bunch of calculation columns filling out the table. I would like to create a second table that starts with the exact same dates from the user and then does a few more calculations that I can then graph. Perhaps adding this second table is a bad idea? Anyway, is there a function or way to just copy the same data into the second table or do I need to make a reference column and run a lookup?

In excel it would just be a straight “=” function. So using the below example…in Table 2 it would just be =“Table 1 A1”, =“Table 1 A2” …

Table 1

Dates (A) Widgets (B) -------\> Calculations -----------\>Output  
User Input

Table 2

Dates (A) -------\> Calculations—\> Graph  
Copy of the  
User Input

---

<div class="post-metadata">

**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:** [February 1, 2024, 9:59pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390/2 "2024-02-01T21:59:41Z")

</div>

If you are always grabbing values from the first row in the first table, then I think a Single Value column in your second table should work well.

---

<div class="post-metadata">

**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:** [February 1, 2024, 10:18pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390/3 "2024-02-01T22:18:33Z")

</div>

Two answers:

(1) If your tables represent exactly the same objects, then it might be a good idea to stick to one single table. Why do you wish to have two separate tables?

(2) If really you wish to copy a table and you want the two tables to be in sync, here is how you can do it:

- Create a destination table we’ll call Copy. The following happens in Copy.
- Create [auto-incrementing row indexes](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572) (Row ID → Lookup of Row ID column → Find index value of the lookup column). This will give you row indexes/row numbers, starting at 0, and it will increment with each new row.
- Create a Single Value column configured as follows: From Start → RowIndex → Value you want to copy from the original table.

If the size of the original table is fixed, then you can do a right click on the table and duplicate it.

---

<div class="post-metadata">

**Author:** ![corbmore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/corbmore/32/69365_2.png) [@corbmore](https://community.glideapps.com/u/corbmore)\
**Post date:** [February 3, 2024, 11:08pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390/4 "2024-02-03T23:08:42Z")

</div>

Thank Nathan.

As to question (1) that’s part of the experienced advice I was looking for. I know the pros/cons from and additional tab in excel but I’m not a programmer and I’m trying to better learn best practices. I’ll probably keep it in the same table.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 10, 2024, 11:09pm UTC](https://community.glideapps.com/t/same-column-in-different-tables/70390/5 "2024-02-10T23:09:05Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.