Why is my notification not triggering when a Business Owner becomes inactive?

[Community Alums]

Hi Everyone,

I have created a notification on the Business Service table to trigger whenever any of the Business Owners (e.g., 'Owned by' or 'Managed by') become inactive. Here’s what I added the conditions:

Condition 1: Run when "Updated"

Condition 2:'Owned by.Active' is false OR 'Managed by.Active' is false etc..

However, the notification isn’t triggering when a business owner becomes inactive. The fields 'Owned by' and 'Managed by' reference users, so I expected this to work when their status changes to inactive. Am I missing something in how the condition or trigger works for reference fields or the dot walking is missing something? How can I ensure this notification fires correctly?

Regards,

Sowmya Maradana

[Mr_X]

Hi @Community Alums ,

Owned by & Managed by are reference to User(sys_user) table.
Your notification is on Business Service Table.
When users are inactivated then the update is on User table but not on Business Service Table.

Create a BR on User table and when active changes then Glide to Business Service table and check if deactivated user is part of managed by or owned by and trigger event to send notification.

If my solution works, please hit the Thumb Icon and mark as Correct!