Tweet

AsYouType Search Filtering using Script Triggers

Guest post by: Christopher Lowe

Article Overview: This example is a simple implementation of script triggers by using the OnObjectModify trigger set on the global fields that are being used to provide search criteria on the sample data.

AsYouType Search Filtering using Script Triggers

Contributed by Mike Duncan, a Lead Developer at Excelisys, Inc.

FileMaker Pro 10 introduced native script triggers as a tool for developers to utilize in their solutions. This example demonstrates the usage of a search filter, which many FileMaker developers are familiar with in complex portal filtering solutions. Now, with the use of script triggers, it is simple enough to implement the same functionality but you are not restricted to displaying results in a portal, and therefore have much more flexibility in the interface. Instead of being required to set a complex key that drives a relationship, your search script can be as simple or exotic as your solution requires. One key difference available in FileMaker Pro 10 is that you no longer need to wait for a field to be exited in order to trigger an action, allowing interaction between the user and database not available before without the use of third party plug-ins.

This example is a simple implementation of script triggers by using the OnObjectModify trigger set on the global fields that are being used to provide search criteria on the sample data. As the user types search criteria, a search script gets run, narrowing the search results in real time. Also used in this demo is the new functionality to set a field by name. This is used to allow the user to select a field to search on, which is used to set the field by name that is searched. This sounds simple enough, and displaces the need for large, complex branching “if” statements in a script editor that might have duplicated this functionality in previous versions of FileMaker.

Since these fields wouldn’t be applicable in Find Mode, we also set an object with text that displays only when you are in Find Mode that alerts the user to this fact as a reminder, as well as graying out the filter fields. This is done using conditional formatting to change the appearance of text and layout objects that are dependent on the current mode.

Script Triggers in FileMaker Pro 10 are an absolute game changer for developers in what they can accomplish. Hopefully this example provides a small peek at the potential that this new functionality provides.

Special thanks to Brian Dunning for providing the sample data used in this demonstration.

Related Articles
  Setting Up Your Cold Calling Script
  Creating an Answering Service Script
  Triggers
  Do you like running your virus scanner?
  How To Use A Tell A Friend Script To Drive Traffic Today
  The Emotional Foundation of Customer Service
  How To Throw Out Your Cold Calling Scripts
  Powerful, Persuasive and Motivating Language
  Power Words
  Good Example of Poor Scalability
  Earn Money With A Social Networking Script
  Utilize the Online Apartment Search Service to Identify 5 to 20 Apartment Projects
  5 Tips for a Search Engine Friendly Site
  All Sales People Use Scripts
  Why Should You Hire a PHP Developer For Your Website Development?
  Why Should You Hire a PHP Developer For Your Web Development?
  Identify Your Eating Triggers
  How to Really Get New Keywords With High Search Volume and Low Competition
  The Three Most Important Copy Writing Triggers for Internet Marketing
  Create Content Like A Publisher : 7 Ways to Go Beyond Concept

Article Tags: filemaker, filemaker development, filemaker pro, filemaker script triggers



Related Forum Posts
Re: SES Toronto Next Week - In that case, how about the following? Track: Get Me Up to Speed * State of Search Marketing in Canada Track: Practical & Actionable * Beyond Linkbait: Getting Authoritative Online Mentions Track: Advanced * User Search Behavior * Social Media Success * Web 2.0 & Search Engines * Giving Credit Where It’s Due: Which Campaign Sold What?
What Do You Want To Be Taught? - Hi, My name is Jeff Foster, I will be moderating this new section. I want to get your opinion on topics you would like to discuss & be taught on. I see a great need for small business owners to learn how to perform basic Search Engine Marketing (SEM) which would include the basics about Search Engine Optimization (SEO). What do you want to be taught on? Jeff
Re: Search Engine Tips and Ideas - Share Yours - Hi there, I answer this post, to start off. I am still learning a lot on all these subjects. Moreover, we have a wonderful tool to find out from previous posts. On the top right corner, use 'Advanced Search' and write 'Search Engine Tips'. It brings up all the previous posts with that information. Check it out. You will be surprised all the inherent information stored.
Amazed! - Hi Takuya, Your info is phantastic. Would it be possible to have some sort of directory to find this info at a later date? Can one find it in the 'Search' section? If I understand it right, it covers only the Subject Titles. Is that correct? I started writing this post before checking the 'Search' and all its possibilities. Kindest Regards Beat "Unlock People's Potentials!"
Re: Search Engine Optimization - If you are interested to get more information about Search Engine Optimization you can visit Search Engine Watch site gives you a great way to keep up with what’s going on in the search engine world. This site provides a ton of information about a very wide range of subjects related not only to search engine optimization, but also the flip side of the coin; subjects related to searching online.


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

Email Marketing Made Easy #11 - Avoiding Spam

Five Ways to Show Honest Appreciation

Designing Employee-Enhancing Training Programs

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.