# Copy/paste relation columns to tables

**URL:** <https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836>\
**Category:** Ask for Help\
**Created:** [October 16, 2022, 1:16am UTC](https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836 "2022-10-16T01:16:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![G\_Mag](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/g_mag/32/45035_2.png) [@G\_Mag](https://community.glideapps.com/u/G_Mag)\
**Post date:** [October 16, 2022, 1:16am UTC](https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836/1 "2022-10-16T01:16:07Z")

</div>

Hi, I have different business set in different tabs on the google sheets.  
I’ve created some columns(math/relation/lookup) in the table function. Is there a way to paste them to my other tables without having to recreate them manually?  
attaching screenshot:  
Thank you

 ![Screenshot 2022-10-15 211120](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab0e6609fe523e7c96a075116dcb26e13d2ef986.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 16, 2022, 1:59am UTC](https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836/2 "2022-10-16T01:59:52Z")

</div>

No, that’s not possible.

But if you find yourself wanting to re-create the exact same columns in multiple tables, that could be a sign that your data structure might not be the best.

Just looking at your screen shot, it looks like each of your tables might be representing a different category of the same (or similar) thing. Do each of your tables have the same set of columns?

If they do, then you absolutely should combine them into one single table, and then add a Category column. This will save you a _LOT_ of work in future with your App.

---

<div class="post-metadata">

**Author:** ![G\_Mag](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/g_mag/32/45035_2.png) [@G\_Mag](https://community.glideapps.com/u/G_Mag)\
**Post date:** [October 16, 2022, 2:13am UTC](https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836/3 "2022-10-16T02:13:11Z")

</div>

wow thank you, very much appreciated. You have definitely shown me a whole new set of possibilities!

---

<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:** [October 17, 2022, 2:13am UTC](https://community.glideapps.com/t/copy-paste-relation-columns-to-tables/51836/4 "2022-10-17T02:13:15Z")

</div>

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