Blog – FileMaker

A seemingly small but important change in FileMaker 15 is the addition of the Truncate Table script step. If you have developed with SQL databases, this function will be familiar to you, but you may be interested in some details and differences with how it works in FileMaker.

The FileMaker 15 product line will generate warnings whenever one of the clients – FileMaker Pro, FileMaker Go or WebDirect – tries to connect to a host that it does not recognize by a certified name.

What should you do if your FileMaker file is corrupted? Follow Makah’s guide for using the FileMaker Recovery tool and best practices to prevent it from happening again.

Get the slide deck and demo files from Wim Decorte’s “Deep-Dive Scripting, an Audit log…” DevCon session.

How do you show related records in a “portal” within a popover? Agnes demonstrates a quick and easy method using a custom function.

Makah talks about the inspiration behind the newly launched Humanitarian Committee and how Soliant completed its first pro bono project.

Anders shows how to use drag and drop plus Insert from Url on a file to split repeating fields.

In some cases, a FileMaker developer needs to determine if two date ranges overlap. That is a daunting task with standard techniques using complex relationships or a long ExecuteSQL query. In this post, we examine a simple way to determine if two date ranges overlap. It solves some real-world problems and is extremely easy to…

We frequently turn to JavaScript and jQuery for elegant user interface features we pull into our FileMaker solutions. In this post, Ross attempts to leverage this power in a proof-of-concept UI enhancement providing an interactive Export Records alternative.

There are certain situations in FileMaker development where the current FileMaker found set needs to be recreated. A good example of this is when the Perform Script On Server (PSoS) step is used. Since it runs on the server, the current context (including the found set) is lost and has to be reconstructed. I used…