Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
  • entries
    516
  • comments
    6
  • views
    35,879

Entries in this blog

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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 Magazine

FileMaker Magazine

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 Magazine

FileMaker Magazine

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. View the full article

FileMaker Magazine

FileMaker Magazine

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. View the full article

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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 Magazine

FileMaker Magazine

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 Magazine

FileMaker Magazine

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) Security: Revised Manage Security Area 02) Security: Unsigned Plug-ins 03) Security: File References by Default 04) Data: New Import Dialog 05) Develop: Recursion & While 06) Develop: Script Error Logging 07) Develop: Insert From URL Protocols 08) Develop: FMP urls version speci

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

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

FileMaker Magazine

FileMaker Magazine

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.