AnsweredAssumed Answered

Omit record when "complete"

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


Omit record when "complete"


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]


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.