Omit one field but search the others

[Nicholas]

Hello all,

I have created a search page in my database with the necessary fields for the user to search.

One of the fields on the page requires the ability to exclude any files that have matching criteria. All the other fields need to look for exact matches. The exclusion field is a checkbox set, i want to program this so that if any of the checkboxes are selected, any files with matching ones will be excluded in the find results.

This needs to be automated for the user so they dont have to click or push any specific buttons.

Hope this makes sense

Nicholas

[Søren Dyhr]

Is it really an omitted search here couldn't it be done otherwise like this, where "field B" is the field with checkboxes??

Enter Find Mode [ ]

Set Field [ Untitled::field B; "==" ]

Perform Find [ ]

Enter Find Mode [ ] [ Pause ]

Constrain Found Set [ ]

This will filter the records from the found set that have something entered in the checkboxes, and let the user enter a search criteria ontop of it.

--sd

[Nicholas]

Hi Soren,

I have tried your approach here, but am still experiencing difficulties. There are other search scripts running on the same page (to control other fields) and I'n not sure where to insert your commands into the already present script. I have tried to do so at different points but with no luck. I have other 'Set Field' commands in my script (two to be precise), and I'm not sure how the script should know that the constrain command refers to this particular operation.

I also tried to create a seperate button just carrying your script, but when it returned the find results, it was omitting any entry that had data in the field. Not the specific one which have the same checkboxes selected.

Sorry, i'm very new to FMP and databasing in general. If you can advise any further it would be much appreciated as I am so out of my depth right now

Cheers

Nicholas

[Søren Dyhr]

Could you explain the other fields you're searching in? Come up with some saying labels and the way the data is presented for the user e.g. PersonsName as text ordinary field, age as number ordinary field, skills as textfield shown as a checkbox field ...you get what I mean?? Then followed by a description of how the search should work.

But it seems your script previous of the exclution is scripted, so when having performed the find with it - you follow with this part:

Enter Find Mode [ ]

Set Field [ Untitled::field B; "==" ]

Constrain Found Set [ ]

--sd

[Nicholas]

Hi Soren,

Here is the database I have created so far. It is for a casting agency. If you click the 'find' button it will take you through to a page specificly designed for searching the database. You can check out the script command that runs when you enter this page and see what I mean about other field search commands running (The 'age' specification particularly)

Down the bottom of the find page you will see a field (titled want nots) which has a variety of checkboxes that highlight things the performers do not want to be involved with. I want the user (casting director) to use this search function filling out all applicable fields and then if the particular project involves one of the items in the 'want nots' checkboxes, they can select that and exclude any results from the find that include it.

I really hope this makes sense.

I have attached the file for you to have a look at. I know its all over the place, but like I said earlier, I am very new to all of this.

Cheers

Nicholas

CastingAgency.fp7.zip

[Søren Dyhr]

Well it seems to belong to "New Search Script". Just after the Perform Find put this:

Enter Find Mode [ ]

Set Field [ Untitled::field B; "==" ]

Constrain Found Set [ ]

...and then finally Go To Listview...

--sd

[Fenton]

I'm not sure what S

CastingAgency4.zip

[Søren Dyhr]

I'm not sure what S

[Fenton]

I'm creating a New Request, Omit Record, which is an "omitted request" for each value checked in the Want Not field. It's doing that by parsing out of a global field.

You set the global to the regular field's criteria, while in Find mode, then clear the regular field ('cause you don't want to "find" those), then go through the lines of the global field, creating a New Request, Omit Record for each.