When you're learning a new skill or programming language, you don't always know what you might need to know. Such was the case when I received an email asking me to go through the various groups of FileMaker functions. I thought to myself, "In most of my videos, I showcase the use of certain functions, but, I've never really gone through each function one by one."
So, in this video, I do exactly that. I relay my experience and exposure to each of the various FileMaker functions. Starting with t
While barcodes have been around for decades, and we all know how fundamental they are to everyday life, it doesn't mean your last implementation is still the best way to integrate them. Technology is always changing and it's moving forward while new technologies replace older ones. A barcode which used to be in JPEG format can now be in the scalable SVG format.
In this video, I walk through the use of a JavaScript library which allows for the easy creation of SVG barcodes. This works without a
FileMaker Pro has a wonderful PDF generator. In fact, one of the biggest benefits of using FileMaker for the purpose of output is that you can make any layout look exactly how you'd like and with a few script steps, you've got PDF output which will fit 95% of the situations you'll come across.
There are, however, certain situations where knowing how to generate a PDF using JavaScript, from within a Web Viewer, will give you the exact results you're looking for.
There are a number of advantages
While FileMaker's own Layout Mode provides excellent tools for formatting data for display and output, it isn't always the most convenient for certain types of output. A prime example is a pivot table. Or, the output of data which is normally columnar formatted into a horizontal format.
When attempting to do this with native FileMaker functionality, it quickly becomes a bit of a hassle, typically including more relationships than should be otherwise necessary.
There are solutions which can mak
FileMaker 16's new Card Windows have opened the flood gates for all kinds of new methods for presenting information. Not least of which are your common dialogs and wizards. But, what about using them for navigation? Why not?
In fact, you'll find so many benefits from using a Card Window, for the purpose of navigation, you may think it makes little sense to use anything else. Especially, when you want the navigation to both hide and reveal as needed.
In this video, we walk through a wonderful t
FileMaker 16's new Card Windows have opened the flood gates for all kinds of new methods for presenting information. Not least of which are your common dialogs and wizards. But, what about using them for navigation? Why not?
In fact, you'll find so many benefits from using a Card Window, for the purpose of navigation, you may think it makes little sense to use anything else. Especially, when you want the navigation to both hide and reveal as needed.
In this video, we walk through a wonderful t
Managing user accounts within FileMaker is pretty easy and straight forward. This, however, is an aspect of access control which only applies to what a user can do within the world of FileMaker's interface.
When it comes to your own solution's user interface, it doesn't exist until you create it. And, of course, FileMaker knows nothing about what you create. It's just a tool. This means it's up to you to add your own security controls.
In order to do this, you need to take advantage of all of
In the world of serialized data, there's only been a few key technologies and XML was certainly the forerunner. It's been around since the mid 90's and was originally added into FileMaker around version 5 - if memory serves. The implementation of XML/XSLT/XPATH wasn't fully complete with compatible functions and it only works as an import and export feature via the use of an XSLT style sheet.
Learning XSLT and XPATH weren't the easiest things to do and as computing moved forward, so did other t
Hacking away at FileMaker objects seems to be the theme for a few of my most recent videos. In this video, I'm back at it and hacking again on Tab Panels. These ever so useful layout objects allow you to show a ton of information on screen by allowing users to reveal what's important to them when they want to see it.
Through understanding how individual layout objects are composed, we can take a crack at customizing them in ways in which are not current possible - at least not through FileMaker
One of the most wonderful things about FileMaker 16's release were Card Windows. While we've been able to create new windows for quite some time, the number of controls afforded those windows was limited. With card windows we can now present those windows within the main window. This provides for any other context than the current context.
You can show related records or completely unrelated records. The great thing about the card window is, like all windows, it can use any of the 3 possible vi
While creating videos on my YouTube channel for my beginner/intermediate series of videos, a viewer asked if I would create a video about migrating from using Serial values as primary/foreign keys to using UUID key values.
The process is actually quite simple, but not so obvious when you start thinking about all the scripting you might have to do for all the various tables and connections within your solution. The benefits of switching to a UUID key based system is that you no longer have worry
When FileMaker, Inc. released the new theming system for FileMaker Pro a while back, they made one of the best decisions possible for a development platform. They chose to go with an industry standard instead of rolling their own solution.
The standard they chose to use was CSS (Cascading Style Sheets). While their implementation was specific to the platform, and the whole "cascading" part didn't really apply, the choice was a good one.
Today, the upside is the fact that it's the same language
Making it easy for users to search for content is what your job is all about. If you're relying on FileMaker's default Query By Form method of searching, then many users may not know how to use the full functionality of FileMaker's search.
This is where you, as the developer, get to control how users interact with the data. By taking advantage of both FileMaker's QuickFind and the normal Query By Form, you can implement really nice features like an easy-to-use search bar.
In this video, we wal
There are all kinds of methods in which you can provide visual feedback to users. You can use FileMaker's containers fields, calculation fields, and even normal text fields.
There is, however, a great way to provide the visual feedback you desire by using FileMaker's Button Bar object. You gain a lot of flexibility with this method because it's so easy to copy and paste once you've put it into your solution. By using multiple segments in the button bar, and some creative use of hiding and condi
If you've been learning and using FileMaker for any amount of time, then you'll likely know that FileMaker also has access to JavaScript. It does this through the Web Viewer object which can easily be added to any layout.
For some FileMaker developer's they may answer the question of "Why don't you know/learn Javascript?" with a response of it either being too hard or not being able to take the time to learn it. It' only when FileMaker can't do what what needs to be done when some developers st
FileMaker 16 introduced a new and very powerful feature. Its called Card Windows and they allow you to access a totally different context than what is currently being viewed.
If you're unfamiliar with what context is in FileMaker, then to put it plainly, it's the layout being viewed, its own associated table plus all related tables connected to that layout's table occurrence. It's what the current layout can "see" in terms of accessible data. Yep, that's a bit confusing if you're not super fami
Whether you're a hobbyist developer or a full-time professional, it's important to make sure your development environment is both stable and reliable. Unless you're in the process of learning a new environment, not that many developers are keen to spending a bunch of time re-configuring their development environment.
The worst feeling in the world, while developing, is one of instability. Having that looming fear that your application or file may crash at any time is not a happy place. It's lik
Whether you're a hobbyist developer or a full-time professional, it's important to make sure your development environment is both stable and reliable. Unless you're in the process of learning a new environment, not that many developers are keen to spending a bunch of time re-configuring their development environment.
The worst feeling in the world, while developing, is one of instability. Having that looming fear that your application or file may crash at any time is not a happy place. It's lik
When it comes time to “professionalize” your FileMaker solution, this typically includes integrating a splash screen. Even if your solution is only used internally, that extra bit of branding solidifies that mental spot of recall when a user needs to communicate which database they’re using.
So what better way to say “You are here” than presenting a nice, attractive splash screen? In this video, I walk through the step-by-step process of adding a cool-looking splash screen to our ongoing projec
When it comes time to “professionalize” your FileMaker solution, this typically includes integrating a splash screen. Even if your solution is only used internally, that extra bit of branding solidifies that mental spot of recall when a user needs to communicate which database they’re using.
So what better way to say “You are here” than presenting a nice, attractive splash screen? In this video, I walk through the step-by-step process of adding a cool-looking splash screen to our ongoing projec
Within FileMaker development, there are a variety of must-know features and methods for doing certain things. You’ll be hard pressed to find these critical bits of info within the provided help.
However, these are nuances which come with the environment and really only make sense once you start to integrate them into your user interfaces. One of these “hidden” features is known as Multi-key relationships.
Using multi-key relationships, you can present data within the user interface which is de
Within FileMaker development, there are a variety of must-know features and methods for doing certain things. You’ll be hard pressed to find these critical bits of info within the provided help.
However, these are nuances which come with the environment and really only make sense once you start to integrate them into your user interfaces. One of these “hidden” features is known as Multi-key relationships.
Using multi-key relationships, you can present data within the user interface which is de
As you see and write more and more code within any development environment, you start to view code which simply looks clean and efficient as opposed to long and inefficient. In this video, we’re taking a look at some so called FileMaker “One Liners”. These are simple snippets of code which typically only take one line in order to do something pretty cool.
While the code doesn’t always take exactly one line, because FileMaker uses more than just actual code, it’s the super simple implementation
As you see and write more and more code within any development environment, you start to view code which simply looks clean and efficient as opposed to long and inefficient. In this video, we’re taking a look at some so called FileMaker “One Liners”. These are simple snippets of code which typically only take one line in order to do something pretty cool.
While the code doesn’t always take exactly one line, because FileMaker uses more than just actual code, it’s the super simple implementation
Our FileMaker Custom Function database is moving along quickly as we add more user-based features. The feature being added in this part of the series is a Tags/Tagging feature where it takes the concept of a “favorite” much further.
Rather than using a single field for tagging a record as a favorite, we’ll be using a join table and allowing the user to add as many different tags as desired. The implementation applies to “all users” of the database system, but could easily be modified to become
