Data Change on updateed column

[Phil_Waite]

Hi,

I have an email that is sent when a[Send Stock Email] Column is updated to “True” by an action button.

The column is then changed to " " afterwards.

The problem is that more emails are sent if another column in the table is updated immediatly after the button is hit as the [Send Stock Email] column shows “true” for a few seconds before it is set to being blank.

The condition in the bot to check before firing the action is

[Send Stock Email]=TRUE

Can I choose only one column update to trigger a workflow/bot? At the moment a user can hits the button to send an email then makes notes in a longtext column in the same row and table and another email is fired until the [Send Stock Email] is set to " ".

Thanks

Phil

[Marc_Dillon]

Do this instead:

Have the Action set the column to UTCNOW().

Set the Event condition to:

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

…replace “trigger” with your column name

[Phil_Waite]

Just testing this oiut and it is still sending multiple emails whne other columns int he same row are updated

[Phil_Waite]

Hi Marc,

Thank you. That has worked. In have another email trigger action that does the same thing but prints Info instead of true to trigger a different email template. It is in the same trigger column.

Thanks

Phil

[Phil_Waite]

Is there a way of changing the expression to determine which e mail it should trigger by CONCATENATING the UTCNOW() with “intro email” for example?