Jump to content

scripting "not" in a multiple find


Simon Bowler
 Share

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

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 ?

Link to comment
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 [ ]


Link to comment
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?

Link to comment
Share on other sites

This topic is 7224 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
 Share

×
×
  • Create New...

Important Information

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