# Access to Favorites Data **URL:** \ **Category:** Feature Requests\ **Created:** [October 1, 2019, 3:27pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777 "2019-10-01T15:27:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![togume](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/togume/32/381_2.png) [@togume](https://community.glideapps.com/u/togume)\ **Post date:** [October 1, 2019, 3:27pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/1 "2019-10-01T15:27:11Z")
Hello! How can I get access to the Favorites data from within a spreadsheet? I’d love to be able to do some spreadsheet magic with that data on a per user basis. For example, I’d love to be able to populate another sheet with all of the favorited items and build functionality on top of that. ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [October 3, 2019, 9:33am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/2 "2019-10-03T09:33:37Z")
Hey @togume! At the moment that data is not shared with your sheet. However, I will move this post to the #feature-requests category and add it on our wishlist. ---
**Author:** ![togume](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/togume/32/381_2.png) [@togume](https://community.glideapps.com/u/togume)\ **Post date:** [October 3, 2019, 12:49pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/3 "2019-10-03T12:49:52Z")
Thanks, @JackVaughan! ---
**Author:** ![Dave\_McManus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave_mcmanus/32/352_2.png) [@Dave\_McManus](https://community.glideapps.com/u/Dave_McManus)\ **Post date:** [October 12, 2019, 7:16pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/4 "2019-10-12T19:16:28Z")
+1 on this. @JackVaughan are there any ways around this for now using a form? Right now I want to record which users are ‘using specific items’ from my list. Like user 1 - [fake@email.com](mailto:fake@email.com) - clicked on tomatoes, cucumbers etc. Thanks ---
**Author:** ![TimNZ](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/timnz/32/2062_2.png) [@TimNZ](https://community.glideapps.com/u/TimNZ)\ **Post date:** [December 6, 2019, 11:25pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/5 "2019-12-06T23:25:57Z")
Pretty much the only essential thing that is missing for me now is an ‘App: Favorites’ tab in the sheet. Columns: - Unique reference - key + id, to item - User email - Timestamp added ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [December 7, 2019, 9:00am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/6 "2019-12-07T09:00:28Z")
@Dave_McManus - sorry for missing your message above. Not at the moment. @TimNZ Welcome to the forum! Yes, that sounds about right. ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [December 11, 2019, 12:04pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/7 "2019-12-11T12:04:17Z")
This would be a great way to measure engagement! ---
**Author:** ![brandonley](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brandonley](https://community.glideapps.com/u/brandonley)\ **Post date:** [March 19, 2020, 10:34pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/8 "2020-03-19T22:34:58Z")
Is there any progress on this? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 19, 2020, 10:44pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/9 "2020-03-19T22:44:11Z")
Lots of progress. We will soon have a way for you to implement a feature like Favorites on your own, and access the data. Although the data will not write back to your sheet – it will be accessible in the Glide data editor and for reuse in your app. ---
**Author:** ![TimNZ](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/timnz/32/2062_2.png) [@TimNZ](https://community.glideapps.com/u/TimNZ)\ **Post date:** [March 27, 2020, 10:03pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/10 "2020-03-27T22:03:17Z")
Please don’t hide Favourites data. Since you don’t have an API, the upside of having the data maintained in the Sheet is we can drive smarts using so many other platforms that work with Sheet docs. At a minimum please also mirror the App: Logins as a log, > [@Access to Favorites Data](https://community.glideapps.com/t/access-to-favorites-data/777/5): > > Pretty much the only essential thing that is missing for me now is an ‘App: Favorites’ tab in the sheet. Columns: Unique reference - key + id, to item User email Timestamp added Add to my suggestion another column: - On/Off: on = favourited, off = unfavourited ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 31, 2020, 2:55am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/11 "2020-03-31T02:55:12Z")
Hola @david Will that Favorites data increase the amount of records in any App if it uses that data to do other process/calculations? If so, it will bring an indirect problem by accident. I mean, if 30 customers select 10 products as Favorite in 1 day, the App will have 300 additional rows very quick and its perfomance could be affected in few days. Thanks for you help Saludos Gavp ---
**Author:** ![Amanda\_Schulze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amanda_schulze/32/5855_2.png) [@Amanda\_Schulze](https://community.glideapps.com/u/Amanda_Schulze)\ **Post date:** [April 26, 2020, 6:15am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/12 "2020-04-26T06:15:20Z")
Yes please ---
**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\ **Post date:** [May 5, 2020, 6:12pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/13 "2020-05-05T18:12:29Z")
This is such a needed feature. I second @TimNZ - a further column that mirrors Login’s Log would be enough for the time being. Having Favorite’s in the Data sheet is unfortunately useless, as there is no way to create views and marketing reports. Go Glide, make it happen 🙂 ---
**Author:** ![Polley\_Wong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polley_wong/32/8908_2.png) [@Polley\_Wong](https://community.glideapps.com/u/Polley_Wong)\ **Post date:** [June 10, 2020, 9:13pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/14 "2020-06-10T21:13:34Z")
Very exciting! Any news on when this function be available david? Thanks for the great work! 🙌 ---
**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:** [June 10, 2020, 9:46pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/15 "2020-06-10T21:46:28Z")
[https://docs.glideapps.com/all/reference/data-editor/user-specific-columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) ---
**Author:** ![Polley\_Wong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polley_wong/32/8908_2.png) [@Polley\_Wong](https://community.glideapps.com/u/Polley_Wong)\ **Post date:** [June 10, 2020, 10:25pm UTC](https://community.glideapps.com/t/access-to-favorites-data/777/16 "2020-06-10T22:25:19Z")
For whoever that’s looking for a workaround in the meantime This is how we did it to get a list of people’s “Favorites” 1. Create an **if-else** column in the **favorite options** sheet, that checks the **Is Favorited?** column and print the user email 2. In another **user preference** sheet, that contains a _local_ **user’s email** column, create a **Relation column** that links to the **favorite options** sheet, cross referencing the user’s email field created in **Step 1**. Now you have an array column that shows all the favorited options. If it’s looking up all the favorited item’s Row ID, then go to **Step 3** 3. Create a **lookup column** inside the **user preference** sheet, use the relation created in **Step 2** and choose the **name column** (or equivalent) to show the favorited item’s name list ---
**Author:** ![ajchan](https://avatars.discourse-cdn.com/v4/letter/a/9de053/32.png) [@ajchan](https://community.glideapps.com/u/ajchan)\ **Post date:** [June 11, 2020, 12:41am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/17 "2020-06-11T00:41:30Z")
I read through this and still cannot figure out how to access the favorites data for a user ? If a user favorites a set of pages how does she get to all of those ? ---
**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:** [June 11, 2020, 1:02am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/18 "2020-06-11T01:02:33Z")
Were you wanting to view YOUR favorites or those of ANOTHER USER? ---
**Author:** ![ajchan](https://avatars.discourse-cdn.com/v4/letter/a/9de053/32.png) [@ajchan](https://community.glideapps.com/u/ajchan)\ **Post date:** [June 11, 2020, 1:13am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/19 "2020-06-11T01:13:45Z")
I want every user to be able to see what they have favorited. So basically what a user favorites. As a developer I don’t care much about what others have favorited. I’m assuming that I can “Preview As” to test it. ---
**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:** [June 11, 2020, 1:36am UTC](https://community.glideapps.com/t/access-to-favorites-data/777/20 "2020-06-11T01:36:22Z")
Simple, then. Create an inline list of the “favorited items” anywhere you want and then filter it where “Is favorite” is _true_. ![Screen Shot 2020-06-10 at 9.36.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d05a77758890d2e8160f468d608537a1751a1c30.png) [Next page](https://community.glideapps.com/t/access-to-favorites-data/777.md?page=2)