Forum Discussion

MikeFreyder's avatar
MikeFreyder
Qrew Member
4 years ago

Pipeline triggered email notifications and permission issues

Hello all! I'm trying to trigger an email notification that sends each of our users/employees an email just before midnight containing all of their Time Cards back to the beginning of the current payr...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
So this part is confusing

Where it breaks down is that each employee should only see their own records and when my pipeline edits the records and triggers the notifications, the emails that get sent do show the correct report based on which employee is receiving the notification, but it tries to populate my own records in it, which works for me. 

Why do you have any permissions which are based on who last modified the record?  These records should have a field for the UserID of the Employee and the permissions would be based on that field. 



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MikeFreyder's avatar
MikeFreyder
Qrew Member
4 years ago
Thanks for your quick reply, Mark! I didn't clearly communicate... The permissions are not based on who last modified the record. I was just assuming that since I modified the records, Quickbase was trying to send my records to people that couldn't see them. When one of my coworkers manually edited the field that I was modifying with my pipeline, he correctly received his records in his email notification, but when my pipeline made the edit, he received the email, but containing no record info.

My permissions are cascading permissions based on If(Current User = User(), "1", "0").

------------------------------
Mike Freyder
------------------------------