Solved: Workflow fires when Image column stays empty - Page 2

Fabian_Weller · 03-23-2021 06:54 AM

I have a Workflow that fires a Data Change Action. Updates only.
My workflow condition is:
[_THISROW_BEFORE].[Image]<>[_THISROW_AFTER].[Image]
When the image column is empty and I edit another column, the workflow will fire, even though there was no change in the image column.
If there is an image and I edit another column, the workflow will not fire.

The only workaround I found is to change the condition:

AND(
  ISNOTBLANK([Image]),
  [_THISROW_BEFORE].[Image]<>[_THISROW_AFTER].[Image]
)

Suvrutt_Gurjar

Hi @Fabian ,

Thank you for sharing the experience. The solution you applied of adding ISNOTBLANK([Image]) in the workflow condition is indeed correct and recommended by AppSheet as well. The reason why it is needed is explained in the article below.

Please look for the description under the topic " Sending Email When a Row is Added, Updated, or Deleted"

"When comparing before and after values, be aware of the following issue. If both the before and after values are empty, the following expression always return ‘true’.

View solution in original post