Geeksharka Posted July 9, 2002 Posted July 9, 2002 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.
djgogi Posted July 9, 2002 Posted July 9, 2002 Deselect "Do not validate if all referenced fields are empty" in calc window. Dj
Geeksharka Posted July 9, 2002 Author Posted July 9, 2002 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.
kenneth2k1 Posted July 9, 2002 Posted July 9, 2002 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
Vaughan Posted July 9, 2002 Posted July 9, 2002 It does work, I use it often. Of course, the container field has to really be empty...
kenneth2k1 Posted July 9, 2002 Posted July 9, 2002 Of course, the container field has to really be empty... What do you mean by that? Thanks Ken
Geeksharka Posted July 9, 2002 Author Posted July 9, 2002 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.
Vaughan Posted July 10, 2002 Posted July 10, 2002 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.
Recommended Posts
This topic is 8243 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now