Search as You Type Using ExecuteSQL
Our certified developers are sharing how to build “search as you type” functionality within your FileMaker solution with ExecuteSQL.
Our certified developers are sharing how to build “search as you type” functionality within your FileMaker solution with ExecuteSQL.
The team at Soliant has created a handy cheat sheet and a demo file that you can use to learn when a FileMaker trigger fires and when the associated action or object is affected.
The team at Soliant has created a cheat sheet (in PDF form) and a demo “playground” file that you can use to see when a trigger fires and whether the action or object that initiated it completes before or after your script runs.
Gain valuable insights about the nuances of script trigger functions in FileMaker 13 from Certified Developers at Soliant Consulting.
Get a complimentary excerpt from our book, FileMaker 12 Developer Reference: Functions, Scripts, Commands, and Grammars.
Say goodbye to context-dependent value lists for “Active” records in FileMaker using ExecuteSQL. Learn to use context-independent value lists in FileMaker.
Get more accomplished and capture most keystrokes via a script trigger in FileMaker. Follow our step-by-step process to get started.
Learn to create something flexible through consistency, leaving the least amount of maintenance required from the developer in a repetitive solution.
1/27/14: Check out the updated version of this post (updated for FileMaker 13). There are quite a few nuances in how FileMaker script triggers function. Two of the more straightforward ones are the sequence that script triggers evaluate in (e.g. OnObjectKeystroke fires before OnLayoutKeystroke) and the timing of a script as compared to the event …
Here are your next steps if you have a requirement to prevent users from accidentally editing field values in the main layout of the application.