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:
If followed is not checked, then null (leave empty)
If viewed is checked, then null
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.
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:
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.
Not super keen on the “Diaries” part of the name.
It has a lot of syllables & sounds like it’s an 80’s surf video title. And you may get better search results with a different name. … just a thought / opinion.
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