• As-You-Type Window Naming and Selection

    By Daniel Wood, 14 March 2011

    In applications such as Mail, you may notice that window names can be dynamic, dependent upon the contents of a field. In the case of Mail, the subject dictates the window name. In this article I'll demonstrate a way this can be replicated for FileMaker, and more importantly, how these dynamic windows can easily be selected again once created…

    Read more →
  • Thinking Outside the Loop

    By Daniel Wood, 3 March 2011

    If you have spent any time developing in FileMaker, or programming in almost any language, you will be familiar with the concept of a loop. When scripting your loops you probably have a favorite method that you use. This article presents and compares a number of looping techniques that can be used in FileMaker in an attempt to locate the fastest method...

    Read more →
  • A Lightweight Cross-Tabular Data Entry Method

    By Daniel Wood, 21 February 2011

    One of the shortcomings of FileMaker is its inability achieve easy cross-tabular reports and data entry in a normalized structure. There are various techniques to replicate cross-tabular interfaces, but they often involve many relationships for either the columns/rows, or are for display only. The goal of this article is to present a lightweight method for cross-tabular data entry using as few relationships & fields as possible...

    Read more →
  • Hide Custom Menu Elements Dynamically

    By Daniel Wood, 19 February 2011

    When FileMaker 11 was released, one of the lesser documented changes in behavior concerned the defining of menu names when dealing with Custom Menus. When any menu element has an empty name, an interesting thing happens...

    Read more →
  • Quick Tips: Commenting Your Value Lists

    By Daniel Wood, 18 February 2011

    Pretty much everything in FileMaker comes with some form of comment box to let you add more information - such as fields, menus, custom functions, calculations, scripts, and the graph. However the one area lacking in a comment box is value lists, unless that is, you think a little outside of the box…

    Read more →
  • Ditch those Flushes, Use Cartesian Join Instead!

    By Daniel Wood, 31 January 2011

    This article explains why Flush Cache can be detrimental on performance, and offers an alternative and more efficient method for refreshing relationships...

    Read more →
  • Ditch those Flush Caches, Use Cartesian Join Instead!

    By Daniel Wood, 29 January 2011

    All too often, the Refresh Window script step is used with the 'Flush Cached Join Results' option checked. Sometimes this is through lack of understanding, but other times it is required to refresh those pesky relationships which have trouble re-evaluating. This article explains why Flush Cache can be detrimental on performance, and offers an alternative and more efficient method for refreshing relationships…

    Read more →
  • Quick Checkbox Selection of Portal Records for Users

    By Daniel Wood, 19 January 2011

    There are many ways in which users can select records, so that each user can keep their own unique selection. This particular method uses a portal showing related records as a selection tool. The main technique involves using a value list & checkbox to easily achieve selection with no scripting required…

    Read more →
  • The Case of the Disappearing Sub-Summary

    By Daniel Wood, 15 January 2011

    Recently I was working on building a large layout which is used for both printing and data-entry. One of the requirements was I needed to show a lot of "private" information that the data-entry person needed to see, but was not to be printed. The issue was solved using a very cool property of sub-summary parts…

    Read more →
  • Creating Tidy Popup Windows

    By Daniel Wood, 9 January 2011

    Using Popup windows is common FileMaker technique for showing more information, managing dialogs, and running wizards to name a few. However, all to often little care is given to the aesthetics of creating and positioning a popup, leading to an unpolished and half-finished feel. This article gives some pointers on how you can create popups that are clean, efficient, and correctly positioned.

    Read more →

1 2 3 4 5 6 7 8 9