Why can't I make If (IsEmpty) work according to the Function Reference guide?
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.