Jump to content
Sign in to follow this  
ljharris

Using a script variable in a Perform multiple Finds

Recommended Posts

ljharris    0

I understand how to use the technique of set field with a Find request.

What I'm trying to do is to find on a first field and then omit on a second field  - using variables in both cases.

I don't know how to set up the Omit script step.

Share this post


Link to post
Share on other sites
Lee Smith    147

It sounds like you want to find some records and exclude certain ones from the results. See it this helps.

http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Fomitting-records.html

For example, to find vendors in the state of New York, except those in the city of Albany, start by typing New York in the State field.
2. Click New Request in the status toolbar.
3. Type criteria for the records to exclude, and click Omit.
To exclude Albany, you would type Albany in the City field and click Omit.
4. Click Perform Find.
 

Share this post


Link to post
Share on other sites
ljharris    0
15 hours ago, Lee Smith said:

It sounds like you want to find some records and exclude certain ones from the results. See it this helps.

http://www.filemaker.com/help/15/fmp/en/#page/FMP_Help%2Fomitting-records.html

For example, to find vendors in the state of New York, except those in the city of Albany, start by typing New York in the State field.
2. Click New Request in the status toolbar.
3. Type criteria for the records to exclude, and click Omit.
To exclude Albany, you would type Albany in the City field and click Omit.
4. Click Perform Find.
 

Yes, that is what I want to do  - BUT

1) I want to script it

2) the field names and entries to search on should be variable  - so basically using the Set Field by Name function to make the entry in the Find screen.  I just don't know how to turn that into an OMIT instead of Find.

 

Share this post


Link to post
Share on other sites
BruceR    154

Maybe exactly like it says.

New Record/Request

Set Field [ ........ ]

Omit Record/Request

Perform Find [ ]

mixed find.png

find with omit.png

Share this post


Link to post
Share on other sites
comment    1,391
1 hour ago, ljharris said:

the field names and entries to search on should be variable

That's a rather meaningless requirement. Tell us where would the values for these variables come from.

Share this post


Link to post
Share on other sites

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

Sign in to follow this  

×

Important Information

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