my script to prompt an email if field "in progress" is not working HELP.

[Nestor]

Good Morning All,

hope everybody is having a wonderful day in this sunny day in california.

I have a problem with one of my script, hopefully its something simple.

I have a script trigger on object modify.

i have a wo status, and the idea is that if the user changes the field to "in progress" my script will check to see if the AD User is Empty if it is i want a custom dialog to come up. but if its not empty i want my script to send an email.

The problem that im having right now is that it doesn't matter if the field is empty or not, but it sends the email no matter what. I believe my ((is valid function is that the right one to use, but then again i don't know what other function to use)) any ideas?

Thanks

[Raybaudi]

Try:

... and not IsEmpty ( WorkOrder::ArtDirector ) ]

[mr_vodka]

If [ WO Status = "In Progress" AND not isEmpty ( Art Director ) ]

Send Mail

Else

Custom Dialog

End If

*Edit: Sorry Daniele

Edited April 22, 2009 by Guest

[Nestor]

THANK YOU SO MUCH.. IT WORKED...