4 Replies Latest reply on Apr 30, 2010 5:50 AM by Oliver

    Omit record when "complete"

    kryz

      Title

      Omit record when "complete"

      Post

      I have a checkbox on my form view, that says "Complete". The field is a number field which validates to "1" when checked. I want to have a script that will omit from view all the records where this box is checked. Here is the script I wrote:

       

      Go to Record/Request/Page [First]

      Loop

      if [SpecialOrders::complete]

      Omit Record

      End If

      Go to Record/Request/Page [Next; Exit after last]

      End Loop

       

      (by the way, do you have to do all scripting in the Script Maker? I couldn't just cut and paste my script, I had to retype it all here)

       

      Currently I have 10 records in my database. All but 2 records are marked "complete". When I run the script, it only omits 5, so 5 remain. If I run the script a second time, 3 records remain. If I run it a 3rd time, 2 records remain which is what I want to happen on the first run.

       

      Why?