Check for Null

[csrjw]

In my script, I am looking for a method to skip a record if the email field contains data. For example, IF email = NULL then proceed. What is the best way to do this? Thanks.

[mr_vodka]

Loop

If [ not IsEmpty (Emailfield) ]

do stuff

EndIf

Go to Record [Next; Exit After last]

End Loop

[csrjw]

Understood thank you. Now, can I use this to loop through my records before placing the results on a layout? Or would I use my layout to do the logic?

[Ender]

Depending on what your script is doing, you might instead find those records that have something in the Email field prior to doing whatever it is you're doing to with the records.

Enter Find Mode []

Set Field [ Email ; "*" ]

Perform Find []

...

[csrjw]

This may work as well, thanks. I am trying to create some mailing labels on a layout for all records without an email address.

[Ender]

Yeah, go with a Find. This is a basic function of FileMaker that's useful for any type of reporting.