AnsweredAssumed Answered

Omit record when "complete"

Question asked by kryz on Apr 29, 2010
Latest reply on Apr 30, 2010 by Oliver

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?

Outcomes