Need some help. Tried asking GlideAI, but it just go round i circles.
When a user registers, they choose which postal codes they want. When a user then makes a post, they enter the postal code. I would like to send an email to the users who have chosen the postal code that the new post is entered with. How do I do this via workflow?
Are you sending the email as an on-submit action of a form (for the post)? If so, you might want to add a wait module of around 3-5 seconds to make sure the relevant info has been calculated before the email is sent.
I know. But no matter what I do, I can’t seem to fill it. Got it to work 1 time, then I changed the text in Subject and Body and now it dosen’t work again.
Okay. Does the table that the query column is targeting have row owners applied to any column?
If it does, that is most likely the source of the problem (as Jeff suggested).
You haven’t answered the question about row owners. Again, is there any column in your Admins table that has row owners applied? (by default, the Email column always does).
The email column has row ownership applied to it? Only one row of data is ever downloaded and usable by any user.
I think this is where Jeff and Darren were going with this. If you don’t need row ownership, remove it from the email column and try again with sending emails.
But I have read “If your app has a User Profiles table, where each user should access their own profile row but not the profile rows of other users, you should enable Row Owners on that table. Here are some examples and strategies to help you apply this to your apps.”
That is true and recommended practice to protect user data, but at the same time you are asking the app to run a client side action that tries to get data (emails) from unowned rows. The user does not own the rows with the emails and therefore cannot access them. As far as the app is concerned, those rows do not exist. You cannot send an email to a user that does not exist.
I don’t know what the exact setup would be, but you probably need to use one of the server side workflows that don’t have this restriction.
Maybe you added row owners to the user table sometime between then and now… It has always been the case that unowned rows are not accessible, even through a relation. There is no loophole or backdoor way to access unowned data if the user is not the owner.
What you see in the data editor is not to be trusted when row owners come into play. The data editor still has access to all rows and acts as if they are there whether they are owned or not, but the front end app only has access to owned rows.
That’s why I suggest using a server side workflow to send the emails if you still want to protect user PII.
If my users have their own User Profile in the app, I need to have Row owner? Tried to remove Row owner and checked the app where it is the wrong user, when I click on My Profile.
Then tried to make a “email target” table (not row owner), where I would like that when a new user signs up (button) a row would also be added in “email target” with ID, zip code and email, but I can’t get that to work either.
Additionally, what do I do if I expect to have over 5000 users?
