Hi,

Does anyone know if you can place an Is(Empty) conditional on a container field? When I try it it doesn't work. Perhaps there's a workaround?

Thanks.

Deselect "Do not validate if all referenced fields are empty" in calc window.

Dj

Thanks. What I meant though was in a script, as in: if the container field is empty do A.

But then again, I just tried a test script on it, and it seems to work!? Hmmm... I must be getting old. Thanks for the info though. When I use the conditional in a calc field (instead of a script step) I'll be sure to check it.

Well, I have never used it in a script, but I have a calc field that goes like this:

If (IsEmpty, "Container Field", "Empty Slot", "Some Text from a field")

It works fine, so I can only assume that it will work in a script. Let me know, Im interested to see.

ken

It does work, I use it often. Of course, the container field has to really be empty...

Of course, the container field has to really be empty...

What do you mean by that?

Thanks

Ken

Hi guys,

Thanks for the advice. I think I must have been on crack when I first posted the question, cause it was stumping me earlier -- then when I tried it again, it worked just fine -- both as a calc field, and using the IF EMPTY THEN logic sequence in a script.

And yes, this is based on the field being null, empty, void, and frankly, not even a shell of what it could be if it just applied itself.

The only problem I've ever had with IsEmpty() function in Ifs is when the field has *looked* empty but actually had values... spaces, carriage returns etc.