Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FileMaker Magazine

A blog by FileMaker Magazine in Affiliate Blogs

  • Entries

    553

  • Comments

    6

  • Views

    55,972

Entries in this blog

Learning to Master Looping

Without a fundamental understanding of some programming topics, it's often difficult to solve certain problems in the easiest possible fashion. In fact, one of the things I've enjoyed learning about programming is that more code isn't always better. Searching for the simple answer sometimes takes a bit more time. And, learning to solve the problem with less code is more enjoyable. In this video, I walk through a simple process of massaging some data into a desired format. While the objective of

Learning to Master Looping

Without a fundamental understanding of some programming topics, it's often difficult to solve certain problems in the easiest possible fashion. In fact, one of the things I've enjoyed learning about programming is that more code isn't always better. Searching for the simple answer sometimes takes a bit more time. And, learning to solve the problem with less code is more enjoyable. In this video, I walk through a simple process of massaging some data into a desired format. While the objective of

FileMaker Pro 19 - New Features & Functionality

On Wednesday May 20th, 2020 Claris International Inc. released a new version of FileMaker Pro. Version 19 includes just a handful of changes, but they are far reaching and will extend FileMaker's usefulness in many ways. Of the changes, the biggest is an extensible architecture which allow for portable components called Add-ons to be distributed. The same underlying technology, which uses XML, is also being used to provide support for updating a database file using a command line tool. FileMak

FileMaker Pro 19 - New Features & Functionality

On Wednesday May 20th, 2020 Claris International Inc. released a new version of FileMaker Pro. Version 19 includes just a handful of changes, but they are far reaching and will extend FileMaker's usefulness in many ways. Of the changes, the biggest is an extensible architecture which allow for portable components called Add-ons to be distributed. The same underlying technology, which uses XML, is also being used to provide support for updating a database file using a command line tool. FileMak

Setting Up Your Security

Security. While it isn't as sexy as a nice UI widget or as crafty as a really cool scripted workflow, setting up your security is something you must consider before any database deployment. When it comes to security, you can't miss a beat. If you do, then that one attack vector might be the one that bites you. And, unless your FileMaker solution is never going to connect with the network at large, knowing who can do what within your system is an essential requirement of security. Getting to kno

Setting Up Your Security

Security. While it isn't as sexy as a nice UI widget or as crafty as a really cool scripted workflow, setting up your security is something you must consider before any database deployment. When it comes to security, you can't miss a beat. If you do, then that one attack vector might be the one that bites you. And, unless your FileMaker solution is never going to connect with the network at large, knowing who can do what within your system is an essential requirement of security. Getting to kno

Cropping Images with JavaScript - Part 2

It's always nice to have someone simply show you what you need to know in order to solve a problem. There is, however, a problem with just being shown only what you need to know. You deprive yourself of the deeper level of retention that comes from self-discovery of the topic being explored. So, consider this video a comprehensive introduction. One where I guide you through the process of learning the tools of JavaScript within FileMaker Pro. The advantage is the fact that you have your own Fil

Cropping Images with JavaScript - Part 2

It's always nice to have someone simply show you what you need to know in order to solve a problem. There is, however, a problem with just being shown only what you need to know. You deprive yourself of the deeper level of retention that comes from self-discovery of the topic being explored. So, consider this video a comprehensive introduction. One where I guide you through the process of learning the tools of JavaScript within FileMaker Pro. The advantage is the fact that you have your own Fil

Cropping Images with JavaScript

Learning from a technology you don't already understand, while receiving an immediate benefit, is one of my driving reasons for creating content. In this two part series, I dig into the depths of understanding the JavaScript mechanisms natively available to FileMaker developers and learners. This first video focuses on the implementation of an internal cropping tool which uses a web viewer to provide the interaction and actual cropping. The demo file and video show you how to implement the JS l

Cropping Images with JavaScript

Learning from a technology you don't already understand, while receiving an immediate benefit, is one of my driving reasons for creating content. In this two part series, I dig into the depths of understanding the JavaScript mechanisms natively available to FileMaker developers and learners. This first video focuses on the implementation of an internal cropping tool which uses a web viewer to provide the interaction and actual cropping. The demo file and video show you how to implement the JS l

Navigational Breadcrumbs

What do the following have in common? Products with component parts, generations of people, complex study topics with prerequisites and a chain of historically related events. Yep, you guessed it, it's a hierarchy of things. Something which comes before another thing and are somehow tied together. Within any database system, this is easily accomplished with two simple fields. Yet, facilitating the navigation of the content can be accomplished in a number of ways. One of the more common methods

Navigational Breadcrumbs

What do the following have in common? Products with component parts, generations of people, complex study topics with prerequisites and a chain of historically related events. Yep, you guessed it, it's a hierarchy of things. Something which comes before another thing and are somehow tied together. Within any database system, this is easily accomplished with two simple fields. Yet, facilitating the navigation of the content can be accomplished in a number of ways. One of the more common methods

Leveraging Layout Variables

