Hello Fellow Bubblers —
This one is long, only because I wanted to make it as detailed as possible. I have spent the last 3 days trying to figure it out myself. No success. All the screenshots are to help you see what I see (or in this case don’t see)
I have two users in my database.
Each have created a TASK and assigned the other to it.
User A assigned a TASK to User B and vice-versa. In my example, Kim and Merlin.
In each dashboard you see the TASK that was created by the current user, and the TASK assigned to them by the other user. The task with the RED TRASH BIN is the TASK that was created by the current user.
Each TASK has the ability to post COMMENTS. These comments form a thread that can be read by the current user and the assigned users on the task.
I am trying to create an ALERT system that will notify user’s when a comment has been posted on their TASKs, whether created by them or assigned to them.
WHAT I NEED TO ACCOMPLISH
Every user assigned to a TASK should be notified of newly posted comments, whether they created the task or not. “Comment Creator” should not get their own comment alerts.
Image A and B shows comparisons of the two dashboards so you can better understand what is happening. Other images just give you an idea of how the dots are connected (or not).
I attached all the workflows, and I have crossed checked my data with privacy rules, and also checked drilled down expressions.
I’m missing something, but I can’t see it. Maybe fresh eyes can help me understand the logic. It seems simple enough, and I wish Bubble had an extensive course on understanding how to interpret logic on their platform. When I say it out loud it makes sense, but when I try to put the puzzle together on the platform, something gets lost in translation.
I know this is a lot - I tried to be as thorough as possible. And I trust a Bubble Genius will see the solution before they reach the end of this post.
Thanks in advance, I deeply appreciate any guidance you can share.