| Developers > Downloads |
Sharing the Knowledge : Resources for FileMaker Developers
FileMaker 10 TechniquesIn many ways FileMaker 10 is revolutionary : discover here some techniques that you can easily port to your own solutions > Field Name Based Calculations
Hilight Search TermsFree demo file that shows how to Google-like hilight the search terms in a text. It uses two handy custom functions: ParseSearchString, which allows to list search terms from a typical search engine. It handles multiple words terms enclosed in double quotes " SubstituteManyWithCalculation, which is a very powerful function that allows to substitute several terms in a list while applying a calculation to them (in this case, some text formatting)
Restore TabsFree demo file for a powerful technique of memorising/restoring all selected-by-user tabs of every layout No more switch to the default tab hassle (you know, the tab you inadvertently selected last time you were in layout mode...) FileMaker 8.5 is required here, as well as a Jason DeLooze custom function and FilterValuesByTest This technique has become a layout property (LayoutProperties) in the way that a layout can be set to remember selected tabs automatically.
Visible Portal RowsFree demo file to illustrate a custom function that returns the list of visible portal row numbers. Useful for a smarter interface: why should you 'go to portal row' if it is already visible? FileMaker 8.5 required. Variables Load (or Variables From Layout)Free demo file that illustrates the use of two custom functions: VariablesFromFields and VariablesFromObjects (FileMaker 8.5 required for the latter), which allow you to load general parameters in dynamically named global variables, by displaying a layout only. Let's say you have a layout on which are placed:
Only going to this layout will result in 3 different variables, $$Language, $$Age and $$DefaultPageHTML, containing respectively "English", "54", and the web page HTML code. Variables LogFree demo file that illustrates the use of three custom functions dedicated to variables: VariablesLog, VariablesResetAll, and VariablesLoadFromLog. With this technique, not only can you keep track of all declared global variables, but you can pass them from a file to another. Filter Text (FileMaker Expressions)Free demo file that illustrates the use of two custom functions for extracting text: FilterValuesByTest and FilterWordsByTest. Better than a long explaination, read what Matt Petrwosky wrote when introducing these in a video article: "The concept is very powerful and can be used in a variety of ways. Hold on to your hat as we take a look at this powerful custom function from Fabrice Nordmann!" |
