# Basic Table Problem

**URL:** <https://community.glideapps.com/t/basic-table-problem/9504>\
**Category:** Ask for Help\
**Created:** [May 20, 2020, 7:20pm UTC](https://community.glideapps.com/t/basic-table-problem/9504 "2020-05-20T19:20:14Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sean\_Brauser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_brauser/32/5007_2.png) [@Sean\_Brauser](https://community.glideapps.com/u/Sean_Brauser)\
**Post date:** [May 20, 2020, 7:20pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/1 "2020-05-20T19:20:14Z")

</div>

I want to use different basic tables on different tabs. But each basic table is appearing on all tabs, and if i delete it from one tab it deletes on all tabs! Help!

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [May 20, 2020, 7:37pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/2 "2020-05-20T19:37:16Z")

</div>

Hey Sean!

Welcome!

Can you share screenshots or a link to your app?

---

<div class="post-metadata">

**Author:** ![Sean\_Brauser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_brauser/32/5007_2.png) [@Sean\_Brauser](https://community.glideapps.com/u/Sean_Brauser)\
**Post date:** [May 20, 2020, 7:49pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/3 "2020-05-20T19:49:30Z")

</div>

[Cuttingedge.glideapp.io](http://Cuttingedge.glideapp.io)

---

<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:** [May 21, 2020, 12:05am UTC](https://community.glideapps.com/t/basic-table-problem/9504/4 "2020-05-21T00:05:05Z")

</div>

What are the differences in your 4 tabs? Are they pointing to the same sheet?

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [May 21, 2020, 7:01am UTC](https://community.glideapps.com/t/basic-table-problem/9504/5 "2020-05-21T07:01:42Z")

</div>

In my early glide days I did exactly what I expect you are doing. Setting up different screen (on different tabs) and changing a detail screen on one tab, changing a detail screen on another tab - and getting frustrated as the screen keep alternating each other. But that is how glide works and it can be very handy.

But you want the detail screen to be different on two different tabs. Well, you will need to have two direct tabs (sheets) in you google sheet - maybe with the exact same data. You can get that easy with a query.

Remember, your detail screen is bound to a (google) sheet.

Hope it makes sense.

---

<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:** [May 21, 2020, 7:59am UTC](https://community.glideapps.com/t/basic-table-problem/9504/6 "2020-05-21T07:59:04Z")

</div>

@Krivo  
To duplicate data from one worksheet to another, my inclination would have been to use arrayformula().

In cell A1 of Sheet 2: =arrayformula(‘Sheet 1’!A1:ZZ)

(ZZ as an example)

Do you recommend the query() function to be more flexible on the ZZ parameter?

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [May 21, 2020, 8:03am UTC](https://community.glideapps.com/t/basic-table-problem/9504/7 "2020-05-21T08:03:24Z")

</div>

If you’re duplicating entire data, simply use IMPORTRANGE(). 🙂

---

<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:** [May 21, 2020, 8:11am UTC](https://community.glideapps.com/t/basic-table-problem/9504/8 "2020-05-21T08:11:08Z")

</div>

@sardamit Thanks.

Well there you go @Sean_Brauser, depending on what you want to do exactly:

1. Create another worksheet for your other app tab as @Krivo suggested.
2. Copy data from one worksheet to another by using importrange() if all of the data, or arrayformula() if a subset of your data, or query().

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [May 21, 2020, 8:54am UTC](https://community.glideapps.com/t/basic-table-problem/9504/9 "2020-05-21T08:54:55Z")

</div>

@nathanaelb @Sean_Brauser @sardamit There are a lot of different ways to achieve what you want 🙂 I havn’t really been working with large sheets so I don’t have the experience knowing which would be faster - if it at all is an issues?

From [Processing time - importrange](https://support.google.com/docs/thread/13108947?hl=en)  
_QUERY(IMPORTRANGE()… would be the same speed as =QUERY(datasheet)… but multiple =QUERY(IMPORTRNGE()… would be slower as each one will run the IMPORTRANGE() for each individual formula_

Ben Collins also have a say on processing times:  
[Slow google sheets](https://www.benlcollins.com/spreadsheets/slow-google-sheets/)

---

<div class="post-metadata">

**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\
**Post date:** [May 21, 2020, 10:20am UTC](https://community.glideapps.com/t/basic-table-problem/9504/10 "2020-05-21T10:20:25Z")

</div>

I thought IMPORTRANGE() was only proper if he’s getting information from a whole different file, not between sheets in the same file.

---

<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:** [May 21, 2020, 10:41am UTC](https://community.glideapps.com/t/basic-table-problem/9504/11 "2020-05-21T10:41:57Z")

</div>

In my experience it’s the same thing, just use FILTER or QUERY when it’s the same sheet.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 21, 2020, 11:36am UTC](https://community.glideapps.com/t/basic-table-problem/9504/12 "2020-05-21T11:36:44Z")

</div>

I tend to use query because I can select exactly which columns I need, filter and sort in one fell swoop.

---

<div class="post-metadata">

**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\
**Post date:** [May 21, 2020, 12:43pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/13 "2020-05-21T12:43:34Z")

</div>

Except FILTER or QUERY don’t require the URL of the spreadsheet as one of their arguments. Asking for the URL seems to indicate an outside source of data vs. the same file. Not trying to argue, but to understand.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c376f52ad32ed44658c0bd23feebfd43804fc2e5.png)

---

<div class="post-metadata">

**Author:** ![Sean\_Brauser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_brauser/32/5007_2.png) [@Sean\_Brauser](https://community.glideapps.com/u/Sean_Brauser)\
**Post date:** [May 21, 2020, 2:54pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/14 "2020-05-21T14:54:57Z")

</div>

they point to the same sheet but i want to show different collumns of data on each sheet

---

<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:** [May 21, 2020, 4:18pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/15 "2020-05-21T16:18:11Z")

</div>

Assuming each tab would be in Details view, you are able to set the layout of the top level of a tab or link to screen button independently. Anything below that top level will use the layout set against the sheet. Are you sure you are talking about tabs or are you talking about a list?

---

<div class="post-metadata">

**Author:** ![Sean\_Brauser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_brauser/32/5007_2.png) [@Sean\_Brauser](https://community.glideapps.com/u/Sean_Brauser)\
**Post date:** [May 21, 2020, 5:50pm UTC](https://community.glideapps.com/t/basic-table-problem/9504/16 "2020-05-21T17:50:36Z")

</div>

I figured out a workaround by creating different sheets for each tab. Thanks for the help!
