Scripting and Checkboxs

[marcs@wetmore]

I have a database of jobs that when completed, the user will check a "Completed" checkbox. I would like to sort a list to show only the items that are not checked (uncompleted). I only want this for this one list.

[Moon]

Do a find for the checked check box and click the Omit box.

[marcs@wetmore]

Sorry, forgot to specify that I want to do this in a script. Is there a way to step through each record looking for the checkbox and then omitting the record that was checked? I have been able to get it to work, sort of by going to the first record and then omitting records, but I have to run the script several times. When I do this, it sets all the other forms to only see the uncompleted jobs. I want just the list form that I am working on to display the sorted records.

[Kurt Knippel]

quote:

---

Originally posted by Marc Smith:

Sorry, forgot to specify that I want to do this in a script. Is there a way to step through each record looking for the checkbox and then omitting the record that was checked? I have been able to get it to work, sort of by going to the first record and then omitting records, but I have to run the script several times. When I do this, it sets all the other forms to only see the uncompleted jobs. I want just the list form that I am working on to display the sorted records.

---

Ok, what EXACTLY are you looking for? This seems like a simple find request issue. I think that you are looking for the unckecked records of a particular ??.

The find criteria is 2 step. The first request finds the ?? that you are looking for. The second request uses the omit option to omit the records that are checked.

[marcs@wetmore]

Fixed it myself. Here is what I did:

Go to Record/Request/Page[First]

Loop

If(Complete="Complete")

Omit Record

EndIf

Go to Record/Request/Page[Exit after Last, Next]

End Loop

Hope this helps anyone else.

[LiveOak]

This approach will certainly work, but for large record sets it is not nearly as fast as a find or better yet a "go to related record, show only related records". Kind of like driving in a wood screw with a hammer.

Toggle Status Area (show)

Enter Find Mode ()

Set Field (Checkbox, 1)

Omit

Perform Find ()

-bd