As a long-time developer, I can certainly say that FileMaker development has advanced quite significantly over the past decade. However, I can also say that FileMaker was never developed from the ground up to have a highly robust event model. The bolt-on method of supporting events through script triggers never really planned on having too much support for drag-n-drop between various layout objects.
Fortunately, there are a number of little tricks you can apply with your knowledge of how the Fi
Hopefully, we can all agree that when something is more fully refined, it's the craftsmanship which showcases the higher quality of the work. The time and effort put into making something that much cleaner and that much more efficient.
Such is the case with enhancing FileMaker's portals. Sure, you can use portals as they're provided, and you'll certainly get all the benefits of using them "as is". But, what happens when you want your solution to be that much easier to use and that much more imp
As a long time developer of FileMaker solutions, I clearly remember the first time I personally attempted to create a calendar solution. It was not as easy as I'd initially thought. There were a TON of "little things" which you find out about down the road.
Don't get me wrong, the learning experience is well worth it and made me a better developer for sure! But, when it comes to building one natively within FileMaker today, it just doesn't make much sense. That is, unless you really only need t
Your FileMaker database is obviously designed to store data. FileMaker also provides the tools for precisely extracting that data as needed. When and how you extract the data is based on your needs. Sometimes, you need the data for an external system or API. Maybe it's needed for an export or you need the data specifically for a given visualization of that data.
In a recent video, I showed some Sankey Diagrams and how cool they are as visualization tools. One of keys to presenting a great visua
There are so many times I hear lamentations from stalwart "FileMaker only" developers who declare that you should do everything within FileMaker and FileMaker alone. This is just crazy. It's like saying you should build an entire house with only a hammer and nails. How could you ever do that efficiently? What about the plumbing? The electrical? Well, you can't. You always have to increase what you know and become familiar with other tools and newer technologies.
In this video, I showcase a very
Yes, while it's unfortunate FileMaker Go doesn't run on Android devices, we can still take advantage of what's offered on the iOS side of things. This comes in the form of Apple Maps using MapKit JS.
True, Google Maps does seem to have the slight edge when it comes to feature set, but if you need full control over an integrated mapping experience, then Apple's MapKit JS may just be the perfect solution for you.
MapKit JS, currently in beta since WWDC 2018, only seems to work on the Mac version
With FileMaker Pro development, there are so many little areas which take a bit of time to investigate and discover. One of the more important areas is that of search and making sure you provide users with the results they might expect.
While using one of my own personal tools, I found that FileMaker itself couldn't find the result I was looking for when using its own Quick Find feature. I thought that was a bit odd and had to dig into the code to find out what the real issue was.
While the is
When you work within a development environment long enough, you end up realizing where some of the pain points are for certain types of situations. For FileMaker Pro development, and many other systems, one of the biggest pain points is maintenance of a growing system. Where older code may be replaced instead of refactored.
What ends up happening is the older, unused code just sits there and only contributes to the growing mess which is what I call the "Giant Ball of Spaghetti Mess" that is a F
Over my many years of working with FileMaker Pro, I've often talked about adding in a multiple selection feature. Whether working within FileMaker's List View or working with portal rows, this can be a critical feature for allowing users to make selections and then being able to take some type of action against that selection.
Whatever the desired result is, such as processing the data, saving the set, or just being able to see a set of selected records, knowing what your options are, and how t
One of your most powerful methods of showing data, within a fully controlled manner, is using the combination of global fields and portals.
The portal object isn't simply for showing the related data as it belongs to one single record. A portal is a display tool useful for presenting whatever data you want and, however you want.
In this video, I use the example of showing multiple events based on the selection of multiple locations. Whether you need to provide a simple multi-selection option i
Solving real world problems within FileMaker can actually be quite fun. It's a certain type of challenge which includes making something fast, efficient and easy to maintain. It's the type of thing which keeps us developers and learners going.
Like most all software products, which allow for a high degree of creativity, it boils down to knowing the feature set and what's possible. When you learn the underpinnings, and you can really wrap your head around what the limitations or consequences are
Over the years, I've created a number of videos which showcase saving the state of various situations. For example, saving how many and which windows a user has open, saving the window positions and also saving the state of which panels are selected on multi-panel objects. Such as tab panels and sliders.
In this video, we revisit the topic because we now have a newer function within FileMaker 18 which makes it even easier to save which panels are frontmost within your user UI. While I personall
While it's been around for a few years now, there aren't too many developers in the world of FileMaker who have explored Node-RED. Created by IBM and made open source in 2016, this visual programming tool may start to make waves in the FileMaker world.
A wonderfully generous developer named Lui de la Parra has made it possible to use Node-RED with FileMaker's own Data API. This means that anything in the world of Node-RED is now accessible to FileMaker. This is an amazingly powerful technology
When first learning about file operations, while working with PHP, I remember having to learn about the concept of buffers and buffer streams. Fortunately, we're not quite there yet within FileMaker. But, we have arrived at the point of learning about the nitty-gritty details of understanding all the details of files and how they factor into the FileMaker universe. FileMaker 18 released support for file IO and we're certainly going to be taking advantage of it in this new world of APIs and inter
As the number of web sites hosting icon collections has grown over the years, it makes little sense to have your own collection of icons custom created at a costly premium. Typically, you can find pretty much any icon you could ever want to use and in many cases, you can even modify the icon to fit your specific needs if you need a slight variation.
With the release of Creative Commons licensing, a wide array of freely available collections and the easy ability to modify icons, you can quickly
Within every industry there's a certain terminology used to express how things work and how to accomplish things. FileMaker is obviously no different.
So, with this video, we start discussing some of the FileMaker specific terms and terminology.
Click the title or link to this article to view the video.
Afficher la totalité du billet
You may be familiar with the routine when you have multiple duplicate records in your database. You end up having to reference multiple sources. Which can be a real pain. Ultimately, you end up needing to decide which record is the master and then merging as much of the data as possible from any of the duplicates.
This is a common scenario with any multi-user database system. Where, anytime you have more than one person working on the same data, you can inevitably end up with duplicates.
It's just like when you see someone who is well-dressed, clean and sharp looking, your FileMaker user interface is no different. You're more impressed by that sharp, clean look. In this regard, not having something on your user interface is quite possibly one of the very things which makes your user interface look that much cleaner.
Portals and list views, pretty much anything which repeats itself many times, can be very overwhelming when there are a lot of options. Quite simply, if there are t
FileMaker 18 was released on Wed. May 22nd 2019. This video walks through all the new features implemented within the latest version of FileMaker Pro Advanced. Here's a short list of all the new features.
01) Hosting: FileMaker Cloud 2.0 & FileMaker ID
02) Security: Revised Manage Security Area
03) Security: Unsigned Plug-ins
04) Security: File References by Default
05) Data: New Import Dialog
06) Develop: Recursion & While
07) Develop: Script Error Logging
08) Develop: Insert Fr
So, in FileMaker, when it comes to our data and its presentation within a user friendly fashion, we can easily create a layout, set it to list view and allow users to simply start using FileMaker.
But, wait, using FileMaker itself isn't always super user-friendly. In fact, you have to learn how to sort by multiple columns by actually h
Is there really any question the PDF file format will be going away any time soon? Personally, I don't think so. And, neither should you. Adobe released their license to the technology in 2008 and it became an open standard for the world to use. Airlines use it for tickets, ticket companies use it for concerts and basically it's the digital equivalent of good old real-world paper for the digital world.
So what does this mean to you and your FileMaker database? Well, if you've got data within yo
Keeping things private, so only those who need access can access them, has been a desirable situation for as long as people have wanted to keep things private.
The only difference between the invention of invisible ink and today is trying to keep ahead of those who have the knowledge on how to access what you're trying to keep private. It's the eternal game of cat and mouse between those who seek to access what they shouldn't and those who want to keep those people out.
Within FileMaker, we no