ISO FileMaker Magazine

If you're using Claris/FileMaker for either part-time or full-time development, and you've not installed the MonkeyBread plug-in, then you're doing something wrong. Many of the most desired features for working with code, such as code folding, extended syntax highlighting, variable auto-completion, the ability to search code, line jumping and other convenience features are available for free when you install the MBS (MonkeyBread) plug-in.

In this video, I go over all the free features and how to simply install the plug-in. If you've not taken the time to investigate what the plug-in offers then you'll get a great head start by just watching this free video.

Get ( WindowMode ) can be really useful when used to vary what is shown within your user interface. This video will both introduce and show you how to take advantage of the function.

Interested in how you might use the Get ( Device ) environment function? This video will both introduce and show you how to take advantage of the function.

For all my time with FileMaker, there's this peculiar aspect of one's learning journey where small bits and pieces of information come to you in odd ways. You either happen to stumble upon them, or you're told about them through the grapevine. Not from the company itself.

While most large companies are often busy with the business of improving their software, their outbound communications about certain things aren't always prompt or highly detailed. Personally, I love what Claris has been doing with FileMaker communication in the last few years. It's a night and day situation compared to just 5 years ago. There are, however, situations where you have to hear about a particular feature from a close parter like Soliant. Even Claris themselves didn't publicize the fact that FileMaker Server 19.5 supported Perform Script on Server - running on Server - via a flag named SupportNestedPSOS. Go ahead, search for it in Google. You won't find it anywhere on any of the Claris sites (at least as of the posting this article).

Which brings me to technical issues and possible bugs. Unless you frequent the Claris Community forums, it's unlikely you've heard about the 9 year issue of FileMaker being a total hog when it comes to memory allocation for certain functions. All credit goes to Alex Zueiv for this long running discovery. At this stage, it may be known and intentional by Claris, but it certainly is an eye opener. So much so that I decided to make this video to increase awareness. Like you, I like my software to run as efficiently as possible and workarounds, hacks, what have you, I'm going to take advantage of the findings because with software, that's just what you do. You optimized until it's as good as it can be!

Finding things within any database system requires the understanding of how to make a proper query of what you're searching for. In FileMaker, this comes in the form of FileMaker's Query By Form method of searching. To fully understand all of its power, you need to explore the concept of multiple requests, omit requests, using search operators and more.

However, before you even start to get into Query By Form, you need to know what's going on with FileMaker's Quick Find feature. It's a very powerful method of searching which will satisfy most users' needs.

In this video you'll find a step-by-step approach to using the two primary forms of searching FileMaker data. First, we start with maximizing Quick Find and then move on to using FileMaker's Query By Form method of searching for data.

Portals can be used for essentially two different functions. Either data presentation or interaction. Of course, as you already know, you can also use a portal for both aspects of presentation and interaction as the same time.

In this video, we continue the growth of our Home Project database where we take a look at the core differences between a Master/Detail portal (Current found set) and one which uses a Self Relationship.

If you've not come across the differences between portal types, and simply selected one over the other, then hopefully, this information will help out. Using the information from this video you'll be able to make an informed decision about which version of a portal will fit any certain set of circumstances.

Any FileMaker solution is a growing collection of stuff to be maintained. By the nature of development, some things will be replaced leaving some aspects to be abandoned and others to be lifted up by revitalizing them. Regardless of what goes and what stays, it's best to have a plan for how things will be added and how easy it will be for your future self, or anyone else, to be able to identify those things.

In this video, I walk through the Home Project database I'm working on and I talk about adding styles to it and how it will impact my use of the theme down the road. This video provides great insight into how themes work underneath the surface and showcase a variety of good habits to have when adding styles to your FileMaker theme.

Designing within FileMaker can either be pretty easy or somewhat hard. There's no exact way to design the look and feel of your solution, but the process of implementing the design can be easier when using FileMaker's grid.

In this video, I talk about the process I use to first determine the size of a layout and then go on to refining its size so it fits within the golden ratio.

Finally, I talk about implementing my use of the grid to make the styling of objects easier and give myself some guidelines which makes the layout process much smoother as the solution grows.

Being in need of a new database system myself, I decided to simply document the process of adding new features to a FileMaker system as it evolves. This is a great way to learn about the ins-n-outs of what goes on when developing a new system. There's a number of things which may or may not make sense when you take a look into how someone else created something. So, why not make videos as the solution progresses.

In this first video, I showcase how I originally started the file and where I should start to plan for a larger solution. There's a bit more needed than simply just throwing some fields into a table. There are also a number of settings and defaults which are created by FileMaker.

This video talks about those default elements, how to deal with them and how to start planning for an easy-to-maintain database solution.