Better search options?

[jprint714]

Hi,

Is there any way to do any kind of search in which one can run Find Mode through all of the fields at once (as opposed to having to search each individual field)?

I’m sure this question keeps coming up, but has there been another way to integrate Spotlight or other Mac search software with FileMaker Pro?

Thanks!

[Tanner]

This has definitely come up before. In fact I think there is something in the example file section right now. I would probably do a search in the forum and see what comes up. Basically to give a quick answer to your question there is nothing natively built into filemaker to accomplish this. That being said, it can be done with a script. So you will basically need to take complete control of your finds with a script. The other way is to make a calculation field that is basically all of the fields that you want to search and then search on that master field.

[Søren Dyhr]

This is really at matter of which version you're on since we on fm10 have this command:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.40.html

Where a looping script stuff the data in a series of requests...

On fm9 were you urged to generate enough daft request to cover all fields one for each - via a loop to make an unyielding search first, but then issue a:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.76.html#1030496

...and then issue a:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.37.html#1028916

...to replace the daft diagonally populated value.

Before that could something similar be done via:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref2.37.65.html#1029745

...or this:

http://www.filemakermagazine.com/videos/single-field-searching-its-google-like-searching-for-filemaker-pro.html

--sd