Within the world of FileMaker development, there are always those golden gems which become the hallmarks of "how to do something" - despite there often being more than one way to solve a problem. For managing lists of data, prior to the existence of the While function, the go-to custom function is CustomList. When it comes to variable output display using a portal you'll almost always reference Virtual List as the commonly understood approach. When it comes to saving user state, there's always

Leveraging Layout Variables

Within the world of FileMaker development, there are always those golden gems which become the hallmarks of "how to do something" - despite there often being more than one way to solve a problem. For managing lists of data, prior to the existence of the While function, the go-to custom function is CustomList. When it comes to variable output display using a portal you'll almost always reference Virtual List as the commonly understood approach. When it comes to saving user state, there's always

Highlighted Find & Replace

One of the most powerful features of any and all software is the ability to search and identify things which would be human impossible without computers. The ability to search for any given string and have that combination of characters be instantly presented is what has made our current world possible. In this video, we take a look at FileMaker's default Find & Replace feature and we integrate this into our database systems. We then enhance that feature by implementing a Highlighting featu

Highlighted Find & Replace

One of the most powerful features of any and all software is the ability to search and identify things which would be human impossible without computers. The ability to search for any given string and have that combination of characters be instantly presented is what has made our current world possible. In this video, we take a look at FileMaker's default Find & Replace feature and we integrate this into our database systems. We then enhance that feature by implementing a Highlighting featu

Integrated Messaging within FileMaker

Communication amongst solution users is often a desirable feature. While many companies will standardize on generalized options such as Slack, it's not your only option when it comes to messaging within a FileMaker solution. In the past, there've been a number "FileMaker only" solutions which take advantage of FileMaker's constant polling of the main data store. However, these solutions pale in comparison to what is available today. With the prevalence of super powerful browser-based Javascript

Integrated Messaging within FileMaker

Communication amongst solution users is often a desirable feature. While many companies will standardize on generalized options such as Slack, it's not your only option when it comes to messaging within a FileMaker solution. In the past, there've been a number "FileMaker only" solutions which take advantage of FileMaker's constant polling of the main data store. However, these solutions pale in comparison to what is available today. With the prevalence of super powerful browser-based Javascript

Top 10 time-saving Layout Tricks

We all love those "Top 10" videos because we know what we're getting into. It's just a list of 10 things right? But it's the best 10 things - right? Ok, well, "best" is possibly relative to what your particular daily workflow is like, but at least there's always something new to learn! Right! And, that's exactly what this video is about. It's about learning those little time-saving tricks which make it much nicer to work within FileMaker's Layout Mode. Need some incentive to check it out? Here'

Top 10 time-saving Layout Tricks

We all love those "Top 10" videos because we know what we're getting into. It's just a list of 10 things right? But it's the best 10 things - right? Ok, well, "best" is possibly relative to what your particular daily workflow is like, but at least there's always something new to learn! Right! And, that's exactly what this video is about. It's about learning those little time-saving tricks which make it much nicer to work within FileMaker's Layout Mode. Need some incentive to check it out? Here'

Server Side Related Record Duplication

Knowing how to take advantage of Server Side scripting within FileMaker is quite critical when you want the best performance possible. Of course, it makes total sense that you'll get the best speeds when working with the data where it's most accessible. The trick with creating scripts which will also work on the server side is being very specific with the context of things. There's also the very important choices of which method you're going to use. In 2018 I covered a method using a dedicated

Server Side Related Record Duplication

Knowing how to take advantage of Server Side scripting within FileMaker is quite critical when you want the best performance possible. Of course, it makes total sense that you'll get the best speeds when working with the data where it's most accessible. The trick with creating scripts which will also work on the server side is being very specific with the context of things. There's also the very important choices of which method you're going to use. In 2018 I covered a method using a dedicated

Multiple Worksheet Excel Exports

When someone asks a simple question like "How can I make FileMaker export a second worksheet in Excel?" The method you use to achieve this may not be immediately apparent. Especially if you've not worked with other programming languages like Python. Rest assured, however, you can certainly solve most any FileMaker problem as long as you're willing to take a little journey into the land of other tools. And, it's probably not as scary as you think it is. Yes, FileMaker is nice and comfortable, bu

Multiple Worksheet Excel Exports

When someone asks a simple question like "How can I make FileMaker export a second worksheet in Excel?" The method you use to achieve this may not be immediately apparent. Especially if you've not worked with other programming languages like Python. Rest assured, however, you can certainly solve most any FileMaker problem as long as you're willing to take a little journey into the land of other tools. And, it's probably not as scary as you think it is. Yes, FileMaker is nice and comfortable, bu

Dark Mode Theming in FileMaker

When "dark mode" finally creeps into your operating system, you know it's time you consider the trend and possibly adapt your FileMaker user interface as well. Although, "light mode" is still perfectly acceptable too! In this video, I walk through some of the tips and tricks I use in order to style a FileMaker user interface into a "dark mode" theme. I cover topics such as where and how to find colors, how to deal with grid settings and how to generally convert a light theme into a dark one. I

Important Information

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

I accept

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.