Can anyone recommend a tutorial or tips for how to do this? Let’s say, we want to notify a specific user each time a comment is received/a form is submitted. Would it be safe for me to do a Lookup for the user’s email (assuming it’s in the Users sheet and not otherwise accessible)? If so, could I …

[image] saucy: Would it be safe for me to do a Lookup for the user’s email (assuming it’s in the Users sheet and not otherwise accessible)? If so, could I use Glide’s email tool as usual? It’s safe, but it won’t work if the user that triggers the notification doesn’t have access to the receiv…

[image] Darren_Murphy: Assuming that you’re using only native Glide tables, then probably your best option is to utilise a “Public” profiles table that contains a non-sensitive subset of your User Profiles, and doesn’t have row owners applied. I understand that - so how would this work in pra…

Have a watch of the below tutorial [image] locked_with_key Secure Your Data with Row Owners and Public Profiles Community Resources wave Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally e…

I have a few times already - doesn’t help me with this query as far as guidance on how to about sending these emails goes though

Have you tried creating the “Public” table as Darren suggested? It will be a mirrored version of the Users table, with only “public” columns that can be visible to any users. Since it’s a mirrored version, any changes made on the table side should be updated on the mirrored table as well. Then, fo…

[image] ThinhDinh: Have you tried creating the “Public” table as Darren suggested? Yes… hence my question about the lookup for the user’s email (which is in the User sheet and not otherwise accessible). Not otherwise accessible = in the sheet that is not public to the user. So the lookup woul…

What is your definition of “safe”? [image] saucy: So the lookup would be in the public sheet but connected to the “private” sheet which has the row ower. No, this will not work. If emails need to be accessible, then they need to be public and I’ma your public table. If you are trying to lo…

Relations/Lookups are not some kind of special loophole that can bypass row owners. Relations/Lookups work by accessing data that is already loaded on the user’s device. So all data in your public table is loaded on the user’s device in it’s entirety. The private table will only load a signed in us…

[image] Jeff_Hager: A webhook trigger from the app could work if you can at least provide Make with enough information for it you find and retrieve the correct email from the user table. Yes, that’s true. But there needs to be something to provide that link. If the Public facing users table c…

[image] Darren_Murphy: You need to keep in mind that when row owners are applied, then unowned rows will not exist on a users device. So lookups and such simply won’t work. Sorry I missed that! Looks like we both misunderstood each other along the way

How to send notifications and/or emails to users when using row owners

Ask for Help

Darren_Murphy September 28, 2023, 4:23pm 4

Have a watch of the below tutorial

Topic		Replies	Views
Users emailing each other when using row owners Ask for Help	8	291	March 17, 2023
A question about security through relation columns? Ask for Help	42	1003	June 23, 2023
How the row mapping happens? Ask for Help	10	420	March 14, 2022
Public data on a private profile (row owner& array) Ask for Help	11	646	April 19, 2023
🤔 Row Owners vs. User Specific Columns Community Resources tutorial	6	1705	July 4, 2023

How to send notifications and/or emails to users when using row owners

Related topics