Working with Repeating Fields

Demo file:  RepeatingFieldFunctions.fp7

I began using FileMaker at the spry old age of FileMaker Pro 8, so I’ve never been through the trenches of using repeating fields to accomplish what can now be done with portals. However, repeating fields still have a variety of uses, and I’m happy to have them in my toolkit.

When I’m working with a repeating field, there are several questions I might ask of it, depending on the task at hand.

Continue reading “Working with Repeating Fields”

Good Sir William’s Heirs

Demo file:  Sir_Williams_Heirs_fp7

That old Bard, good Sir William, is nearing the end of his life. Having already provided well for his five children, he now seeks to divide his literary empire among his eleven grandchildren:

FamilyTree 1

Continue reading “Good Sir William’s Heirs”

FileMaker Read-only Fields: Lighter, Smarter, Friendlier.

Here’s an interesting interface challenge we recently faced: A client needed to place text fields on a layout and fluidly choose which fields would be editable or read-only—the same field might exist in both editable and read-only state on the same layout.

Now, here’s the challenging bit: Each read-only field must have all the same capabilities of its editable cousins—users must be able to scroll, select, and copy text, and the field control must display all rich text formatting entered.

Continue reading “FileMaker Read-only Fields: Lighter, Smarter, Friendlier.”

Inspired by Address Book – Part I: Hiding portal scroll bars

On vacation, waking up to a dreary Pennsylvania morning…

I found myself staring at the OS X Address Book and wondering, “how did they do this?” I couldn’t help compare this little application to the many FileMaker-based contact management solutions I have seen, and concluding, a bit sadly, Apple’s is nicer.

Continue reading “Inspired by Address Book – Part I: Hiding portal scroll bars”

11 Tips for #FileMakerDevCon ’11

As you may know FileMaker DevCon 2011 is just around the corner. In honor of 2011…and FileMaker Pro 11, here’s our list of Top 11 Tips for DevCon ’11:

1. Bring a sweater

Those hotels are known for cranking up the A/C. Take a comfortable layer that you can slip on and off easily to ward off the shivers as you’re sitting all morning.

Continue reading “11 Tips for #FileMakerDevCon ’11”

Managing Files with AppleScript

If you’re like most power FileMaker users, you’ve discovered that it’s a great tool for managing collections of things or for gathering disparate data sources for reporting. So you’ve probably wanted at some point to do one or more of these actions:

  • Get a list of files on your computer
  • Import a batch of files
  • Move files on your computer
  • Read the text of a file that doesn’t import correctly (e.g., HTML)

Continue reading “Managing Files with AppleScript”

Unleashing Mac OS X’s Color Picker in FileMaker

Color is one of the most important tools available to you when designing user interfaces. Using a little color can turn a drab wall of text into something attractive and readable.

Continue reading “Unleashing Mac OS X’s Color Picker in FileMaker”

Area Disclosure in FileMaker Using Sub-Summary Parts

The attached file demonstrates a technique for opening/closing areas of a record, allowing a user to hide the information they don’t want to see.

FileMaker File:  DisclosureAreas2.fp7

Continue reading “Area Disclosure in FileMaker Using Sub-Summary Parts”

Charting from the Active Field

Neither I nor my client can anticipate every chart that the solution’s users might want to see. A user’s desire to view a high-level visual representation of their data can be spontaneous and idiosyncratic. This technique allows for the user to create an ad hoc chart, albeit within narrow parameters (i.e. the chart is simple, presents only counts of values, and is pre-formatted).

FileMaker File: ChartActiveField.fp7

Continue reading “Charting from the Active Field”

1 8 9 10 11