2 Replies Latest reply on Jan 28, 2010 7:46 PM by russcb

    Looking for a Script that finds Empty fields

    russcb

      Title

      Looking for a Script that finds Empty fields

      Post

      I'm a newbie trying to write a Script that Finds records that have a "Email" field which are empty (null).

       

      I am having trouble setting the criteria for the null field (Invitations::Email)

       

      So far I have ;

      Go to Layout[MailoutList"]

      Enter Find Mode[] *

      Perform Find[]

       

      *The Specify Find Request is : Find Records.. Invitations::Email:[" "]

       

      Can anyone please help? I'm using FMP Ver 7.0v3 on Windows XP SP3

       

       

        • 1. Re: Looking for a Script that finds Empty fields
          LaRetta_1
            

          russcb wrote:

          I am having trouble setting the criteria for the null field (Invitations::Email)

           

          Go to Layout[MailoutList"]

          Enter Find Mode[] *

          Perform Find[]

           

          *The Specify Find Request is : Find Records.. Invitations::Email:[" "]


          If you look at the symbols you can insert (when in the Find Request), you will see that = means 'find exact match'.  And that is true is something is typed after it.  And that is true if you are searching for nothing.  So the = symbol alone means find where the field is empty and any time you wish to search for an empty field (whether manually or scripted), just type = into the field.

           

          And all you need are two steps (no Enter Find Mode needed):

           

          Set Error Capture [ On ]

          Go To Layout [ MailoutList ]

          Set Error Capture [ On ] 

          Perform Find [ Restore ] ... meaning you have checked 'Specify Find Requests.'  

          Including your error trapping here.

           

           


          • 2. Re: Looking for a Script that finds Empty fields
            russcb
               Doh!:smileysurprised: Thanks LaRetta! I should have known that. Sometimes you cannot see the forrest for the trees ( or something like that).