Jump to content
Sign in to follow this  
Simon Bowler

scripting "not" in a multiple find

Recommended Posts

FMP documents well how to create a search then add to it by getting a new search (ctrl "N") from the request menu - if necessary ticking the "omit" box.

I want to do the same thing in a script to include certain values from one field, but exclude values from another - eg everyone from City A who is not Occupation B. I want to use the results of a global field to define the "include" criteria so I cant "pre-setup" the search.

Can anyone help me with the script steps ?

Share this post


Link to post
Share on other sites

When you are in find mode in a script, the following script steps behave as follows:

New Record/Request - Creates a new find request

Omit Record - Changes the current find request to an "Omit" request.

So if you want to find all records where field x="hello" and field y notequal.gif "goodbye" you would do this:

code:

Enter Find Mode [ ]

Set Field [x, "hello"]

New Record/Request

Omit Record

Set Field [y, "goodbye"]

Perform Find [ ]


Share this post


Link to post
Share on other sites

Make sure that the status area is toggled to "show", otherwise the Omit script step will not work! Not so obvious.

Toggle Status Area (Show)

-bd

Share this post


Link to post
Share on other sites

LiveOak, I tested this a bunch of different ways, and the state of the Status Area made no difference at all. I'm using FM 5.0v3.

Can you send me a demo file where a hidden Status Area causes an Omit Record step to malfunction during a find?

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.