BOT - Condition

Hi,

I have a problem. This is the formula which i’m using as a condition in my bot to send email. Why, if [Decysion] is empty and after that has a value the mail is sending twice. I noticed , The second condition of “OR” is resposible for that. Why?

OR(
AND (
ISBLANK([_THISROW_BEFORE].[Decysion]),
[_THISROW_AFTER].[Decysion]="Cancel"
),

AND(
ISNOTBLANK([_THISROW_BEFORE].[Decysion]),
[_THISROW_AFTER].[Decysion]="Cancel",
[_THISROW_BEFORE].[Date]<>[_THISROW_AFTER].[Date]
)
)

Recategorized this topic as #appsheet-automation.

You may be encountering “The Quirk”.

https://community.appsheet.com/search?q=@steve%20quirk

2 Likes