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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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