2 Replies Latest reply on Nov 6, 2008 3:21 PM by bosslisa

    Script is omitting a record that doesn't match script criteria... why?

    bosslisa

      Summary

      Script is omitting a record that doesn't match script criteria... why?

      Description of the issue

      I'm using a simple script in an inventory database.  The script does a find of the available inventory by omitting records that are marked Sold (checkbox) and/or Returned (checkbox).  The problem is that when I run the script it omits one of my records even though the inventory item is not checked as Sold or Returned. I set it up in ScriptMaker as follows: Perform Find [Restore]: Specify Find Requests-1. Action= Omit Records, Criteria= Inventory::Sold: [*]1. Action= Omit Records, Criteria= Inventory::Returned: [*]  That's it!  I used * to designate that the Sold and Returned checkboxes be marked, is there a better way to indicate that? The script is finding everything correctly except for one record! 

        • 1. Re: Script is omitting a record that doesn't match script criteria... why?
          TSGal

          bosslisa:

           

          Thank you for your post.

           

          Your script steps are fine.  I don't have an immediate answer why this is happening, but I ran into something similar to this years ago where one record would be found, even though the criteria was not met/checked.

           

          Go into Layout Mode and add another instance of the Checkbox field.  However, do not format it as a checkbox.  Leave it as a standard field, and size it for three or more lines.  Then, go into Browse.  You will see each of your checkbox entries on a separate line.  My guess is that the record in question actually has the word "Sold" or "Returned" in the field somewhere.  This could have been caused by changing one of the values in the value list or adding a value list after data was entered.

           

          Please keep me posted!  If this is not the answer, I would like to look at the file.  I have sent you a private message (top of this page - right side - X Messages) with instructions where to send the file just in case.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Script is omitting a record that doesn't match script criteria... why?
            bosslisa
               Thank you TSGal, that solution worked!  Thanks a lot.