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”.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |