AND operator in a conditional test

[Daryl]

How should the syntax of the AND operator be used in a conditional test. I want to format an if statement to return true for two tests. One of the tests is a NOT isblank(fieldname) test and the other is Status (Currentfieldname)= "phone1number". Both these tests tied together with an AND operator. Ive tried various ways to syntax this and cannot get it to work. Any ideas?

[cjaeger]

use brackets.

(NOT isblank...) AND (Status....)

[danjacoby]

The AND operator is a complete separation, so (for instance) if you want to make sure that A equals B and A also equals C, you can't say "If(A=B AND C...", but rather "If(A=B AND A=C..."

In your case, this probably doesn't apply, so I suspect the CurrentFieldName part is the problem -- it's a tricky sonofagun, that one is.

[cjaeger]

if calc is unstored, it's maybe not Status(CurrentFieldName) but rather the isblank() calc - it sometimes yields strange results with time and date fields.

to check for Status(CurrentFieldName), simply use the calc in a script - if it works there, then it's a problem with updating Status(CurrentFieldName).

as for the brackets - if you are using NOT in an AND/OR/XOR test , it's probably safer to include them, but i verified - it works the same without them

[Daryl]

Thanks for the response. Your right about the status(currentfieldname), a tricky one. What I was trying to do was execute a conditional script based in part on status(currentfieldname). I have a button that executes the script but the button is sitting on top of the field I'm trying to identify with the status function. Doesn't seem to work because the cursor is not technically active in the field itself. I'll just try some other way around it.

Thanks again.

[paulage77]

Can't you do a "Go to Field" before doing the Status?