I have a bot that sends an email notification when the field/column named “Mentor” is changed from its current value. The event is type “Data Change” on “Updates Only”. The formula in the “Condition for event” field is:
This normally works fine and we get the email when somebody changes the value of the mentor field as expected. The problem is when it is blank, the bot is triggered and we get the email saying the mentor has changed even if it hasn’t been. In other words, if the mentor field is blank, the bot is triggered for any change to the record, even if mentor is left alone. Is this a glitch, or is there something I’m missing here? Thanks!
I will add that if I run a test on the expression, I get weird results where it evaluates to “true” anywhere the mentor field is blank, which makes no sense.
@Steve Thank you sir, I can appreciate how that article impacts what my expression is “doing”, but I’m at a loss how to deal with it. If in all cases blank=blank is true, my expression should evaluate to false when the mentor field is left blank, because it is still blank. The expression is evaluating if the value of the field is the same as it was before the update process started, which it is. This helps my “test” output make sense, but not the real-world execution. It should only fire when the value changes. I’m guessing I’m failing to understand something here? At the end of the day, the app in question is set to “Legacy”, will switching to “Consistent” likely solve my issue?