# Show list of users who favourited a location

**URL:** <https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621>\
**Category:** Ask for Help\
**Created:** [September 19, 2022, 3:53am UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621 "2022-09-19T03:53:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [September 19, 2022, 3:53am UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/1 "2022-09-19T03:53:47Z")

</div>

Hey 👋

I’m building a surf gallery location directory → [https://diary.surf/](https://diary.surf/)

I’ve managed to build in feature to Favorite a location using a User specific column

 ![Screenshot 2022-09-19 at 05.40.31](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c35b83d7f13bad00c471eee71d2061b30b1f02d.png)  
 ![Screenshot 2022-09-19 at 05.40.07](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1acf085a14233beb25545283b4bdf8d5485c8eb4.jpeg)

However I want to notify the users whenever an item is posted to that specific gallery Location that they are following (i.e Favorited)

How would I get a list of users that have ticked Favorited? As this data is User specific … 🧐

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 19, 2022, 4:24am UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/2 "2022-09-19T04:24:38Z")

</div>

> [@Gary\_Willmott](#):
>
> How would I get a list of users that have ticked Favorited?

You can’t. Well, not easily. But, I don’t think you need that…

> [@Gary\_Willmott](#):
>
> However I want to notify the users whenever an item is posted to that specific gallery Location that they are following (i.e Favorited)

There is a way you could do this without having to directly access your Users user specific data.

I assume you have a separate table with “Location Posts” that is linked to your Locations table via a LocationID (or similar), yes?

Assuming that’s true, you should be able to use a lookup to retrieve the signed-in users Following status from your Locations table.

Then what you can do is add a user specific boolean column to your Posts table. Each time a user views a Post, set that column to `true`.

Now, to determine if any post for any of a users followed locations is new, you just need an if-then-else column:

- If followed is not checked, then null (leave empty)
- If viewed is checked, then null
- Else true

Any posts where that if-then-else column is checked can now be considered as “new” (for the signed-in user).  
You could present a list of “New/Unread” posts in an inline list using that column as a filter. Every user would see a different list, depending on which Locations they are following.

---

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [September 20, 2022, 6:39am UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/3 "2022-09-20T06:39:56Z")

</div>

Thanks @Darren_Murphy

For some reason I can’t add another User specific column (it’s greyed out)? Is there maybe a reason you can’t have more than 1 User specific in table?

 ![Screenshot 2022-09-20 at 06.09.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/315543e7e39d273b835ac42a4f00ff90df2519c0.png)

Quick clarification, following != view, they need to actually Favourite a location to Follow it.  
I’m just not sure I need to know if they are unread or new.

Let me clarify further:

**Surfer Journey:**

- The Surfers ❤ Favourite location(s) they like or generally surf at
- Once a photographer has posted an image, the Surfer receives an email to say that their ❤ Favourite location has a new image posted to it.

**Photographer**

- Posts in Gallery that has a Location Linked to it

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 20, 2022, 7:14am UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/4 "2022-09-20T07:14:11Z")

</div>

> [@Gary\_Willmott](#):
>
> For some reason I can’t add another User specific column (it’s greyed out)? Is there maybe a reason you can’t have more than 1 User specific in table?

No, you can have as many as you like. But once a column has been created, you can’t change it to User Specific (or vice-versa). You just need to create a new column and make sure you check the box before you save.

> [@Gary\_Willmott](#):
>
> - The Surfers ❤ Favourite location(s) they like or generally surf at
> - Once a photographer has posted an image, the Surfer receives an email to say that their ❤ Favourite location has a new image posted to it.

Okay, so what I described wont get you this. Probably your best option here is to use Trebuchet to maintain a list of Location Followers. Have a watch of Bob’s video to learn how that works:

> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…

---

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [September 26, 2022, 1:40pm UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/7 "2022-09-26T13:40:17Z")

</div>

Just looping back, the Trebuchet was def a winner!

---

<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:** [September 27, 2022, 1:41pm UTC](https://community.glideapps.com/t/show-list-of-users-who-favourited-a-location/49621/8 "2022-09-27T13:41:03Z")

</div>

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