I have a table where several emails are sent ...

(David Hopkins) #1

I have a table where several emails are sent from workflows based on when the table gets updated…

Class table - Announced, Confirmed (both date/time fields)

When the field gets stamped with NOW(), the workflow “on update” fires off the appropriate report, either Class Announced email or Class Confirmed email.

Problem is that both workflows send an email EVERYTIME the table is updated, so I’ve started to implement conditions.

Im trying to set the following condition for each of the workflows:

([Announced Date Time] >= (Now() - SECOND(“010:00:00”))))

This would ONLY send the workflow if the Announced DateTime value is within 10 seconds of Now()

Problem is that I cant get Now()-10 seconds to work … no matter what I do…

Thoughts?

(David Hopkins) #2

#solved

(Levent KULAÇOĞLU) #3

@David_Hopkins

[Announced Date Time]>=NOW()-“000:00:10”

(David Hopkins) #4

@Levent_KULACOGLU

well that seems much easier than what I was trying…

Is there any particular reason that you’ve got the parens around the field name?

(Levent KULAÇOĞLU) #5

@David_Hopkins you don’t need to enclose the column/field name in paranthesises with writing an expression unless otherwise required with some particular functions.

(Aleksi Alkio) #6

Another condition chck method is the formula [_THISROW_BEFORE].[FieldName]<>[_THISROW_AFTER].[FieldName]. This will check if the field value is changed or not. If it’s changed, the workflow will be triggered.