ISO FileMaker Magazine

It happens to all of us. We get stuck in a rut, where we keep repeating the same task over and over again and we just can't "unstick" our brain from doing things a certain way. Sometimes, when you pass the problem past another person, they come up with new and creative ways of doing things.

This video is based upon a situation where the need was "a quick way to assign any one of multiple categories to multiple items" - in this case articles. The solution was, to use a dedicated palette. By using a new window as a palette, you can capture a category and assign it to a value within another window.

No matter what type of data you're working with, there may the time when you need to make assignments to records shown in list view. Be prepared for that occasion by watching this video!

Ever since FileMaker 8 was released, a variety of techniques have cropped up which allow for more and more control within a FileMaker solution. Whether you're talking about managing interface graphics, or how you name your scripts, there are all kinds of ways to use variables.

This video presents an overview of the techniques I covered within 2006 which lend themselves to making FileMaker a much more powerful tool for creating and managing database data.

I list my Top 5 most favorite techniques and provide an extended look into one technique which was only discussed as a tip in one of my most recent mailings. Start this upcoming New Year with a great head start on making the most of FileMaker. Best Wishes on this Holiday Season and Happy FileMaking!

Sometimes, we all get stuck in the routine of doing things a certain way. New methods may appear as time passes by and unless we take the time to evaluate our own methods, we miss out on the power and elegance of these new ideas!

I've been using FileMaker 8's variables since they were introduced. However, I never thought to use them for graphics. While storing a lot of LARGE graphics within memory is not advisable, there's nothing that says you can store smaller interface graphics into the client memory space. In fact, this makes your interface more snappy when it comes to performance. You're not taxing the server for a transfer of an image each time it's shown.

Of course, FileMaker may have it's own internal caching of graphics, when it comes to displaying layouts, but why not take advantage of any system that helps manage or make things more dynamic? This video presents a great solution to providing a flexible system of displaying icons and graphics. Special thanks to Stephen Dolenski of FMForums.com for sending this in. This tip earned a whole year's subscription! - (so be sure to send in your own cool FileMaker techniques)

Whether you've just started working with FileMaker, or you've been a developer for a long time, the following suggestion is always a great way to approach the design process - simply ask questions!

Most every solution to your development process can be answered, yes answered, by asking a question. If you think you don't know what you're doing, you can always ask "Do I need to seek more knowledge?". If you think you already know it all, you can ask "Does my brain have enough space for this ego?" - or some similar such question.

At every critical point in the process, it may be as easy as asking yourself "Will users really search for data based on a zip code field? Do I need all those fields or will one Address field for the whole address work just fine?".

In this video, I start the process of breaking down the development of a new FileMaker database system. I decided to document this process and the tools I use to do this. Surprisingly, (or not so much) I end up using Excel to outline the structure of this new database. Spend a few minutes watching this video and see if you pick up a few tips about making the brainstorming process a bit easier!