Jump to content
  • entries
  • comments
  • views

Entries in this blog


Enhancing Coded Searches

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

Updated Naming Conventions

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

FileMaker Magazine

FileMaker Magazine


Google Maps Capturing Coordinates

Well now, you really can't get away from it, because most of the Internet is pretty much dependent upon it. Yep, it's JavaScript of course. So, should you be afraid of using it within FileMaker Pro? No WAY! You should take advantage of it as much as possible. Integrating JavaScript solutions is what makes FileMaker solutions that much more powerful. In this video, we take a look at using the Google Maps JavaScript API in order to capture latitude and longitude coordinates. Along with that, we

FileMaker Magazine

FileMaker Magazine


Making Multiple Selections

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

FileMaker Magazine

FileMaker Magazine


Global based portals

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

Easier JavaScripting with Carafe

Because of the rich UI experiences which JavaScript provides within a web browser, it makes sense to take advantage of the various possibilities. The difficulty may be putting all the pieces together in order to get something working correctly. Fortunately, JavaScript isn't just for those "other developers". Those who already know what they're doing. You too, can easily integrate and use JavaScript within your own solutions. You simply need to be ready to learn enough in order to integrate succ

Getting started with JavaScript

JavaScript, it may sound scary because learning any new technology, which includes so much more than FileMaker, feels like an overwhelming amount of new learning. The great thing is, learning just a few little pieces at a time is the best way to learn - little-by-little. So let's start with just a few little pieces. In this video, I walk through the basics of how you get started with JavaScript within FileMaker Pro. How it's implemented and how to execute things. The great thing about getting

Optimized Sequence Sorting

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

Saving Panel State

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

Using Node-RED & the FileMaker Data API

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

File Input & Output

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

Working with SVGs

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

FileMaker Terminology

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

Identifying Duplicates

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. There

Hiding Buttons

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 - New Features

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

Javascript Datatables

Web browsers and their primary language, Javascript, have a very robust ecosystem. In fact, there's few solutions you can't find out in the world of Javascript. 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

Populating Form Fillable PDFs

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

Encrypting Private Data

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

Optimized Container Storage

While FileMaker may promote the low-code/no code aspects of FileMaker Pro, there's a lot to be said about knowing how to design a great system as opposed to thinking you'll end up with one by default. Especially, one which will perform under load and scale to the degree which FileMaker can. This type of knowledge is learned and simply won't come out of the box when you just start adding fields to your database. If you need to store images, or any type of heavy media, then it may not be a good i

Top 5 Offscreen UI Tricks

FileMaker Pro provides a more than capable UI surface in order to design great looking user interfaces. In fact, it's the speed with which you can create that user interface which makes FileMaker Pro so appealing. The great thing about recent releases has been the flexibility of the newer layout objects. When you combine the utility of sliders, tab panels, popovers and layout mode's various layout parts, you can further extend what you can do within FileMaker by quite a bit. This video present

Account Management

When developing a FileMaker solution, you often want a system where the distribution of labor is such that other administrators can create and manage the users of that system. It can't always come back to the developer who has the only Full Access account. When considering FileMaker's authentication methods, you basically have three options. Internal, external and third party. The external option is typically Active Directory on Windows or OpenDirectory on Macintosh. The newer third party optio

Effective Script Writing - Plus Twilio API

When you first start writing scripts within FileMaker, you're typically so focused on the feature or solution you're working on that you integrate it directly into the area where you're working. It takes a bit of time and skill, however, to quickly recognize when you need to make a particular script more generalized in nature and treat it like a routine which simply needs to take input and provide some output. Once you get to this point in your development path, you discover all kinds of oppor

Google Maps iOS & Parsing URLs

The number of features available within FileMaker Go on a mobile device is more than icing on the cake. It's just downright cool we have access to so many features. And, all without having to write super complex code. There is, however, some learning to do when it comes to interacting with URLs and web viewers. It turns out that many web sites, including Google's web based maps site, will change its url as you interact with the web viewer. This causes a problem when you supply an original url t

Hybrid Layout Design

When mobile devices first became prevalent over a decade ago, it was a pretty easy process to design for both mobile and desktop. You just made one layout for each respective device. There weren't as many variations as there is now. In fact, these days, things are much more complex. If you decide to design for smartphone, tablet and desktop you could easily end up having to create three layouts for each possible view. This isn't something I'm personally fond of. I'd much rather limit myself to
  • Create New...