# Botton \> Tab

**URL:** https://community.glideapps.com/t/botton-tab/38892
**Category:** Ask for Help
**Created:** [February 23, 2022, 6:19pm UTC](https://community.glideapps.com/t/botton-tab/38892 "2022-02-23T18:19:45Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![E\_J\_E](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/e_j_e/32/29498_2.png) [@E\_J\_E](https://community.glideapps.com/u/E_J_E)
#### Post date: [February 23, 2022, 6:19pm UTC](https://community.glideapps.com/t/botton-tab/38892/1 "2022-02-23T18:19:45Z")

</div>

Hi  
Is there a way to make a button open a tab (from google sheets)? or open data from a google sheet page?  
Im trying to add a button within my inline list that will further expand to a page where i have historical prices of items. each category should open its own historical list thru a button called in this case ‘archives’.  
thank you  
For example in my app:

![Screenshot_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9252c7113e99c991da23938fd5bcd4337b976ca.jpeg)

and then,

![Screenshot_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb97e3c655ad1ed943b741296f9d3691fdc63ef5.jpeg)

once i click on ‘Archivos’ the idea is that a new page opens and i can see historical prices in 2 columns (weeks,prices). For each card i want to have a specific new page with its own historical prices.

---

<div class="post-metadata">

### Author: ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)
#### Post date: [February 23, 2022, 7:07pm UTC](https://community.glideapps.com/t/botton-tab/38892/2 "2022-02-23T19:07:52Z")

</div>

You could use «Show new screen» action

---

<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: [February 23, 2022, 11:56pm UTC](https://community.glideapps.com/t/botton-tab/38892/3 "2022-02-23T23:56:33Z")

</div>

> [@E\_J\_E](#):
>
> Is there a way to make a button open a tab (from google sheets)? or open data from a google sheet page?

Do you mean opening the Google Sheets itself or an in-app screen where you will show historical prices?

Either way, you should be able to do . If it’s Google Sheets, you can have a “link” column to each of those items, and set an “Open link” action pointing to that column. If it’s an in-app screen, you can try “show new screen” and point to the appropriate sheet/relation.

---

<div class="post-metadata">

### Author: ![E\_J\_E](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/e_j_e/32/29498_2.png) [@E\_J\_E](https://community.glideapps.com/u/E_J_E)
#### Post date: [February 24, 2022, 12:51am UTC](https://community.glideapps.com/t/botton-tab/38892/4 "2022-02-24T00:51:49Z")

</div>

thank u for your reply Thinh  
Yes i mean, opening an in app screen where i would show historical prices.  
(Is there any tutorial i could see that would explain step by step to me this ‘link’ column part)

---

<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 26, 2022, 8:33pm UTC](https://community.glideapps.com/t/botton-tab/38892/5 "2022-02-26T20:33:16Z")

</div>

> **[Open Link](https://docs.glideapps.com/all/topics/actions/single-actions/navigation/open-as-link)**
>
> Tap to open a link

---

<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: [February 26, 2022, 11:44pm UTC](https://community.glideapps.com/t/botton-tab/38892/6 "2022-02-26T23:44:25Z")

</div>

For an in-app screen, I assume you have a “Historical” table for that purpose. How are you structuring your data? Do you store “Cacao” and “Cafe” historical prices in different tables or just one?

---

<div class="post-metadata">

### Author: ![E\_J\_E](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/e_j_e/32/29498_2.png) [@E\_J\_E](https://community.glideapps.com/u/E_J_E)
#### Post date: [March 8, 2022, 10:12pm UTC](https://community.glideapps.com/t/botton-tab/38892/7 "2022-03-08T22:12:25Z")

</div>

hi Thinh,  
I have one table with all the historical data related tol the categories (cacao, cafe, etc) by week number of the year.

---

<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: [March 8, 2022, 11:52pm UTC](https://community.glideapps.com/t/botton-tab/38892/8 "2022-03-08T23:52:52Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a9446bba305c534f0aa5fac39dca957b869c286.png)

I assume this is an inline list of “Categories” you have here.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfbaa9a86e3be4696bbd30d674e5bb01a42ee2f2.png)

Then this is the details view of each of those inline list items, now you’re asking for a way so when users click “Archivos” they will see an inline list of historical prices?

My assumption is you have the “Category” column in your Historical Prices table, then what you want to do is:

- Add a relation using the “Category” column, from the “Category” table (which you used for the first image’s inline list), to the “Category” column in the “Historical Prices” table. Make that a multiple match relation.

- Add a “show new screen” action to the “Archivos” button, pointing to the relation above.

- Configure the new screen as you want (layout, what to show on the items, sorting and so on).

---

<div class="post-metadata">

### Author: ![E\_J\_E](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/e_j_e/32/29498_2.png) [@E\_J\_E](https://community.glideapps.com/u/E_J_E)
#### Post date: [March 8, 2022, 11:54pm UTC](https://community.glideapps.com/t/botton-tab/38892/9 "2022-03-08T23:54:23Z")

</div>

Thank u i will try this.

---

<div class="post-metadata">

### Author: ![E\_J\_E](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/e_j_e/32/29498_2.png) [@E\_J\_E](https://community.glideapps.com/u/E_J_E)
#### Post date: [March 9, 2022, 12:26am UTC](https://community.glideapps.com/t/botton-tab/38892/10 "2022-03-09T00:26:58Z")

</div>

Thank you very much worked!

---

<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: [March 10, 2022, 12:27am UTC](https://community.glideapps.com/t/botton-tab/38892/11 "2022-03-10T00:27:02Z")

</div>

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