# List of users who have favorited an item **URL:** \ **Category:** Ask for Help\ **Created:** [June 2, 2021, 10:17am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509 "2021-06-02T10:17:54Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![A\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_b/32/19695_2.png) [@A\_B](https://community.glideapps.com/u/A_B)\ **Post date:** [June 2, 2021, 10:17am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/1 "2021-06-02T10:17:54Z")
How do you generate a list of users who have favorited a specific item? I have a list of “chat channels” which users can favorite. I call that “Follow” I’d like to display a list of users (photo/name) who are “following”/have favorited that channel. It would look similar to what @Robert_Petitto has done with his Group Chat template but I can’t figure it out. Any ideas? Thanks! ---
**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 2, 2021, 1:05pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/2 "2021-06-02T13:05:24Z")
Unfortunately, you can’t use the native “favorite” button for this use case as it’s user specific (only the signed in user can see the list of favorites). Instead, you’d need to create a favorite button of sorts and use the trebuchet method to gather a list of emails per “chat channel”. If I have time later, I’ll create a video, but until then check out @Lucas_Pires’s tutorial: > [@Trebuchet Method link](https://community.glideapps.com/t/trebuchet-method/25477): > > [image] ---
**Author:** ![A\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_b/32/19695_2.png) [@A\_B](https://community.glideapps.com/u/A_B)\ **Post date:** [June 2, 2021, 5:59pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/3 "2021-06-02T17:59:41Z")
Thank you Robert, I watched the video and will try to reproduce it. If you do have time to create a video it would be most appreciated (and I think helpful to the community here too). ---
**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 2, 2021, 6:58pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/4 "2021-06-02T18:58:15Z")
Here you go: > **[Training & Compliance · Glide](https://www.loom.com/share/6ecaea3e23d840a5a257751a8f7ce34a)** ---
**Author:** ![Steven](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steven/32/15309_2.png) [@Steven](https://community.glideapps.com/u/Steven)\ **Post date:** [June 2, 2021, 7:18pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/5 "2021-06-02T19:18:38Z")
@Robert_Petitto Such a great video. What visual component did you use to get the icons to stack like this? ![users](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06c2e5c8687586babcd1f4cfa25bb9853f756560.png) ---
**Author:** ![A\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_b/32/19695_2.png) [@A\_B](https://community.glideapps.com/u/A_B)\ **Post date:** [June 2, 2021, 7:41pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/6 "2021-06-02T19:41:04Z")
This is gold! Thank you @Robert_Petitto. I had come up with the “Follow Log” approach but this is much better. Is this mostly one-way? I.e. you can “follow/subscribe” but not “unfollow/unsubscribe”? ---
**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:** [June 2, 2021, 11:10pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/7 "2021-06-02T23:10:46Z")
> [@CSS to create overlapping profile images](https://community.glideapps.com/t/css-to-create-overlapping-profile-images/25783/6): > > .tile-inner { width: 87px; } .tile-image-area { border: solid 5px white; border-radius: 50%; box-shadow: inset 0px 0px 0px 10px white; } .inner { grid-template-columns: repeat(5, 55px) !important; } [Screen Shot 2021-04-19 at 9.57.49 PM] ---
**Author:** ![A\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a_b/32/19695_2.png) [@A\_B](https://community.glideapps.com/u/A_B)\ **Post date:** [June 3, 2021, 1:59am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/8 "2021-06-03T01:59:59Z")
Thank you! ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9496d58ad2725d67cbab9ccaf8e56f1791282b90.png) ---
**Author:** ![Nadir\_Abdelrahman\_MD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nadir_abdelrahman_md/32/5237_2.png) [@Nadir\_Abdelrahman\_MD](https://community.glideapps.com/u/Nadir_Abdelrahman_MD)\ **Post date:** [June 3, 2021, 3:04am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/9 "2021-06-03T03:04:18Z")
Great as usual! Thanks. ---
**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 3, 2021, 3:05am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/10 "2021-06-03T03:05:50Z")
> [@CSS to create overlapping profile images](https://community.glideapps.com/t/css-to-create-overlapping-profile-images/25783/6): > > .tile-inner { width: 87px; } .tile-image-area { border: solid 5px white; border-radius: 50%; box-shadow: inset 0px 0px 0px 10px white; } .inner { grid-template-columns: repeat(5, 55px) !important; } [Screen Shot 2021-04-19 at 9.57.49 PM] Exaclty. Basically a variation of this CSS I came up with. ---
**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 3, 2021, 3:24am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/11 "2021-06-03T03:24:39Z")
> [@A\_B](#): > > Is this mostly one-way? I.e. you can “follow/subscribe” but not “unfollow/unsubscribe”? The video shows one way, yes. There is a way to undo, but it’s a bit tricky. Here’s how: ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [June 3, 2021, 11:18am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/12 "2021-06-03T11:18:53Z")
Thank you @Robert_Petitto. If I understood well, the Trebuchet is probably also the best workaround for Multi-Selection in a Choice component? If I am correct, given the frequent requests about this (key) feature, and the multiple answers which are not always the same, hopefully Glide team will make **1** tutorial of reference … Thanks ---
**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 3, 2021, 12:34pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/13 "2021-06-03T12:34:26Z")
Exactly. All of my “multiselects” using an inline list uses the trebuchet method. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [June 3, 2021, 12:48pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/14 "2021-06-03T12:48:09Z")
Thank you. Does it works (more or less) that way? (In Database) 1- ‘Trebuchet columns’ ( **text field** , temporary USC, template, if for the comma etc) 2- ‘Choice items’ list (In Screen) 3- Inline list with ‘Choices items’ as Source 4- ‘Trebuchet’ Action on the inline (write in the temporary USC etc). Then whatever the action resulting from the multi-select, it is related to the **entry field** (ex. filter \> is included in “text field”) Thanks ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [June 18, 2021, 5:30pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/15 "2021-06-18T17:30:30Z")
Thanks @Robert_Petitto. When we see the number of use cases of the Trebuchet Method, it would be uncredible if Glide built a native feature around it… Any chance in the short term @JackVaughan ?? Thanks ---
**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 18, 2021, 5:34pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/16 "2021-06-18T17:34:45Z")
Agreed. I just used it 4 times yesterday in an app I’m building for a client. Really need “add to array” / “remove from array” actions. Course, that would also warrant the creation of a new “array” column type most likely. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [June 24, 2021, 3:04pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/17 "2021-06-24T15:04:10Z")
Hi @Mark, do you have this in your ‘short term’ roadmap ? > [@List of users who have favorited an item](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/16): > > Agreed. I just used it 4 times yesterday in an app I’m building for a client. Really need “add to array” / “remove from array” actions. Course, that would also warrant the creation of a new “array” column type most likely. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [June 24, 2021, 3:52pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/18 "2021-06-24T15:52:15Z")
We’ll be planning our next quarter soon, then we’ll see. ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [June 25, 2021, 8:01am UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/19 "2021-06-25T08:01:57Z")
Thanks @Mark. @Lucas_Pires @Robert_Petitto, the fact that Glide next quarter roadmap is about to be defined is a chance to provide Insights about the multiple use cases of ‘Industrializing the Trebuchet’. Maybe could we provide a List of illustration? → _My_ top one is Multiselects in a Choice component ---
**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 25, 2021, 12:59pm UTC](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509/20 "2021-06-25T12:59:40Z")
In a recent app, I used it several times: - **multiple selection using an inline list** (display an inline list with action set to trebuchet to result in a cell of comma separated itemIDs) - **location check-ins** (button on a restaurant’s details page that trebuchets the signed in user’s email to a cell of comma separated list of users that have checked in) - **ratings** (use rating component and a button to increment a user count column and a rating sum column so I can ultimately create an average rating per restaurant) - **badges** (“claim badge” button that appears when it meets certain criteria for a user. Button has trebuchet action to ultimately result in a comma separated list of emails that have claimed that badge). Mind you, the trebuchet method is really just a way to save rows. It is NOT an improvement functionally over adding rows to a new table and then creating a multiple relation to that table. However, the benefit to the trebuchet is that it requires ZERO additional rows. [Next page](https://community.glideapps.com/t/list-of-users-who-have-favorited-an-item/27509.md?page=2)