AnsweredAssumed Answered

Why can't I make If (IsEmpty) work according to the Function Reference guide?

Question asked by LeoB on Feb 12, 2010
Latest reply on Feb 15, 2010 by LeoB

Title

Why can't I make If (IsEmpty) work according to the Function Reference guide?

Post

The following is from the FMP10 Function Reference guide concerning the IsEmpty function:

 

If (IsEmpty (LastName) ; “Invalid record” ; ““ ) displays Invalid Record if the LastName field is blank, but displays nothing if there is an entry in LastName.

 

I have tried this every way but Sunday and cannot get it to work.  I keep getting the flash screen that it requires an operator.

 

I want to have certain blank fields in a layout display some text as a prompt of what should be in the field, and then have the prompt disappear when the user starts typing into it.  This function looks perfect for that, but I seem to be missing something that is not explained in the Functions Reference guide.  I have used IfEmpty in a couple other scripts, and it has always been a single line without a lead in to identify the field, as that is included in the parentheses.

 

Is it the ““ at the end?  I thought that could be inserted by clicking on what looks like that in the middle of the Specify Calculation screen.

 

Thanks

 

 

 

Outcomes