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]
Go to Record/Request/Page [Next; Exit after last]
(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.