Business Rule not detecting change with a dot walked field

[SC10]

On my Project table form, I have dot walked to the Demand table's field of "Project Sponsor".

Creating a new Business Rule, I would like to update a value on my Project record when this dot walked field changes value:

(Note: I have since turned off the "advanced" condition, and am simply using the filter condition on "When to run")

[Pradeep Sharma]

Hi Shane,

Which instance is your release on. I will try to reproduce this at my end.

[SC10]

Geneva. Thanks!

[Chuck Tomasi · Accepted solution]

Hi Shane,

The idea with Business rules is they detect changes on the record they are watching. In your case, you are asking to watch the pm_project table for updates. yet your condition is also asking "If something changes on the demand table..."

You see the conundrum? Technically, nothing changed on the pm_project table to trigger this business rule. You are looking for a business rule on the demand table which then needs to update the (child) project. That's going to require a bit of script and, if you have multiple child projects under that one demand, they are all going to get updated.

[SC10]

That's what I thought was probably happening. I thought maybe the linkage between my Project and Demand (which is allowing the dot walking within "Filter condition" in the first place) would somehow allow the BR to trigger - guess it isn't that magical without scripting