# Sync a column from one glide table to another glide table

**URL:** <https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405>\
**Category:** Ask for Help\
**Created:** [October 21, 2020, 9:08am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405 "2020-10-21T09:08:23Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 9:08am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/1 "2020-10-21T09:08:23Z")

</div>

Guys,

I have list of items in a Column in one glide table. I want to sync column to a column in another glide table, so that whenever a new item is added to this column, it gets added to a column in another glide table.  
I know how to do it in Google Sheet (using ={}) but not sure how can we achieve it in Glide Table (trying to create App by using Glide Table maximum).

Can anybody help me? @ThinhDinh @Jeff_Hager @Robert_Petitto

---

<div class="post-metadata">

**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:** [October 21, 2020, 9:52am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/2 "2020-10-21T09:52:57Z")

</div>

Interesting question. I am thinking if you have sequence numbering for each of your rows then you can have a relation and single value to bring it to another column in another sheet, using that number as a relation.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 9:59am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/3 "2020-10-21T09:59:14Z")

</div>

Thank you for your view.  
However, I would need atleast numbers in another sheet to achieve what you said.

My purpose of achieving this is to avoid Row counts which, if used in Google sheets, will exceed 500. Is there any direct way which can populate sequence numbers or the entire column to another glide table?

---

<div class="post-metadata">

**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:** [October 21, 2020, 10:15am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/4 "2020-10-21T10:15:30Z")

</div>

Yeah you’re right about this part. I should think of another way.

> [@Pratik\_Shah](#):
>
> However, I would need atleast numbers in another sheet to achieve what you said.

Doesn’t Glide Table rows also take up rows like Sheet rows?

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 10:42am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/5 "2020-10-21T10:42:56Z")

</div>

No, I don’t think that Glide Table rows are counted as Sheet Rows. But, in glide table, instead of manually entering Serial Numbers, I would want that to be automatically populate in another glide table.

---

<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:** [October 21, 2020, 10:49am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/6 "2020-10-21T10:49:36Z")

</div>

Exact same thoughts as @ThinhDinh. You would need some sort of value to use for a relation to bring in values from another sheet. If there was a way to auto populate a sheet (especially with a UNIQUE type of formula) within glide, I’d be all over that. Also, using Glide Tables should still count against your row count. They just wouldn’t count against sheet edits.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 10:49am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/7 "2020-10-21T10:49:47Z")

</div>

> [@ThinhDinh](#):
>
> I am thinking if you have sequence numbering for each of your rows then you can have a relation and single value to bring it to another column in another sheet, using that number as a relation.

I tried using your advice to make relation which actually worked (the only additional thing I had to do is to manually fill up serial numbers in another glide table, which I want to avoid in future)

However, I found some issue here. You can find below a relation column I created using above solution.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/32ac3f5d058cdfc2e547050e2753d6c1f1ded4ea.png)

but when I am trying to add inline list, it does not show this relation column (only shows my another relation column).  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9c5f0f3743e0d9efe66d18ece45aafa2e5df7cd5.png)

Can you please guide if this is an error or intentional behavior considering that the second relation column is made up from the single value column?

---

<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:** [October 21, 2020, 10:50am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/8 "2020-10-21T10:50:57Z")

</div>

Is it a single or multiple relation?

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 10:52am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/9 "2020-10-21T10:52:26Z")

</div>

Thanks. I selected Single Relation as those were unique values. But when I changed it to Multiple relation, it started working. Thank you so much.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 10:53am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/10 "2020-10-21T10:53:55Z")

</div>

> [@Jeff\_Hager](#):
>
> Also, using Glide Tables should still count against your row count. They just wouldn’t count against sheet edits

I am not sure if I am wrong, but when I added another 60 rows in glide table manually, it did not raise row limits. Is this bug or intentional?  
As far as I remember, I thought, using glide table does not increase your rows limit.

---

<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:** [October 21, 2020, 11:05am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/11 "2020-10-21T11:05:04Z")

</div>

I’m basing purely off this post, unless something has changed recently.

> [@new Glide Tables](https://community.glideapps.com/t/glide-tables/15597/36):
>
> Row quotas are the same with this feature—500 for free apps, 25k for Pro, etc. Glide Tables will let us offer higher quotas in the future.

Looks like they may be working on mirroring for the future.

> [@new Security Center](https://community.glideapps.com/t/security-center/16542/25):
>
> We’re working on features that obviate the sheet mirroring techniques.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [October 21, 2020, 11:08am UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/12 "2020-10-21T11:08:23Z")

</div>

You are correct. it is consuming my row limit. but it does not show up until I add it to App.  
As soon as I add any component which is using these additional rows, there is an increased row usage.

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [January 27, 2022, 4:55pm UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/13 "2022-01-27T16:55:46Z")

</div>

Is there any news on this ?

---

<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:** [January 27, 2022, 5:17pm UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/14 "2022-01-27T17:17:24Z")

</div>

News on what?

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [February 2, 2022, 6:49pm UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/15 "2022-02-02T18:49:05Z")

</div>

Sorry, about a solution to avoid Sheet mirroring…

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/sync-a-column-from-one-glide-table-to-another-glide-table/17405/16 "2024-01-17T16:49:38Z")

</div>


