Jump to content
Sign in to follow this  
Elsie

Complex Find?

Recommended Posts

I need to find a way to find a set of records that are 'Unpaid'. I have managed to do this by finding 'Paid' and selecting the omit Checkmark. I then add a new request and enter different information to narrow the search further.

This is fine, but how do I apply the same method to a script step??

Especially if the last find criteria is defined by the user.

Any help would be greatly appreciated.

Thanks

Elsie

Share this post


Link to post
Share on other sites

Try this:

Set up a find request by going to Find, select Paid and Omit like you usually do. Then go into your script...

- Enter Find Mode (check 'Restore find requests' and uncheck 'Pause')

- New Record/Request

- Go to Field ? (? = whichever field you normally go to to refine your search. If it varies, leave this step out)

- Pause/Resume Script [](don't Specify anything)

- Perform Find [](uncheck 'Restore find requests)

This will make the script pause to enter whatever you like before you click 'Continue' to resume. You might want to include a 'Show Message' item before the the Pause/Resume script to remind you, or explain to other users, why the script has paused.

Good luck!

Share this post


Link to post
Share on other sites

You can actually explicitly specify omit in a script. The script would look like.

Allow User Abort (off)

Set Error Capture (on)

Toggle Status Area (show)

Enter Find Mode ()

Set Field (Customer, "Acme Company")

New Record/Request/Page

Set Field (Status, "Paid")

Omit Record

Perform Find()

I don't like stored finds, because you can't read the find criteria when you look at the script in ScriptMaker. The trick is that the "Omit Record" script step will check the omit box IF AND ONLY IF the status bar is shown.

-bd

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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