Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Setting OMIT/Include in script during a Find script.


This topic is 4795 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Ok, I'm working on the script below. I've been searching the forums and trying to figure out how I can make my second request in the find be a OMIT instead of an include find. Basically I want to find all records with an Assurance Flag = "No" and in the region the user selects from the custom dialog box and then omit any of those records that have "NONE" as their Assurance form letter number. I feel like I should know this but I can't seem to find the answer. Any help would be appreciated. Thanks.


Freeze Window

Enter Find Mode [ ]

Go to Layout [ “Layout #18” (DA_Master_list) ]

Set Field [ DA_Master_list::Assurances Flag; "No" ]

Show Custom Dialog [ Title: "Select Region"; Message: "Which Region do you want to view"; Buttons: “OK”; Input #1: DA_Master_list::Region,

"Region #" ]

New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ] *** How do I set this request to OMIT instead of Include ***

Perform Find [ ]

Sort Records [ Specified Sort Order: DA_Master_list::Dname; ascending ]

[ Restore; No dialog ]

Refresh Window

[ Flush cached join results ]

Posted


New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ]

Omit Record

In find mode, Omit Record script step works just like checking the Omit box in a manual find request. (Actually it toggles the checkbox, but you are starting from an unchecked state anyway.)

Posted


New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ]

Omit Record

In find mode, Omit Record script step works just like checking the Omit box in a manual find request. (Actually it toggles the checkbox, but you are starting from an unchecked state anyway.)

Thanks I will try that. I figure is was something that I overlooked. I just couldn't put my finger on the solution.

Paul

This topic is 4795 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.