ISO FileMaker Magazine

One of the key reasons for using a database is having a single source of truth. When the possibility for duplicates enters the equation of "truth" we have a problem.

Dealing with duplicates comes in the forms of cleaning and removing them and preventing them. One of your primary tools for preventing them is to use data validation.

It's simple really. You can only continue to do this unless these conditions are met. Everything must be valid. In Claris Studio/FileMaker your options for setting field level validations can be found within the field's options. Once you've set these options you're leaving it up to FileMaker to handle this for you. To be blunt, it isn't pretty.

You, as the developer, need to take control of the situation and handle the validations in a much more graceful manner. This is where you need to know the implications of the various validation settings and how to take control with a scripted process. This is where you'll learn how to do exactly that. Watching this video will give you the necessary insight to handle your validations exactly how you'd like to.

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.

Claris FileMaker is continually adding new features in order to make things easier for developers. In the most recent release of version 19 we found a new function named Get ( PageCount ). This one function essentially emulates the combination of steps we needed to use to determine the total number of printed pages useful for adding a Page X of Y count to the bottom of a printable report. It's available for use within FileMaker Go, which is a big benefit.

However, while the addition of {{PageNumber}} of {{PageCount}} is super helpful, it does not address one of the more common scenarios we find in FileMaker development. That's the situation of a Multi-page report being generated from multiple different layouts. In that scenario we may have a cover page, a summary and then detailed output -all in one PDF report. All this data typically comes from different sets of related data.

So the solution we have above won't work for that type of report. On top of this, one of our standby methods of getting the page count of using the Enter Preview Mode script step simply doesn't function on FileMaker Go or Server. So, we need to create another method of accurately determining Page X of Y. Fortunately, that's what this video and technique file will provide for you. Yet another creative method of solving a common problem within Claris FileMaker. If you need to page number a multi-page report generated from multiple layouts then look no further!

One of the greatest joys I get from working with FileMaker is making it do something it doesn't do natively. It's sort of like always being able to say "Yes" and never having to tell yourself "No". Enjoying your sweets and treats as much as you like! There is, quite literally, nothing I can think of that can't be done just outside FileMaker and brought back in to the software.

Do you need OCR? AI processing? Serious image manipulation, complicated heuristics, complex PDF manipulation, data scraping from HTML or anything else? You name your need and a solution can be found. You simply need to be willing to step ever so slightly just outside FileMaker and your result will be found.

In this video, I'll show you the technology you need and how to integrate the technology to pretty much solve any problem. It's always just a matter of knowing where and how to look and then integrating what you find. No matter what your needs are, I can promise that short of a real-life magic wand, the info in this video will put you on the path to solving the problem you think Claris/FileMaker can't.