Hey there all. I've been struggling figuring out how to check a field and if
it's empty do one thing if it's not do another. I'm hoping someone can point
me in the right direction on how to do this. Basically I'm setting fields
from one fmp db to another. Basically if the field is empty it skips it and
on to the next step. If it's not it sets a related record field to whatever
corresponding info is in that field. Anyway I've tried several variations
still no luck. HELP! Thanks all!

phatnugs420 (AT) comcast (DOT) net wrote on (10/5/2005):

Terminology check: Validation is something that happens on input. It is
specified in the field definition.

You don't describe the process or the variations you've used, other than
that you're "setting fields from one fmp db to another."

If you're using a scripted loop, I suggest you investigate a couple of
functions you can test with:

IsEmpty determines whether the field is populated:

If ["IsEmpty ( Field_1 )"]
Do this
Else
Do That
End If

You can also reverse that with

If ["not IsEmpty ( Field_1 )"]

IsValid may also be of use to determine if the data in the field matches
the specified field type.

Either of these functions can be used in calculation fields to flag
records. See also descriptions in Help.

Matt