Hey 
I’m building a surf gallery location directory → https://diary.surf/
I’ve managed to build in feature to Favorite a location using a User specific column
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 … 
You can’t. Well, not easily. But, I don’t think you need that…
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:
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.
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?
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:
Favourite location(s) they like or generally surf at Favourite location has a new image posted to it.Photographer
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.
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:
Back in the days of film, before digital, I used to be a freelance photographer for Surfing magazine & others.
If you’re building, what I think you’re building, you may be on to something.
And if you’re not building, what I think your building, I may have an idea or two for you.
Feel free to DM me if you wish - briefly describe your app / value proposition
Good luck with your build!
BTW - @Darren_Murphy is great to work with!
Excuse me… I missed your link, first read — I just checked out your app. Good call.
Yep, you got it. Good problem. Good call. I would have used it. Keep it up.
feedback
Surfers won’t have a means of writing down the name as they exit the water, and go back to the car. Short & highly memorable would help.
Can’t tell you how many times I wrote a surfers contact info in the sand, then took a photo of it. hahaha!
Marketing - make clothing / hats AKA signage …for photographers to wear while shooting. So, anyone at the beach knows where (your app / site) to find the photos, without asking / distracting
Allow photographers to sell (you likely have it planned) -
Add an additional payed tier for companies / sponsors / surfers that want sponsored
Learn to surf schools might love it, too - not sexy, but it could be a different section, and may help pay the bills
Just looping back, the Trebuchet was def a winner!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
