Trying to get a record to omit once a checkbox is selected.

[Barbara Press]

Hello,

I have a field called "Final OK". It is just a checkbox with one option: Yes

I would like when that check box is selected that the record omits from the found total set, so it doesn't show up in my live jobs print summary. I assume it is an IF command with the omit record step, but I am having trouble figuring it out...any help is great;y appreciated.

thanks

barbara

[bcooney]

Another Barbara!

How do you create your found set of jobs for the summary? If you find all jobs where FinalOK is empty, then you have your live jobs. Or, if the find is more complex, you could constrain the found set by omitting recs where FinalOK=Yes.

hth,

Barbara

[aldipalo]

Hi and welcome to the forum.

You could set the field as a button that runs a script or you could simply have an 'Omit Record' button attached to a script. That's your preference. To set the field as a script right click on the filed and click on 'Button Setup.'

If you choose a simple 'Omit' button then when you click on the 'Button Setup' highlight 'Omit Record' under found sets. If you want your field to show the check mark Set the button to the field and make a script:

Set Field(Final OK;"Yes")

Omit Record

hth

[Barbara Press]

hi Barbara,

I see where you are going with this....rather than try to have a script to do it, just make my found set on the print / view list button, to find all records with that button not checked.... My found set it pretty lame, just all the record in a different view, but I will try to do your find method....I like it....I think I can figure this out ;-)

thanks!!

barbara

[Barbara Press]

hello,

Thanks...that helps too!!! I will try both of these options sent to me.

barbara

[aldipalo]

Barbara's method is much simpler if you are not actually working with each record. If the user needs to make changes, updates or whatever and then eliminate those records then an omit button will work. It's a matter of what your needs really are.

Edited March 2, 2009 by Guest

[Barbara Press]

Hello,

I went with altering a find that would show only my unchecked boxes and it seems to be working.

It looks like this:

Perform Find [ Specified Find Requests: Find Records; Criteria: PDF approval::final OK Omit: “==” ]

[ Restore ]

Go to Layout [ “live jobs” ]

Sort Records [ Specified Sort Order: PDF approval::name; ascending ]

[ Restore; No dialog ]

Enter Preview Mode

[ Pause ]

Enter Browse Mode

Go to Layout [ original layout ]

Thanks for all the help...

I am going to play with that other script option as well...trying to learn ;-)

barbara