Using a script variable in a Perform multiple Finds

[ljharris]

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.

[Lee Smith]

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.

 

[ljharris]

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.

 

[bruceR]

Maybe exactly like it says.

New Record/Request

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

Omit Record/Request

Perform Find [ ]

[comment]

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.