# Is there a way to combine Favorites from different tabs into one (if they use one Key)

**URL:** https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195
**Category:** Ask for Help
**Created:** [November 20, 2019, 1:56pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195 "2019-11-20T13:56:25Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)
#### Post date: [November 20, 2019, 1:56pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/1 "2019-11-20T13:56:25Z")

</div>

Hi spreadsheet gurus,

can you please help me figure out is there a way to combine favorite elements from different parts of the spreadsheet (different screens in the app) and create a custom schedule.

**My current flow looks like that:**  
There is a _master table - Samstag_ (2.1), where I have all events with a column _EventID_ - that is used as a KEY for a Favorite button.

Schedule for each Stage (1) is made as a query function (1.2). Here I can select favorites (1.1) but they don’t appear in the ALL tab

And vise versa - if I select in the tab All some favorites can I push them to the individual stage? Currently they don’t go to the individual stages.

Any ideas?

here is the link to the app - [https://mps-bueckeburg.glideapp.io](https://mps-bueckeburg.glideapp.io)  
Thanks

 ![mps](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2981bb9dfa1c2be6982a8490399dd2794f4f0ff5.png)

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [November 20, 2019, 2:29pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/2 "2019-11-20T14:29:23Z")

</div>

The Favorites functionality is within Glide. It links a specific logged in user to a sheet. There is no external access to those lists, so you can’t “see” them in your spreadsheet. So what you want to do is not possible in my opinion.

You could devise a workaround but it would be very clunky and require forms and other sheets to save logged in users and those ID’s to a new sheet, then filter rows by signed in user. I wouldn’t go down that road however.

---

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [November 20, 2019, 3:01pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/3 "2019-11-20T15:01:18Z")

</div>

What if you created a new “Favourites” field that was just a “Switch” field. You could probably come up with a way to link multiple switches to the same user if the switches exist in different tabs/sheets (linked by the user’s email address). You could then use the switch values to create a list of all the user’s “Favourites”.

My guess is that we’re eventually going to see the Favourites feature turn into a component. That’s a complete guess/hope though as I’ve seen this question come up a few times now and I’ve had similar thoughts on how to make it a more effective field in my apps.

---

<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: [November 20, 2019, 3:27pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/4 "2019-11-20T15:27:45Z")

</div>

@NataliaGo sorry, but I would have the same advice as @George_B. I am curious though, about your Start by Hour tab. Are you handling the event counts within the spreadsheet? Does each hour block take you to a detail layout with an inline list? I really like how you set that up!

---

<div class="post-metadata">

### Author: ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)
#### Post date: [November 20, 2019, 3:45pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/5 "2019-11-20T15:45:36Z")

</div>

Thanks @George_B , that’s what I was afraid is happening here 😔 I guess …i will skip this Functionality for now.

---

<div class="post-metadata">

### Author: ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)
#### Post date: [November 20, 2019, 4:12pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/6 "2019-11-20T16:12:00Z")

</div>

I will try to make a test) but first need to learn how to set it up correctly. Thanks @kyleheney for the idea.

---

<div class="post-metadata">

### Author: ![NataliaGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliago/32/1317_2.png) [@NataliaGo](https://community.glideapps.com/u/NataliaGo)
#### Post date: [November 20, 2019, 7:20pm UTC](https://community.glideapps.com/t/is-there-a-way-to-combine-favorites-from-different-tabs-into-one-if-they-use-one-key/2195/7 "2019-11-20T19:20:33Z")

</div>

Thank you so much, @Jeff_Hager glad that you notice it. Yes, it’s a combination of COUNTIF function for a number of events, and inline list based on HOUR, so the output is a detail layout

 ![mps2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/428de7db559e080aac3591155b62c5f725681d32.png)
