Post

2 followers Follow
0
Avatar

Workflow if Field Is Not 0

Morning all,

I want an email to be sent if a Milestone is closed but the Invoice Amount field is not 0.

So far I've got:

IsChanged($State) && $State='Completed'

But I'm not sure what the script is to check if the value of the field is 0.

Thanks for any help

Martin Jubb Answered

Please sign in to leave a comment.

4 comments

0
Avatar

Hello Martin,

You can use this, if the Invoice Amount field is a currency field: $InvoiceAmount = Currency(0)

Or this, if it is a number: $InvoiceAmount = 0

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

Thanks Roland,

I think that checks if the field is 0.  What if I wanted to check that its is Not 0?

Cheers

Martin Jubb 0 votes
Comment actions Permalink
0
Avatar

Hi Martin,

Then you can use $InvoiceAmount <> Currency(0) or $InvoiceAmount <> 0

Roland Pumputis 0 votes
Comment actions Permalink