Jump to content
Sign in to follow this  

Better search options?

Recommended Posts


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?


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:


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:


...and then issue a:


...to replace the daft diagonally populated value.

Before that could something similar be done via:


...or this:



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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Oliver Reid 

Important Information

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