was were added to Your Interests Panel.
Within our site, when you click a that item is added as an Interest.
You can open "Your Interests Panel" with below. Also, from the gray panel on the right (“Your Interests Panel”) you can select interests from drop-down lists, among several categories.
All interests you select can be submitted together on our contact form. This lets us know these are topics you’d like to discuss with us.
LOgiCATOR builds on the immense power of FileMaker’s native Find mode, and wraps that power in a sleek and intuitive interface. Gone are wonkish operators and confusing find and omit requests, replaced by plain language prompts and options.
LOgiCATOR just works! It automatically detects searchable fields on the current layout, omitting global, summary, and unstored calculation fields. It then presents a menu of those fields for your user to search on, along with search operators tailored to each searchable field.
The magic doesn’t end with automatic field detection. LOgiCATOR automatically creates user-friendly display names for the detected fields, so your user sees “Street Address” instead of “streetAddress” in the fields popup menu.
What’s your style (naming convention-wise, that is)? Camel case (“numberOfParts”)? Snake case (“CUSTOMER_NAME”)? Either way, LOgiCATOR is ready for you. Automatic display-name creation makes set-up a breeze.
Some developers use FileMaker’s field comment to store display names. Is that you? Not to worry, we’ve got you covered, too! If, on the other hand, you don’t use any of those conventions, or just want to override the automatic display name on a case-by-case basis, the display names can be fully customized.
LOgiCATOR uses algorithms to automatically determine whether a field should be searched as, say, a text, number, or date field, each with its own, type-specific menu of search operators. Currency, Boolean, and rating rule types are also fully supported.
If a field is associated with a value list-based control (radio- button set or popup menu, for example) on your layout, that same value list will be used in LOgiCATOR, to ensure accurate search-value entry. LOgiCATOR also watches out for invalid ranges in number, currency, or date searches.
Extend or constrain the current found set, for even more precise searching.
Save useful searches to run again and again. Name them however you like, then delete them when no longer needed.
60 seconds! That’s how long it takes to add LOgiCATOR to your FileMaker app. LOgiCATOR is a separate, fully self-contained FileMaker file. Your solution needs only a single external data source pointing to the LOgiCATOR module file, and 2 scripts. Thanks to automatic field detection, creation of user-friendly display names from your underlying field names, and automatic determination of their rules types, LOgiCATOR “just works.” When customization is needed, however, even that is designed to be easy.
(*Note: these two documents are also included with the download.)
Version 1.0 (2017-May-09): Preview Release included with first blog post.
Version 1.1 (2017-Oct-12): Official, integration-ready release.
Read more about LOgiCATOR and the technologies that made it possible in our blog series on:
Also, be sure to check out John Renfrew’s article on the Function-Separation Model:
FileMaker Pro or FileMaker Pro Advanced 16, 17 or 18, on macOS or Windows.
Copyright © 2018-2020, Mark Scott | Beezwax Datatools Inc.
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The “About LOgiCATOR” window and layout, unmodified or minimally modified only to re-style buttons, including original credits and this unmodified copyright notice and license, shall be included in all copies or substantial portions of the Software, and shall be accessible to end users from the main LOgiCATOR search-entry view via a menu command labeled “About LOgiCATOR” and/or a button on the layout labeled “About.”
THE SOFTWARE IS PROVIDED “AS IS,” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
The LOgiCATOR name, “Locate data with logical precision!” tag line, and reading-magnifier logo are trademarks of Beezwax Datatools, Inc. Beezwax is available on a consulting basis to help integrate LOgiCATOR into your FileMaker application.
Created by Mark Scott at Beezwax.
Thanks to the following who contributed and inspired:
Vincenzo Menanno, Beezwax’s director of FileMaker Development, for prodding me to abstract a mostly hard-coded search interface I had previously developed, for suggesting we gather as much information as possible from the user’s current layout, for insisting that it have a cool name, and, most importantly, for providing me the space to work on this; Julian Nadel, Beezwax president and founder, for supporting the effort (“Onward!”); Jay Gonzales at Beezwax, for ever-helpful guidance; Michael Cinkosky, Principal, Third Street Software, for long-ago but not forgotten discussions about what makes a great search interface; fellow bee, Lon Cook, for pointing out that keeping LOgiCATOR as a separate file would make integration much easier; John Renfrew of att.it{ude} for proposing the use of an on-timer trigger to eliminate the need for a file reference within LOgiCATOR (the “Function- Separation” model); and to all the beez for the daily inspiration to do excellent work.