Jump to content
Sign in to follow this  
jprint714

Better search options?

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

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.